Grab Select value for Transaction

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Grab Select value for Transaction

Author

Topic

hwdevelop
Starting Member

5 Posts

Posted - 2005-11-07 : 21:45:17

Hi,

I am trying to get the maximum value for a table to be used as insert value into another table. I'm using it in a transaction. Here is the code:

SELECT MAX(OrderNumber) from Order where OrderDate>@OrderFrom AND OrderDate<@OrderTo

DECLARE @NewOrderNumber INTEGER
SET @NewOrderNumber = ..... ???

I need to get the MAX(OrderNumber) result and set it as that @NewOrderNumber variable. Please help!!!

Thank you all !!
HW

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2005-11-08 : 01:23:22

somthing like this
DECLARE @NewOrderNumber INTEGER
SELECT @NewOrderNumber = MAX(OrderNumber) from Order where OrderDate>@OrderFrom AND OrderDate<@OrderTo

???

Complicated things can be done by simple thinking

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-08 : 01:28:09

Try this

DECLARE @NewOrderNumber INTEGER
SELECT @NewOrderNumber = MAX(OrderNumber) from Order where OrderDate>@OrderFrom AND OrderDate<@OrderTo

Now @NewOrderNumber will have maximum value

Madhivanan

Failing to plan is Planning to fail

hwdevelop
Starting Member

5 Posts

Posted - 2005-11-08 : 12:51:15

Thank you all for your advise!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources