Tag Archives: data compare

t-SQL to find top X toppers in each subject from marks table

rank() function in SQL can be used to find such results in SQL! Here is the simple example for FUN 🙂 Reference/ New features in SQL 2012: https://vijredblog.wordpress.com/2014/02/18/tsql2012-less-frequently-used-features-revision-01/

Posted in Script, SQL, SQL Query | Tagged , , , | Leave a comment

SQL Data Compare Tool

Last week, I was working on merging the data (multiple tables) between 2 SQL Servers, I had to analyze number of rows which are identical on both Server, which are only in one of the Server and which are different. … Continue reading

Posted in Productivity, SQL | Tagged , , , , , | Leave a comment