Re: inserting the max colum in the stored proc

Thats fine...
But, I actually wanted to add the MAX(col) from tabe that exists from the
same data base in place of @var1/Col1 in the below stored procedure

Hope you got my question

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




"George Ter-Saakov" wrote:

you can use something like in (MS SQL)

INSERT INTO table1(Col1, Col2,Col3)
SELECT MAX(col1), col2, col3 GROUP BY col2, col3




George

"iHavAQuestion" <iHavAQuestion@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4D34C984-5584-40B1-B082-2ECDD0DAA5AE@xxxxxxxxxxxxxxxx
I have stored procedure
Create Stored Procedure Name
(
@Var1
@Var2
@Var3
)
Inseret into table1
(
Col1
col2
col3
)
Values
(
@Var1
@Var2
@Var3
)

But in col1 i need to insert select max(col) from tablename, which is in
the
same database.

how do I do that??



.

Relevant Pages