Calling a stored procedure from a select???

Question

Post reply

Calling a stored procedure from a select???

al_nick

Say Hey Kid

Points: 713
More actions
August 30, 2006 at 2:20 pm

#97712

Hi all,
I'm trying to update a column on with the results of stored procedure. I'm trying to do something like this:
update pubs
set booktitle = (exec USP_BuildBookTitleFromTempTable)
where booktitleID =12

Can someone please tell me the correct syntax to accomplish this??

Thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gopi Muluka SSCarpal Tunnel Points: 4594 More actions · Answer 1

Use User Defined Functions instead of Stored Procedure

al_nick Say Hey Kid Points: 713 More actions · Answer 2

Thanks but i need to used temp tbls which cannot be done inside a udf

Gopi Muluka SSCarpal Tunnel Points: 4594 More actions · Answer 3

replace your temporary tables with table data type, which is allowed in UDF's

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Can you show use the sp code so that we can provide an alternate solution?

al_nick Say Hey Kid Points: 713 More actions · Answer 5

Converting my temp tables to the table datatype and using a UDF instead worked!! Although i could have swore there is a way to invoke a sproc inside a update/select statement... hmmm... perhaps i was huffing too many paint cans that day

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

If you create a perm table and 2 users run the sp at the same time you'll get a error...

Still waiting to see that code...

Ignas Chilewa Mr or Mrs. 500 Points: 536 More actions · Answer 7

You can try this one :

-- start here

declare @output_param <data type>

exec BuildBookTitleFromTempTable @output_param output -- I'm assumming that you will modify ur sproc to include output param

update pubs

set booktitle = @output_param

where booktitleID =12

-- end

Ignas