[T-SQL] How To implement the SCD with Row level log using CheckSum option in Tsql

---

How To implement the SCD with Row level log using CheckSum option in Tsql Posted: 13 Oct 2013 05:40 PM PDT Hi Friends,I want to implement the SCD with row level log using CheckSum optionMy Source table : Emp_Source(EId ,EName,Sal,Deg,Staus) -- here staus is add/update/deleteMy Destination Table : Emp(Eid (primarykey) ,E name,Sal,Deg,Flag,Start date,End date,Check_Sum_Value) here flag : y/NMy Log Table : Log(EID,Erronumber,ErrorDes) Now my aim is in source level any error is coming then go to that row in log table other wise record go to destination table with check sum option i.e SCD.Will you please any one guide me how to i have implement this SCD with row-level log using check sum optino in T-sqlRegards,Nalini

Script Help Posted: 13 Oct 2013 05:55 AM PDT Hello. I have a portion of a table that looks like what I've listed below. This is just a small subset of the data that I'm attempting to retrieve, but this displays what the structure looks like. What I would like to do is have a script that can pull all but the top two lines. So, I want to get everything that's below the line that contains "E-Mail". Hope this makes sense.Right now, I can pull lines 3 and 4 by using the script below, but I would like also to capture the last line in my results. Any ideas?select Column1, Column2, Column3, Column4from Tablewhere Column2 in(select Column1 from Tablewhere Column1 = '22701')Column1 Column2 Column3 Column48106 NULL Top 810622701 8111 Test2 810626892 22701 Extra1 810626893 22701 Extra2 810626894 26892 ExtraSub1 8106Thank you!

You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610