getting one step closer to the solution:
Select    Count(*) as InitiatedProd, c.Wk_number
From    #tbProducts p
            Inner Join    (Select CalendarDate, WD_Num, datediff(WEEK, '12/31/2017', CalendarDate) as Wk_number From #tbCalendar)
            c on c.CalendarDate =...

Thanks for reply.
I'm going to ask our network administrator for advises.  Also, can you recommend a few online references about domain service account?

This is exactly what I needed, thank you very much!

I run it with your code, and here is the result:
FormID UserA UserB
2001 Yes No
2002 Maybe Not Sure
2003 Ok NULL
2004 Maybe No

This works as well, and thank you for the explanations!

This works perfectly!

Thanks!

Thanks, Jeff!

I've tried it with a global temp table, and still no luck.

As an alternative, I took out the insert statement from my stored procedure, and set it as a new...

Thanks, Sue, I'll give it a try.

When the stored procedure is executed inside SSMS, it does return the expected data value.

I've tried it and got the same results, an empty Excel file with Column names only.