SET IDENTITY_INSERT tablename ON

insert into tablename

(

columns

)

select

columns

from tablename

SET IDENTITY_INSERT tablename OFF

you can try this

Good day,

You give me a light in my darkest side of coding. you save my for this situation. I wish i could return the favor to you..

i'll try you're...

Good day,

Luckily i run a query just to view the DDL for the GenerateSequenceNo

here is the code...

...

@ssCrazy

You're right.. Do you any idea about this prob?

another option iam thinking right now is to create a udf that will call this executable sp. and the result will be call to my sp that will update the...

Good day,

Sad to say that i dont have the previledges to view the DDL of spQuery_GetSequenceNo that given to me.

@ChrisM@Work

is set the value of the DPNUmber,amounttobepaid,paymentdate once the...