may be this could help

http://support.microsoft.com/kb/238477

you're welcome

i see no problem with performance... but im not quite good at tuning and performance

i saw the execution plan and Client Statistics of these two queries

select MY_DateTime_Field from My_table

select convert(datetime,convert(varchar,MY_DateTime_Field,112))...

instead of

use this

da.fill(ds)

the dataadapter fills the dataset with the resultset of your stored procedure , if your stored procedure returns three resultsets, then the dataadapter will fill your dataset with...

It's functionally equivalent to a cursor. The WHILE loop really will not buy you any perf advantage here. That said - pulling things out in descreasing row order will get...

This is bound to go *boom* if ANYONE is doing inserts on the table while you're running this loop.

What is the inner stored procedure doing? This approach tends to be...

i would do something like this

DECLARE @MAX_ID int, @CONS int, @CURRID int

SELECT @MAX_ID=0, @CONS=1

SELECT @MAX_ID=COUNT(*)

FROM YOUR_TABLE

WHILE @CONS<=@MAX_ID

BEGIN

SELECT @CURRID=ID

from (

select ROW_NUMBER() OVER (order by ID desc) ROWNUMBER,*

from YOUR_TABLE

) a

where ROWNUMBER=@CONS

if @CURRID...

if the system does crash, upon power-up the transaction log is reviewed and any transactions that havent been checkpointed are now written to the database.

why are you using size = -1?

just dont specify the size value? i think that would work

it would be helpful if you post an example of your procedure

i think this could help...:-)

INSERT INTO #Test_Destination

SELECTa.*

FROM#Test_Staging a

left join #Test_Destination b

on a.id=b.id and a.Date=b.Date

where b.id is null

DELETE #Test_Staging

FROM #Test_Staging a

inner join #Test_Destination b

on a.id=b.id and a.Date=b.Date and...

anytime 🙂

you're welcome 🙂 im gald i could help

see you next time.

no problem :), i guess we all are here to help each other.

well im not sure if its like .NET but, when you execute a function it has to be...

i've never used Delphi before, so im not quite sure what the problem is... but i read a little, and i found something called TADOQuery... maybe you could execute a...