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
 Other SQL Server Topics (2005)
 grouping view

Author  Topic 

Joetaniarto00
Starting Member

12 Posts

Posted - 2014-10-20 : 23:43:36
I have data as below :

sys one two three Four Five
74173,PCT0114100261, , , ,
74173, ,RO , , ,
74173, , ,UK PLANO, ,
74173, , , ,UK 92.5X67,
74173, , , , ,TOL +3%

I want to make it into 1 row so the result can be like this :

sys one two three Four Five
74173,PCT0114100261, RO, UK PLANO,UK 92.5X67,TOL +3%

I try to group the data but the result still wrong..please tell me the solution..

thanks...

Joetaniarto00
Starting Member

12 Posts

Posted - 2014-10-21 : 22:05:36
I got the solution by select max function...

thanks..all
Go to Top of Page
   

- Advertisement -