It would be interesting to see the performance of PS when working with sets larger than the 2Gb limits of the XML data type. 😎

jhinch (4/24/2014)

---

I have two tables. Table 1 has column "job", table 2 has column "job" and column "item". In table table 2 there are multiple "items" for each...

SQLCurious (4/24/2014)

---

I have about 1200 sql files in one of my folders. Almost all of these files do data inserts and updates, so they should be run only once. As...

DBA12345 (4/23/2014)

---

I want to update table2 by checking table1.

if trauma has atleast 1 then clm2 in table2 would be 1

if infec has atleast 1 then clm2 in table2 would be...

Hi Matthew,

and thank you for this article.

Few comments, firstly the sp_xml_preparedocument and sp_xml_removedocument have some limitations and quite an overhead, I'm very hesitant recommending / implementing them on a...

In SSMS table content editor, press CTRL+3 and change the sql statement to select * from table_name, then press CTRL+R.

😎

Something along these lines? (ugly but works) 😎

(121 retains the milliseconds while 126 and 127...

Confusing Queries (4/23/2014)

---

Hi All,

I am working on an ASP.net web application which inserts new record into an underlying table. It is actaully a ConfirmationNumber and should be unieque. I have...

Here is an example using AdventureWorks2012

😎

USE AdventureWorks2012;

GO

DECLARE @SOH_XML XML;

SELECT @SOH_XML = (

SELECT

SalesOrderID

,RevisionNumber

,OrderDate

,DueDate

,ShipDate

...

Try using a variable of the type "object" to retrieve the recordset. Then a variable of the same type as the column in a For Each loop.

😎

My bad, then the option is to nest it

😎

DECLARE @XML...

Check this on technet

😎

My point exactly!

😎

ChrisM@Work (4/23/2014)

---

hoseam (4/23/2014)

---

Now that's an easy one cause I created a table for you, so you are working with the data you know. say now the user input tblDef_RETURNS as...

hoseam (4/23/2014)

---

Now that's an easy one cause I created a table for you, so you are working with the data you know. say now the user input tblDef_RETURNS as table,...