support 86837 (11/25/2014)

---

I've never done any XML data extraction before and have spent awhile this afternoon reading about it, and am still struggling. The concept seems relatively simple but my...

Nice question, Thanks for sharing

i assumed that you have a table which is having xml column.

DECLARE @xml TABLE (id INT IDENTITY(1,1), xmldoc XML)

INSERT INTO @xml

SELECT '<?xml version="1.0"?>

<CC>

<Type>1</Type>

<Exp>1112</Exp>

<Number>123456</Number>

<Name><![CDATA[RobRobertson]]></Name>

<Amt>18.06</Amt>

<Auth>33875</Auth>

</CC>'

UNION ALL

SELECT '<?xml version="1.0"?>

<CC>

<Type>2</Type>

<Exp>1113</Exp>

<Number>123456</Number>

<Name><![CDATA[RobRobertson000]]></Name>

<Amt>182.06</Amt>

<Auth>3387225</Auth>

</CC>'

UNION ALL

SELECT ...

Very nice question, Thanks for sharing

+1000,...

Excellent question. Thanks for sharing.

No matter whats happens later in today about identical answer or not.

Very nice question, Thanks for sharing

kevin 26531 (11/8/2014)

---

Done a lot more digging and found that the xml path is taking 84% of the total query time, where the dynamic query is only 14%.

Anyone got any...

Nice and easy end of the week QotD :-). Thanks for sharing

Here is another way of achieving by using TALLY table logic.

DECLARE @dataTABLE (groupid int, salesperhour tinyint)

DECLARE @groups TABLE (id int, groupname char(3))

INSERT INTO @groups VALUES (1,'aaa'),(2,'bbb')

INSERT INTO @dataVALUES

(1,1),

(1,7),

(2,2),

(2,5),

(2,6)

-------- Create...

you can look into the following two options.

1) Check if the UDF used in the WHERE Clause is slowing the query. you can do this by getting the value in...

Koen Verbeeck (11/6/2014)

---

The problem is that only the wizard has this issue,...

Nice question, it reminded me when i used this wizard 1st time for flat file :-).

Thanks for sharing.

SQLServerCentral there are alot of articles which might help you to kick start your database knowledge and understanding.

"Stairways" is one of the best because its start from very basic...

I have four Excel tables named BasicData, FacilityData, StaffData and StudentData. They all have SchoolCode as PK in them

if I follow the solution which you have suggested here then I...