Compare Parallel Data Streams

This a script to compare two parallel data streams, in my case production and QA.  Two extracts were created and a mapping table was created as a look-up between old and new recordids.  A final table TestResults was created to hold the results of the comparison.  The comparison table names and join syntax are controlled […]

2003-08-21

132 reads

Blogs

Quick Blog: Making the Power BI PowerShell cmdlets easier to use

By

One of the top reasons I love PowerShell so much is that from the...

Trouble writing? Join the club. #JustWriteTech

By

I was talking with  a couple of excellent SQL people* recently, and we were bemoaning...

Check Query Progress with Live Query Stats

By

This is something I touched on back in 2017 a little after the Live...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

update table b if b.time falls between any of table a rows start/stop

By delizat4g

I'm trying to find a way to rewrite this dusty old cursor set based,...

Check if number exists in a column

By tim.stutzman

Hello, I am pulling some address data from a legacy system and it has...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers