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.
| Author |
Topic |
|
anaze
Starting Member
6 Posts |
 Posted - 2013-06-05 : 10:38:44
|
| CREATE TABLE [dbo].[tmp]( [nomer] [varchar](2) NOT NULL, [nama] [varchar](50) NULL, CONSTRAINT [PK_tmp] PRIMARY KEY CLUSTERED ( [nomer] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO insert tmp (nomer,nama) values ('01','PRAMITA'), ('02','PUTRI '),('03','VIDYAZTARI') select * from tmp select (case when nomer = '01' then nama end) nama1, (case when nomer = '02' then nama end) nama2, (case when nomer = '03' then nama end) nama3 from tmp RESULT : nama1 nama2 nama3 PRAMITA NULL NULL NULL PUTRI NULL NULL NULL VIDYAZTARI I WANT RESULT IS : nama1 nama2 nama 3 PRAMITA PUTRI VIDYAZTARI Please help me,... Thanks For ur helping, before.. |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2013-06-05 : 10:41:31
|
| declare @tmp TABLE ( [nomer] [varchar](2) NOT NULL, [nama] [varchar](50) NULL)insert into @tmp (nomer,nama) values ('01','PRAMITA'), ('02','PUTRI '),('03','VIDYAZTARI') select Max(case when nomer = '01' then nama end) nama1, MAx(case when nomer = '02' then nama end) nama2, MAx(case when nomer = '03' then nama end) nama3 from @tmpCheersMIK |
 |
|
|
anaze
Starting Member
6 Posts |
Posted - 2013-06-05 : 10:45:14
|
it works fine...Thanks a lot Mr. @MIK_2008 |
|
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2013-06-05 : 12:04:08
|
| You're welcome! :)CheersMIK |
|
|
|
|
|
|
|
|
row to column group by value is not null