Tech Bang (2/27/2016)

---

Hi Riaan,

INSERT INTO @temp VALUES

(

(SELECT * FROM OPENQUERY([INTL-DBSERVER], 'EXEC spGetCriticalGapsForATransition @transitionId = 1') FOR XML AUTO, ELEMENTS),

(SELECT * FROM OPENQUERY([INTL-DBSERVER], 'EXEC spGetCriticalIssuesForATransition @transitionId = 1') FOR XML...

Tech Bang (2/27/2016)

---

#Grasshopper, the compiler isnt happy. It fails at the first param of OPENQUERY itself.

DECLARE @server_name VARCHAR(100);

SELECT @server_name = @@SERVERNAME;

DECLARE @temp TABLE

(

Gaps XML,

Issues XML

)

INSERT INTO @temp VALUES...

Tech Bang (2/27/2016)

---

I'm looking for a similar solution, but instead of the 3 select statements, the values will come from 3 stored procs. I tried replacing the procs, get...

Thank you opc.three,

I have checked and the Force Encryption setting is indeed set to No.

It must be something on the user's side.

Very strange... Boggles the mind...

Kind Regards,

Riaan

sharon.chapman7 (11/19/2012)

---

Hi,

Can you tell me how to write this code if I only want certain fields from each table? I get errors when I try to select a few fields...

Came right with guidance from various sources. Below the solution in case anyone ever wants to do something similar...

DECLARE @TempExportTable TABLE

(

Products XML,

Colours XML,

Sizes XML

)

INSERT...

Thanks for the quick reply Sean.

The above is an example only, there are 14 tables in total and the end-user will be dragging and dropping the xml file into a...

I came completely right! With big thanks to Paul and another tutorial at http://www.kodyaz.com 🙂

Below is the final T-SQL query for anyone who has a similar issue: (I...

Thanks Paul, I just did so - Simplifies the query a lot. 🙂

Hi Paul,

Thank you! Thank you! Thank you!

The second part works brilliantly if I replace it with the actual start date and numofclasses column from my existing Classes table! 🙂

An excellent...

Hi Sqlkiwi,

Thanks for the reply.

Most of these Pivot techniques I am aware of, although in this specific instance I do not have an actual data table which has periods and...