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)
 Filtering a data inside SELECT statement

Author  Topic 

sanjay_jadam
Yak Posting Veteran

53 Posts

Posted - 2006-01-02 : 10:11:37
how can i split a column into two column according to columns valus??
i face a problem that
i have one column containing more than two valus (Type)

My query show this type of result
Person Name Type
ABC A
XYZ A
PQR B
RST B
where person name and type are belong to different table
I want to show result like
columnName A B
ABC PQR
XYZ RST

Please help me

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-02 : 10:50:59
Check the BOL for "Case" in T-SQL
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-03 : 00:27:40
Also check these Cross Tabs
http://weblogs.sqlteam.com/jeffs/archive/2005/05.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -