SQL Server Forums - criteria in a seperate file

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums

Profile | Active Topics | Members | Search | Forum FAQ

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

criteria in a seperate file

Reply to Topic

Printer Friendly

Author

Topic

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 06/15/2005 : 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

USA
1537 Posts

Posted - 06/15/2005 : 08:11:56

How do you know where one number starts and another ends so you can put in the comma?

Jim
Users <> Logic

Edited by - JimL on 06/15/2005 08:12:11

JimL
SQL Slinging Yak Ranger

USA
1537 Posts

Posted - 06/15/2005 : 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

Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.02 seconds.