Lol! Thanks Phil, its works perfectly 🙂

Thank you so much for your help, the last query works perfectly 🙂

This I understand.

You'll need to use a Calendar or Tally table. I'll see if there is something I can put together for you.

No loops! No CURSORs! No RBAR! Hoo-uh!

------------------------------------------------------

Thanks,...

Hi dwain.c,

The second result set is just an example not the exact dates in the table, this what I'm trying to achieve

if the dates are as follows:

StartDate ...

Hi ChargeIt,

maybe I wasn't clear in my prev post I don't want to limit the results for the specific dates that I posted and the time part of the...

Both queries work, I've used the one without the inner query to avoid a long script.

Thank you so much!!

Daniel Forrester 123 I ran your query as well, but it returned 0's for all rows.

Cadavre's query worked perfectly.

Thanks 🙂

It works, Thank you very much!!! 🙂

Hi, This works perfectly, but its not How I need to display the data:

Select intRequisitionId,

SUM(CASE WHEN ISNULL(dteFirstApproverDateNotified,0) <> 0 THEN 1 ELSE 0 END ) AS column1,

SUM(CASE WHEN ISNULL(dteSecondApproverDateNotified,0)...

I had 1 where i have the question marks, but i want to display the actual count not the no.1 where the 'notified date' is not null

for all the...