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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 criteria in a seperate file

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-06-15 : 07:58:56
Gary writes "I am consistantly given a .txt file with thousands of numbers. I use these numbers in a query, and have to go through each line inserting a comma after each number. As you can imagine, I don't necessarily 'dig' this process, and would like to refer to the txt file from within the query without having to modify the information. I've had some friends tell me how to do this through writing a seperate application, but can't this be done through using just a query?


Gary Vickery"

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-06-15 : 08:11:56
How do you know where one number starts and another ends so you can put in the comma?

Jim
Users <> Logic
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-06-15 : 08:40:37
My Guess is these these are tab seperated.
Use bulk insert to drop the .txt into a SQL table then query that table.

Jim
Users <> Logic
Go to Top of Page
   

- Advertisement -