Re: [GENERAL] pivot table sql -- COUNT() not working as expected

2004-06-26 Thread kumar mcmillan
hey thanks! can't believe it was as simple as 0 -> NULL. doh. count() works as expected now. On Jun 20, 2004, at 11:17 AM, Markus Bertheau wrote: Ð ÐÑÐ, 20.06.2004, Ð 17:44, kumar mcmillan ÐÐÑÐÑ: hi. I am using a pseudo "pivot table" SQL query to generate a report butI am totally stumped on wh

Re: [GENERAL] pivot table sql -- COUNT() not working as expected

2004-06-20 Thread Markus Bertheau
Ð ÐÑÐ, 20.06.2004, Ð 17:44, kumar mcmillan ÐÐÑÐÑ: > hi. > I am using a pseudo "pivot table" SQL query to generate a report butI > am totally stumped on why the COUNT() function isn't getting me > theexpected results and was wondering if anyone has some ideas... > > it is for a statistical report s

[GENERAL] pivot table sql -- COUNT() not working as expected

2004-06-20 Thread kumar mcmillan
hi. I am using a pseudo "pivot table" SQL query to generate a report but I am totally stumped on why the COUNT() function isn't getting me the expected results and was wondering if anyone has some ideas... it is for a statistical report showing which lead source a member followed when creating a p