Hi Wayne,

First up apologies for not posting the scripts for the test data creation.

And thanks for the tips for sharing those articles on Cross Tab & PIVOT. Although the...

Hi Tom,

As I mentioned there are several tables to join and one calculation feeds another table \ calculation.

So IMO (if possible) doing all that in one SQL will make...

your question isn't quite specific!

What tables you are outer joining on? Based on your output it doesn't look like you are using Table A at all.

Cheers! I just wanted to format the ugly looking SQL in @sql while someone was watching over my shoulder and then I had a light bulb moment ...

Hi Guys,

Thanks for all your suggestions.

I have spotted the problem - it is nothing to do with the permission, bcp, cmdshell, sybase (or anything as thought about ......)

What it turns...

OK - so I modified the stored proc a bit to have something like this -

EXECUTE @RESULT = MASTER..xp_cmdshell 'bcp "SELECT COL1, COL2 FROM [##results]" queryout "E:\test\TEST1.csv" -c -t,...

Hi David,

We are no where near Sybase. -S / server option I have already tried but I guess it doesn't make much difference as the whole deal is on...

Lowell / Steve,

Some good thoughts - the proxy account I had setup is using the admin user. So that should be fine I guess.

I tried the dir test e.g....

Hi Steve,

I thought about that and I had checked the permission - seems fine (SQL Server users have special permission to create files / append data etc). Also I would...