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 |
|
shajimanjeri
Posting Yak Master
179 Posts |
 Posted - 2007-08-12 : 09:47:52
|
| Hi,I have a txt file which contain some mobile number. Its like first row with first mobile number, second row with second mobile number, Third row with third mobile number and so on.Now hear how to cont it in classical ASP how many mobile number is there in the txt file. Just I need the total number of mobile number in the txt file.Thanks in advanceRegardsShaji |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-12 : 14:23:03
|
Use openrowset to open the file and use either COUNT(*) or COUNT(DISTINCT PhoneNumber)
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
Count in the txt file