SQL Server Performance Forum – Threads Archive

sql query with join n group by

i have 3 tables called account,customer,packagedetail relationship b/w thm r like packagedetail.customerid = customer.customerid
customer.accountid = account.accountid
account table have one more colum called "month" if i wann see all the packages with number of customers(count) i can see it with group by query like SELECT packageid, COUNT (*) Customers
FROM packagedetail, account, customer
WHERE packagedetail.customerid = customer.customerid
AND account.accountid = customer.accountid
GROUP BY packageid; but now suppose i want to see the output like Packlage name JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
P1 12 2 34 5 0 67 4 23 08 21 18 1
p2 0 0 54 67 89 6 21 34 8 2 0 2
p3
p4
.
.
.
.
. n so on… please help me for the same….
it will really help me….

SELECT packageid,
[Jan] = sum(case when month = 1 then 1 else 0 end),
[Feb] = sum(case when month = 2 then 1 else 0 end),
[Mar] = sum(case when month = 3 then 1 else 0 end),
. . .
FROM packagedetail
INNER JOIN customer ON packagedetail.customerid = customer.customerid
INNER JOIN account ON account.accountid = customer.accountid
GROUP BY packageid KH

hi khtan, its showing some error like "missing expression" … not getting y?? can u help me ?

can you post the query that you use ?
KH

hey sorry…i was doing something wrong so it was not working…but now its working properly…..
Thankx a lot!!

I guess you did not replace the . . . with the rest of the similar codes [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Sorry, i was lazy [<img src=’/community/emoticons/emotion-4.gif’ alt=’

‘ />] <hr noshade size="1"> KH

no i replaced all the other things but i forget to remove a comma frm the query so it was showing "missing expression"…. nyways now its working.. thankx <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />

]]>