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.
| Author |
Topic |
|
ujjaval
Posting Yak Master
108 Posts |
 Posted - 2007-10-09 : 01:33:08
|
| Hi all,I have to write a query but don't understand how...So I have a table with all the customer list and days since they've visited the place. Now i need to list number of customers who have visited in say last 0-90 days, 91-180 days and so on and at last the remaining one depending upon the maximum number of days in the database for a customer is stored.Any ideas how to group them in this way.. I think it should be dynamic so that I can also be able to generate list of customers in last 0-60 days, 61-120 days and so on...Thanks heaps..Regards,Ujjaval |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-09 : 01:42:48
|
| If you posted DDL for your tables, INSERT INTO statements for sample data, and the expected result set using that sample data, then we'd be able to help you.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-09 : 02:24:57
|
Something in the neighborhood of SELECT SUM(CASE WHEN LastDays BETWEEN 0 AND 90 THEN 1 ELSE 0 END) AS [0-90 days],SUM(CASE WHEN LastDays BETWEEN 91 AND 180 THEN 1 ELSE 0 END) AS [91-180 days],SUM(CASE WHEN LastDays > 180 THEN 1 ELSE 0 END) AS [> 180 days]FROM Table1
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
automatic grouping in a dynamic range