Hi,

Whats the difference between delete and truncate then..?

i hope this is the difference...i have read at some where that

restoring the data back is possible if we truncate the table where...

HI,

Below is my DDL....Please take a look at this before i say my requirements...i am done with this script....but as you asked my DDL, i show you mine...

CREATE PROCEDURE...

Hi,

the miskate where i did was in selecting the query..my select query works fine but when i declared it as cursor, since the column values were getting dynamically...in some way...

Hi,

thanks for that buddy....i got about the modified details....but is it not possible to get the table structure of previous....i have source control tooo....

Hi,

I got it fixed...

Thank you buddy.......

yeah pal, i know i dont need a cursor to get this done....but for decrementing a column value which is passed dynamically , i came to know that i should...

yeah thats why i use stored procedure....i pass a parameter value dynamically for decrement... decrement is like...for example: if my dynamic value is 90 if my select query chooses 5...

Hi,

yes, i need dynamic query because i have to pass the table name and column name values through parameters as i shown in the query....i need cursor because i need...