UPDATE with Call to EXEC SP

[richardy]

Hi,

I need to use an update statement to update a given field with the results of a stored procedure call (unique id). Theres multiple items in the table without a value

so its something like

update mytable set myid=exec getmyid, @myid output where myid is null

but obviously this doesnt work I can declare @myid and then the exec will return the value correctly to that, and I can set myid=@myid but then the same id would be used for each record which also doesnt work...

Any solutions would be appreciated.

Regards,

Richard.

 

[AtomicWedgie]

Hi,

not sure what you want exactly but try and look at

@@IDENTITY

in books online

Regards,

Atomic Wedgie

 

[richardy]

Hi Atomic,

Yeah I need to call my own identifier sequence as its none standard so cant use the sql identity columns

I guess I need some thing like


update mytable set myid=select (exec getmyid, @myid output) where myid is null



Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.

 

[bborissov]

Just theoretical. I am not sure if this will works:

update mytable set myid = {Call getmyid(@myid output)} where myid is null

Borislav Borissov