Re: inserting the max colum in the stored proc

From: "George Ter-Saakov" <gt-nsp@xxxxxxxxxxx>
Date: Tue, 13 May 2008 14:01:30 -0400

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??

Follow-Ups:
- Re: inserting the max colum in the stored proc
  - From: iHavAQuestion

References:
- inserting the max colum in the stored proc
  - From: iHavAQuestion

Prev by Date: Ajaxtoolkit Popup Control Extender and javascript function
Next by Date: Re: Tracking user logins with Session_End or other
Previous by thread: inserting the max colum in the stored proc
Next by thread: Re: inserting the max colum in the stored proc
Index(es):
- Date
- Thread

Relevant Pages

RE: inserting the max colum in the stored proc
... Create Stored Procedure Name ...
(microsoft.public.dotnet.framework.aspnet)
Re: inserting the max colum in the stored proc
... Create Stored Procedure Name ...
(microsoft.public.dotnet.framework.aspnet)
Re: Misnomers in the COBOL standard
... I always liked it that COBOL nearly always worked left to right: MOVE VAR1 ... TO VAR2, ADD 1 to VAR3, etc. ... DIVIDE A BY B would have broken this which is why it requires GIVING. ...
(comp.lang.cobol)
Re: Breaking Long Query into multiple statements ?
... Scan for &var1 &var2 &var3 ... Maybe these blanks are needed or the are not allowed or they don't matter. ...
(microsoft.public.fox.programmer.exchange)
Re: Misnomers in the COBOL standard
... William Bub wrote: ... I always liked it that COBOL nearly always worked left to right: MOVE VAR1 TO VAR2, ADD 1 to VAR3, etc. ...
(comp.lang.cobol)