the resolution didnt solve it.

it decrement the first row successfully. when moving to second row instead of decrementing it to one it decrements it to two , then to third...

8 months.:angry:

thanks. Sorry i didnt understand what you mean by this

WITH Updater AS (

pls let me know.

Thanks for your help. Really appreciate that. I dragged in the project that is at its end before go live..

I ran the script and the out put that appears in...

hi , thanks for it. here is the details . table design, stored procedure that should be called to do the update based on composite primary key to get a...

thanks for your quick response. really appreciate that.

This will solve it but urpose is not achieved. i am using a cursor to fetch records with combination of primary keys...

Hi,

Finally i got a breakthrough in migrating DTS Packages from SQL 2000 to SQL 2005 as Legacy Packages.

I found a software called DSTSBackup 2000 which is freeware and you...

Hi,

I have downloaded migrationwizard tool from Microsoft website. I want to transfer DTS packages from SQL 2000 to SQL 2005. Since i am a newbie so

When i click on...

Thanks for your help.

It work

Cheers

Hello Chris,

Its a nice way to audit the db. I am a newbie and also new to SQL Server. please can you explain how to use this script in little...