SSIS (Integration Services) can be set up to import batches of files. I'd recommend looking into that as an option.

rsheppick (7/10/2008)

After posting this i figured that out...

The weird part, the website guys are using some sort of php script to connect and obtain the infomation from me.

If i...

You don't need the quotes in the execute command. The parameters are integers, not strings.

A possible way to do this a bit more easily than from a VB app, is do it in Management Studio. You can even run the script on one...

The best way to do this is run a trace on the server. You can set that up with either the Profiler (you can get to that from Tools...

Then you'll need to make sure the account running it has access to RPC and to the services associated with MSDTC.

And now I know that you've seen "Harvey". And you know that I know that you've seen it. And I know that you know that I know ......

Look up "DateAdd" in Books Online.

Well, for one thing, left outer join is usually faster than Where Not In.

Second, you're speeding it up with all the NoLock hints. Risking dirty reads (potential for junk/wrong...

MSDN.com has an article on running DTS packages from SQL 2005, and on upgrading from DTS to SSIS. That's the best place to start.

I think I would do the second table more like a ledger.

create table Trade_Details (

DetailID int identity primary key,

DetailDate datetime not null default(getdate()),

TradeID not null references dbo.Trades(TradeID),

TeamID int not null...

Try this:

declare @ipinput char(5)

select *

from dbo.ZipCodes

where ZipCode = @ipinput

and right(@ipinput, 1) in ('3', '7', '8')

First, you should store Zip Codes as character data, not as integers. Some Zips begin...

There's an article here: http://www.sqlservercentral.com/articles/TSQL/62867/

It has data on efficient string splitting.

This will probably perform better:

select a.*,b.col1, b.col2, b.col3

from tablea a

inner join tableb b

on a.col1=b.col1

union

select a.*,c.col1, c.col2, c.col3

from tablea a

inner join tableb c

on a.col2 = c.col2

union

select a.*,d.col1,...

Sounds to me like your copy of Management Studio may be corrupted. I'd uninstall and reinstall and see if that fixes it.