My PC has 1 CPU with 4 Cores and 16GB RAM. As frederico_fonseca recommended I increased the memory for the VM to 12 GB.
Inside the VM there is used...

but I get "Message 195" for the Concat-line in SS2008R2, so I changed Method1 slightly

SELECT DISTINCT
SD.ID
,STUFF((
 SELECT
  --CONCAT(',',...

yes you're right there was an error with proc names which I corrected now in the first post. I use several SPs where I'm using different parameter names and those...

for me it's essential to know this behaviour:

' Access Developer Handbook Vol. 2 S. 265:

' 1.

' If you use the...

sorry Scott,

but your code threw error 134 so I just tried to fix it.

But you put me on the right lane. The solution looks like this:

DECLARE @SQLstmtAs nvarchar(500)= NULL

DECLARE @CountRowsAS...

hey Scott,

your code slightly changed: added ";" after first DECLARE

When debugging @SQLstmt looks this:

DECLARE @RCount int; SELECT [LCPRBSELF] FROM [SVCECPSIPOS01].[printpos01].[A].[PDS] WHERE [DRUCKER] = 'P513'; SELECT @RCount...

hi,

so you mean

EXEC sys.sp_executesql @stmt = @SQLstmt

, @params = N'@RCount as INT OUTPUT'

, @result = @RCount OUTPUT;

IF @RCount >...

ok folks,

it's a beginners issue:

start the SQL Server Agent and all is fine:-D

Hey Steve,

let me say your solution works - and this code is: artwork:-)

thx

Hi,

I posted also in a CR-forum and there's another idea which I think maybe more flexible as I can use the CR-crosstab feature with no restriction (?).

As posted here and...

Hey Steve,

I ran your code and it looks fine:-)

Just one thing for script#2: the number of 12 columns is now correct, but the right and last column (DT12) should be...

sorry for the unconvenience but I couldn't remove this topic as it was a result of using the enter key to early.

Please read on the topic here