Posted - 06/16/2010 : 02:13:09
| Hi All.
I have a table which has following colums with more than 10 million records.
Now situation is I have some 3000 rows in excel with COLA format mentioned with above table. I need to check the occurence of every row in excel file to our actual sql table as below format.
COL A No. of occurence with actual sql table
I can see with count(*) I can count the no. of occurences in actual table but not sure how to fetch the corresponding value for COLA. I can define the logic to fetch the output as above mentioned format but not very much handy with T-sql scripting.
Could anyone please help me asap.
Thanks in advance.