Inserting a cloum in a stored procedure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

iHavAQuestion - 13 May 2008 21:09 GMT

I have stored procedure
In @var1/Col1 I need to insert, the max(col) from another table in the
same database.

Create Stored Procedure Name
(
@Var1
@Var2
@Var3
)
Inseret into table1
(
Col1
col2
col3
)
Values
(
@Var1
@Var2
@Var3
)

Reply to this Message

Jeff Dillon - 13 May 2008 21:54 GMT

Select @var1 = max(col) from othertable

>I have stored procedure
> In @var1/Col1 I need to insert, the max(col) from another table in the
[quoted text clipped - 18 lines]
> @Var3
> )

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...