Viewing 15 posts - 16 through 30 (of 50 total)
WITH CTE AS (
SELECT UserID, FormID, Answers, ROW_NUMBER() OVER(PARTITION BY FormID ORDER BY...
February 20, 2017 at 9:54 am
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?
February 16, 2017 at 1:38 pm
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
February 16, 2017 at 9:33 am
January 17, 2017 at 2:54 pm
Im...
January 17, 2017 at 2:31 pm
This works as well, and thank you for the explanations!
October 15, 2016 at 2:39 pm
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...
September 21, 2016 at 10:07 am
Thanks, Sue, I'll give it a try.
September 20, 2016 at 3:07 pm
When the stored procedure is executed inside SSMS, it does return the expected data value.
September 20, 2016 at 1:28 pm
I've tried it and got the same results, an empty Excel file with Column names only.
September 20, 2016 at 10:14 am
Sorry, the problem is that it still generated an empty excel file. I'm going to try your new code to see if it works.
Thank you very much for...
September 20, 2016 at 10:01 am
Thanks,Phil. I've tried your code and it worked as expected. However, in my case, there are still some problems. In the original post, I over simplified the SP code....
September 20, 2016 at 9:25 am
Thank you very much, Gail.
January 28, 2016 at 1:41 pm
Viewing 15 posts - 16 through 30 (of 50 total)