Thnaks:-) Know the precision for the time function GETDATE(), wonderful ideas for future precision using.

good artical..

but it's good useful for the dynamic sql when using 'sp_executesql'

Thank you berry..

Let's take a example:

CREATE TABLE A

(

ORDNUM VARCHAR(20),

SERNUM VARCHAR(20),

ORDQTY INT,

SBOXID VARCHAR(20)

)

GO

CREATE TABLE CTRL

(

CTRLID VARCHAR(15),

CTRLN1 INT,

CTRLNM VARCHAR(10)

)

GO

DECLARE @N INT=1;

DECLARE @N2 INT;

WHILE @N<=5000

BEGIN

SET @N2=@N/100+1

INSERT INTO A VALUES(@N2,@N,10,'')

SET @N+=1

END

GO

INSERT INTO...

Thanks for everyone's response.

Cade: Just want to confirm: are you on SQL Server 2005? If not, then what version are you on?

------------

HI Barry, the sql server servion is 2008.

One...

thank you barry..

the source code about the sql is:

DECLARE curMultipal CURSOR LOCAL FOR

SELECT T.ORDNUM,T.ITMNUM,K.CLIMOD,T.CLIMAT,COUNT(T.SERNUM) AS QTY FROM A T INNER JOIN B K ON T.CLIMAT=K.CLIMAT WHERE T.SERNUM...

very good artical about the lower effieiency cursor, but i still a bittle confuse how it work and it seems that it cannot avoid to use the cursor completely.

There is...

so glad to join this article and saw many splendid ideas about the performance tunning tips..

But we should think about the fragmentation about the database table.It will reduce the performance...

Hi Kenney,

[font="Verdana"]I see..Thank you very much for your explanation.:)[/font]

Cade

Vert Cool~~

But I still cannot understand why deleting items from the cteDV will delete items from the base temporary table, or is this something specific to the CTE statemen.

So amazing...