Last post Feb 26, 2017 05:14 PM by JAYHAWKER
Feb 26, 2017 04:09 PM|JAYHAWKER|LINK
I am trying to return the primary key (identity ) as well as one other value with the following stored procedure.
I can get one of them returned, but not the other.
@OCC float out,
@Identity int out
WHERE (DateID = @DateID)
SELECT @Identity = ID FROM eCC WHERE ID = ID
SELECT @OCC = OCC FROM eCC WHERE OCC = OCC
Return @OCC, @Identity;
I can do
but I can't do both?
Is there a simple way to do it without my needing to create an array?
Feb 26, 2017 05:09 PM|mgebhard|LINK
Feb 26, 2017 05:14 PM|JAYHAWKER|LINK
Thanks again! You always make things seem so simple and I appreciate it!