Need help writing a stored procedure

Question

Viewing 5 posts - 1 through 5 (of 5 total)

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

Andy Warren SSC Guru Points: 119902 More actions · Answer 1

Hi Percival,

If you post what you have, we'll try to help. What you're trying to do is pretty straight forward I think, something like this:

Create proc usp_DoSomething as

--Sample proc to update a table

set nocount on

update a set a.somefield=b.somefield from table1 as A inner join table2 as B on A.primarykey=b.primarykey where b.someotherfield='whocares'

Andy

Leon Platt SSCommitted Points: 1921 More actions · Answer 2

My suggestion is to try to accomplish your goal in query analyzer first. Once you have the sql working copy it into a stored procedure.

Steve Jones - SSC Editor SSC Guru Points: 738043 More actions · Answer 3

Post your code and we can help, but Leon is right. Get it working in QA first.

Steve Jones

percivalbrag SSC Veteran Points: 278 More actions · Answer 4

Thanks everyone for your help. I was able to accomplish what I wanted using your suggestions. Your help was well appreciated.

Percival Bragg

Cookies on SQLServerCentral