thank you. Can you please tell me which string is bound by an extra quote?

Thanks for the prompt reply. I thought about this solution myself. However, my boss said the answer was in using cursors. I used outer Join and reformatted the entire join...

thank you so much. It worked.

Thanks. I will test it.

So what is the solution?

Basically all I had to change was to add 'All' in front of Group BY, this would list all the reports even if the count associated with them was 0.

Group...

I found the solution.

the secret was to use the Group By All clause, then one would see the zeros for the Count if there are no records that meet the...

I tried with left join and group by and it did not work.

I want this to return 0 when there is no records found.

Select IsNULL(Count(*), 0) As Count, RT.Report_ID, ReportName, ReportCategory From

tTracking_tblReportsUsage tbTracking

Right Join tblReportsNew RT On tbTracking.Report_ID =...

Actually Cast(@issuedate As DateTime) worked.

Thanks. I will try it Convert function did not work.

Thanks for the prompt reply. I will test the Cast, Convert function did not work.

Generally speaking when the count is zero that record is skipped. I found a way to return the zero value by using Group by All and picking the column used...

Thank you so much. it worked.

Thank you. It worked.