Viewing 5 posts - 1 through 5 (of 5 total)
Nice article to provide help for parsing delimited values, but I like better XML version provided by some user in the comments which is simpler but maybe more resource consuming.
But...
August 10, 2010 at 6:30 am
Create your DTS package and save it as VB script, next open it in VS2003 or VS2005 and allow VS to convert it. After that you will have all you...
August 21, 2006 at 5:27 am
If your process is long time running process maybe you can send email to client when it is done. DTS package has this possibility or you can use SQL command...
August 18, 2006 at 7:29 am
I think that in your article the biggest difference in speed between cursor and while loop exists because of use of temporary table. Have you tried to use cursor instead...
July 21, 2006 at 6:08 am
I think that two aspect of stored procedure are very important:
Optimization, after you run your stored procedure for the first time it is optimized and next time it works faster because server...
February 3, 2006 at 7:09 pm
Viewing 5 posts - 1 through 5 (of 5 total)