Viewing 6 posts - 1 through 6 (of 6 total)
It's not the execution of the sproc that is causing the error, its during the creation. I'm using MS Access as a front end and simply creating a select stored...
November 17, 2011 at 6:00 pm
I did try that. I even tried using the SSMS on the SQL Server itself and had the same issue. I had thought maybe it was my machine.
September 8, 2011 at 12:50 pm
Thanks All for your comments, gives me some place to start. I was not involved with the install of the NetAPP so I'll have to do some research on the...
June 1, 2011 at 10:47 am
My sp code is irrelevant, it doesn't matter which sp I run, the same thing happens.
I am new to this forum, is there a way to mark this as...
April 21, 2011 at 10:28 am
As I said, I see now what is happening, the SELECT 'Return Value' statement is returning the extra row count like you mentioned. I get this by right clicking on...
April 21, 2011 at 10:11 am
Here is how I grab a Project record and all Sites associated with it using the STUFF and FOR XML
SELECT p.ProjectDescription,
STUFF((SELECT ',' + s.SiteCode FROM ProjectSitesps
...
March 21, 2011 at 12:05 pm
Viewing 6 posts - 1 through 6 (of 6 total)