Yes.

If you could supply us with some details or examples of what you want, we could demonstrate it for you.

Try this script:

Declare @TableName SYSNAME

Declare @sql as NVarchar(MAX)

Set @TableName = N'your table name here'

Select @sql=Coalesce(@sql+'UNION ALL ', 'INSERT Into '+@TableName+'(ColumnName, ColumnValue)

')

+ 'Select ''' +Column_Name+ ''',...

Robert Frasca (12/21/2008)

---

Different kinds of types. Now we're playing a little loose and fast with the Queen's English. 🙂 (They are synonyms.)

...

I believe they are mixing...

Yeah, Attention Deficit Disorder is such a, ... uh, ... um, what were we talking about again?

Matt Miller (12/21/2008)

---

RBarryYoung (12/21/2008)

---

Uh, she died on a remote planet after being beaten and starved to death by Sandpeople, so out of anger...

I ask because I think that I have seen it before and it is customary to give people credit for their work.

So who wrote this?

Your XML got eaten by the security filter. Please attach it as a text file.

This is a duplicate entry. Please deo not cross-post. Direct all replies to this thread: http://www.sqlservercentral.com/Forums/Topic623669-360-1.aspx

Well, IMHO it's just a way to positively spin why they think that it's OK to add hierarchical repeating group data BLOBs like XML into our nice relational database.

Uh, she died on a remote planet after being beaten and starved to death by Sandpeople, so out of anger I killed every...

Heh, you're right Jeff, the only exit is a RaisError/Return pair. Dang, and I meant to check for that too.

Ninja's_RGR'us (12/21/2008)

---

Tssss,tsss, you had to go ahead and wake up the tigger... and I was hoping for a quiet xmas!!!

I bet a small dollar that this will be the new...

Then you want to determine which statement is currently running while it appears to be hanging. You also want to see if any blocking is occurring.

sqlizer (12/21/2008)

---

Tried to add new column and then tried to reshuffle it to different order in the existing table, gave me warning that it would need to drop and recreate...