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)
 Creatin Multiple Column from Single Column

Author  Topic 

teratera
Starting Member

1 Post

Posted - 2008-03-18 : 11:43:33
Hi, I have a table like this..

Date TID Storeno
1 1 1
1 1 1
1 2 2
1 2 2
1 7 1
1 7 1
2 3 1
2 3 1
2 4 2
2 4 2

I want the result like this..

Date Store1-Transaction Store2-Transactions
1 2(Disticnt Transaction id) 1(Disticnt Transaction id)


Please help

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-03-18 : 11:50:17
Can you make your requirement more clear? Cant understand what you really want?
Go to Top of Page

jonasalbert20
Constraint Violating Yak Guru

300 Posts

Posted - 2008-03-18 : 21:57:04
follow this instructions.

For fast result follow this...
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

Want Philippines to become 1st World COuntry? Go for World War 3...
Go to Top of Page
   

- Advertisement -