Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Serializing rows
Message
From
09/12/2009 11:44:54
Naomi Nosonovsky
Wisconsin, United States
 
 
To
09/12/2009 11:38:32
Bill Fitzgerald
Woodbury Systems Group
Hamilton, New Jersey, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Serializing rows
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01438197
Message ID:
01438243
Views:
42
>Thanks, Naomi
>I'll try it.
>
>
>>>select sono, AddDate, row_number() over (partition by Sono order by AddDate) as Seq from Transactions

You're welcome :)
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform