Urgent problem with GROUP BY - 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 2000 Forums

Transact-SQL (2000)

Urgent problem with GROUP BY

Author

Topic

Maharisi
Starting Member

19 Posts

Posted - 2007-07-02 : 09:55:38

Sorry I need Group by all groups according to atributes TYPE

TYPE A B C
020 20040101 20051031 11113
020 20051101 20051130 11113
0X0 20051201 20051231 11113
020 20060101 20060131 11113
020 20060203 20060228 11113
020 20060301 20091231 11113
020 20100101 20700101 11113

Group these records to

TYPE A B C
020 20040101 20051130 11113
0X0 20051201 20051231 11113
020 20060101 20700101 11113

TYPE ,A ,B ,C are attributes
Thanks a lot

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-07-02 : 10:08:09

Duplicate of http://sqlteam.com/forums/topic.asp?TOPIC_ID=85820

Madhivanan

Failing to plan is Planning to fail

Maharisi
Starting Member

19 Posts

Posted - 2007-07-02 : 10:10:54

Sorry but it is not solution

Kristen
Test

22859 Posts

Posted - 2007-07-02 : 10:41:35

People give their time for free helping here and they don't want to be wasting time answering threads that other people have already started answering elsewhere.

Please do not make duplicate posts and please do not follow up in duplicate posts you'll only wind up annoying people who might otherwise be inclined to help you.

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources