PS.......

Before discovering SQLSERVERAGENT there was confusion supreme as the JOB failed because I don't have CmdExec permission and when the Administrator set up the JOB, it failed with "connection error"...

Discovered that scheduled JOBs are run by Windows SQLSERVERAGENT service.

This service can be set to to act like a domain-user with its own (startup) userID and password.

We have now applied for SQLSERVERAGENT (user...

Problem solved.

Ian

Yeah, something like that.

It's an expression which (giving away my age) comes from the 1950s.

Ah, the days of Rock 'n Roll when Elvis became the KING and life was about...

XTAB is now in the Scripts library and I was really chuffed to receive so many votes.

Ian

Use Northwind

EXEC sp_XTAB

'Northwind',

'xtORDIST',

'Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID',

'Orders.CustomerID, City',...

Chris, I've seen your posts and you're a GURU, official or otherwise.

Ian

Thanks Chris,

I'm a programmer who knows very little about SQL Server.

This is a prototype and sql gurus such as yourself could improve XTAB I.e. more error trapping.

The "scoping" is a bit tricky...

Hi Charlesd,

XTAB will do the job for you - no fuss.

It's big but you only have to copy and paste it - no messing with code because the XTAB stored...

No problem.

Ian 

I may be a bit off beam on this one however, having read so many requests for a CROSSTAB (TRANSFORM/PIVOT) function in SQL Server, I wondered if a procedure I wrote (sp_XTAB)...