Quick runnable demonstration on the flexibility of FOR XML PATH

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH BASE_DATA(BD_ID,BD_VAL) AS

(SELECT * FROM (VALUES

(1,'ABC')

...

Quick thought, in command prompt run "net start", the sql server instance will show up in the output if running, if not, start the instance.

😎

I...

Quick suggestion, create a view with compliant names, i.e. replace spaces with underscores, then specify the proper field name in the report. There is a three year old Connect entry...

jonen (10/3/2014)

---

Hi. I've just started a new job and working with Access databases, but these are getting very close to the 2gb size limits. My predecessor simply created a new...

Quick suggestion, try two separate queries, one for each email table and combine the results using union all.

😎

You are very welcome. Out of curiosity, what do you use for splitting the incoming parameters?

😎

Quick suggestions since Id's can be shared by Categories

😎

USE tempdb;

GO

DECLARE @t TABLE (Id INT)

INSERT INTO @t

SELECT 108 UNION ALL

SELECT 102 UNION ALL

SELECT 103 UNION ALL

SELECT 101;

DECLARE @t2 TABLE (CategoryId INT,...

...and another solution using the pre-split-string table

😎

USE tempdb;

GO

DECLARE @t TABLE (Id INT)

INSERT INTO @t

SELECT 101 UNION ALL

SELECT 102 UNION ALL

SELECT 103 UNION ALL

SELECT 108;

DECLARE @t2 TABLE (CategoryId INT, Id INT)

INSERT...

Quick solution for SQL Server 2012 and later, replaces also the split into @t

😎

USE tempdb;

GO

DECLARE @t2 TABLE (CategoryId INT, Id INT)

INSERT INTO @t2

SELECT 2, 50 UNION ALL

SELECT 2, 51 UNION...

Quick thought, remove the FOR XML from the nested query.

😎

First suggestion is to add one step where the files are directly loaded into a staging table as an XML blob, without any shredding or processing. This will give you...

You are absolutely right Gianluca, the source of the problem has to be determined before applying any fixes. What I left out in the previous post was of course using...

That is correct, so be careful!

It...

Quick thought, the cost threshold for parallelism is way too low, would suggest setting it to 50 for a start. Can you provide more information on the setup?

😎