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
 Transact-SQL (2005)
 maximum customer number

Author  Topic 

palak
Yak Posting Veteran

55 Posts

Posted - 2008-08-25 : 08:57:42
max

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-08-25 : 09:16:27
well you have to group by more columns...
please provide data requested in this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

when you provide us with that we can help you better and sooner.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-25 : 13:25:27
Why did you edit your original question?
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-08-25 : 13:31:08
probably because he got scared about providing us with real data to help him with and he got scared we'd make fun of his sql

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-25 : 13:33:26
quote:
Originally posted by spirit1

probably because he got scared about providing us with real data to help him with and he got scared we'd make fun of his sql

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!


i saw the active post and clicked only to find max in post..
Go to Top of Page
   

- Advertisement -