This got resolved with the help of a consultant from our cloud hosting providers;

He found the solution from articles i actually came accross but didn't read fully so i didn't...

Do you have access to GRANT access to a user in SQL?

Try this:

grant execute on xp_cmdshell to user

You mentioned you login with different logins for each server; See if you...

I came across this article saying xp_cmdshell isn't enabled by default on SQL Server ; Link[/url]

Try running this before running your query and see if that fixes it:

EXEC sp_configure 'xp_cmdshell',...

See if you can try posting some sample data from your table(Just a few rows should suffice) and also paste in your code.

hr.ppaul (5/12/2015)

---

Hello,

We have quite simple SQL database sitting on Azure, we are developing it on the fly so no Dev/QA/Prod versions, is on SQL Express 2012

Sometimes we need to take...

you can join the table to itself if the values are in the same table ( Or just join both tables if it's not the case) and use SUBSTRING; I...

Maybe it will help if i explain it this way.

In terms of what comes first, i would need a job to run periodcally ( Every 10 minutes or so) that...

I'm sure there's more than 1 to do it, but yes we want to be able to audit this data and also update it where those constraints fit.

Ex, if an...

Bump,

Thank you again for your input, very much appreciated 🙂

Sorry for not providing more complete description, i'm still pretty much brand new to SQL Server and learning as much...

I got the following error message when i tried using your script:

Msg 325, Level 15, State 1, Line 31

Incorrect syntax near 'PIVOT'. You may need to set the compatibility level...

I'm using sub-reports because the report in question is getting the summary for 6 different item codes which are all PK from the same table; 4 of which are payables...

Thank you!!! This worked great! Applied it as you suggested and the results are fairly close to previous month.

Thanks everyone else for your input!

I don't need the dates in the column headers, just the month, the data cells would be the sum amount for A, B, C and D; 12 columns, 4 rows...

Ok now i see! Thank yo very much for the breakdown!