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 2005 Forums
 Transact-SQL (2005)
 Creating Number column

Author  Topic 

s_k_sameer
Starting Member

9 Posts

Posted - 2008-05-14 : 04:39:36
I have a ACTION column. i.e Its only disply SELL/BUY.

ACTION

BUY
BUY
BUY
SELL
SELL
SELL
SELL
BUY
BUY
SELL
SELL
SELL
BUY

How to create another column display like this

ACTION

BUY 1
BUY 2
BUY 3
SELL 1
SELL 2
SELL 3
SELL 4
BUY 1
BUY 2
SELL 1
SELL 2
SELL 3
BUY 1

Help me anyone...

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-14 : 04:48:57
Duplicate post

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=102805
Go to Top of Page

eralper
Yak Posting Veteran

66 Posts

Posted - 2008-05-14 : 06:44:10
Also
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3339807&SiteID=1



-------------
Eralper
http://www.kodyaz.com
Go to Top of Page
   

- Advertisement -