insert into ##temptable select relevant.columns from table1 inner join table2 on pk1 = pk2 where table1.createdate = yesterday and (table1.col1 <> table2.col1 or table1.col2 <> table2.col2 or ... ) You will then have all of the data needed for your email easily accessable.
2003-05-06
Since you are naming each server in turn then INSERT INTO ##all_logins SELECT name,'jupiter' FROM jupiter.master.dbo.sysxlogins WHERE name like '%Ivanov%' INSERT INTO ##all_logins SELECT name,'saturn' FROM saturn.master.dbo.sysxlogins WHERE name like '%Ivanov%'
2003-05-06
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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