grouping view - SQL Server Forums

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources