thanks, since this is a third party software, changing the code is a bit of a problem. Will addition 2.0g of RAM, since it is cheap to get, help at...

Thank guys for the explanation....I did learned a lot from it.

so if I put the order by in the view...both select statement in general perform the same?

thanks

Ramesh,

thank you very much for looking into this...It would be easy if the database is sql2005, but unfortunately, I'm dealing with sql2k...which make a bit more difficult. I had try...

Hi dva2007,

this is the track of the stock which has come first at what cost and stock which is going out at what price base on FIFO (First in First...

thanks...I finally figure this out after long search.

OleDB...connection.

INSERT INTO tempTlogFileList

...

Paul,

I get the same error...Here are a bit more detail on execute sql task:

General tab:

resultset: None

connectionType: OLE DB

connection: UserServerConnection

...

Just came across your article and fine it very useful tools for me to learn sqlis. I have a problem with Execute SQL Task in the loop container:

Insert into...

This should get you started.

http://www.sqldts.com/default.aspx?219

Hi David,

I try your post and get an get the following syntax error: Syntax error converting the nvarchar value ' ' to a column of data type int. If seem to compute...

May want to take a look at this site. http://support.microsoft.com/default.aspx?kbid=301202

what is the [datetime] look like? You  may want to convert it.

select count(*) from table where convert(char(10),datetime,121)=convert(char(10),getdtate()-1,121)

select count (*) from order1

result=538790

select a.orderid, b.orderid from order1 a left outer join order_old b on

a.orderid=b.orderid order by b.orderid

Not sure what file you want. But used BCP if you want to copy to flat file.

Have you try to re-name the column first and then drop it?