Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 grouping view
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Joetaniarto00
Starting Member

Indonesia
12 Posts

Posted - 10/20/2014 :  23:43:36  Show Profile  Reply with Quote
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

Indonesia
12 Posts

Posted - 10/21/2014 :  22:05:36  Show Profile  Reply with Quote
I got the solution by select max function...

thanks..all
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000