Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Frozen_123
Starting Member
33 Posts |
 Posted - 2010-06-16 : 02:13:09
|
| Hi All.I have a table which has following colums with more than 10 million records.COLACOLBNow 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 dffrddd 10 BRdertt 2bt45fcdw 5I 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.Regards,Frozen |
|
|
pduffin
Yak Posting Veteran
68 Posts |
Posted - 2010-06-18 : 20:28:04
|
| Not sure that I understand your question or if it's harder than I imagine. If it's the simple answer then maybe this will work:select colA,count(*)from <Your Table>group by colA |
 |
|
|
|
|
|
Data Matching