Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.
2013-02-19
7,841 reads
Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.
2013-02-12
4,791 reads
Hi wenny,you can also use a full outer join like thisSELECT distinct CASE ISNULL( t2.[name],'') When '' THEN t1.[name] else t2.name end AS name, t1.feb, t2.March FROM t1 full OUTER join t2 on t1.name = t2.name you should compare speed if the two tables are large.Cheers,John R. Hanson
2004-04-15
Thankyou sooo much for your help, I am sure I will be back to ask more questions as time goes on.
2004-01-18
Attempting to get column name from varchar staging table and data type from target table.Query works, but need ideas on processing rows returned to select IsDate, IsNumeric .. based on data type.select is1.column_name, is2.data_type from information_schema.columns is1, information_schema.columns is2 where is1.table_name = 'StagingIn and is2.table_name = 'Target' and is1.column_name = is2.column_name and is2.data_type <> […]
2004-01-18
1 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers