MS SQL Server, Easy Urgent Query Problem HELP!!

Easy Urgent Query Problem HELP!!

Author	Message
Frank Waegema #1 / 3	Easy Urgent Query Problem HELP!! Hi, I have an urgent query problem in SQLSERVER 6.5 ... I have a query like : select CulA, CulB from Table1 The result is : CUlA CulB -------------------- 1 5 2 6 3 5 4 6 5 5 I want to show the result like this : CUlA CulB -------------------- 1 CTRL 2 DATA 3 CTRL 4 DATA 5 CTRL It is not allowed to create an extra table in the database !! Please help me, Regards,
Tue, 30 Sep 2003 14:37:31 GMT

Joe #2 / 3	Easy Urgent Query Problem HELP!! You can do this using the "CASE" statement, you won't need an extra table either. Look in Books Online for "CASE", there are some good examples there. Joe Quote: > Hi, I have an urgent query problem in SQLSERVER 6.5 ... > I have a query like : > select CulA, CulB from Table1 > The result is : > CUlA CulB > -------------------- > 1 5 > 2 6 > 3 5 > 4 6 > 5 5 > I want to show the result like this : > CUlA CulB > -------------------- > 1 CTRL > 2 DATA > 3 CTRL > 4 DATA > 5 CTRL > It is not allowed to create an extra table in the database !! > Please help me, > Regards,
Tue, 30 Sep 2003 22:51:51 GMT

KulaShake #3 / 3	Easy Urgent Query Problem HELP!! select cula,culb= case when culb=5 then 'CTRL' when culb=6 then 'DATA' end from table1 Quote: > Hi, I have an urgent query problem in SQLSERVER 6.5 ... > I have a query like : > select CulA, CulB from Table1 > The result is : > CUlA CulB > -------------------- > 1 5 > 2 6 > 3 5 > 4 6 > 5 5 > I want to show the result like this : > CUlA CulB > -------------------- > 1 CTRL > 2 DATA > 3 CTRL > 4 DATA > 5 CTRL > It is not allowed to create an extra table in the database !! > Please help me, > Regards,
Tue, 30 Sep 2003 16:36:25 GMT

Page 1 of 1

[ 3 post ]