Jeff Moden (5/15/2012)

---

BWAAA-HAAA!!! Thanks for having a good sense of humor, Dwain! You've made my day! 🙂

Shifting gears back to the subject at hand... there's a While Loop...

Jeff Moden (5/15/2012)

---

dwain.c (5/15/2012)

---

Jeff Moden (5/15/2012)

---

dwain.c (5/15/2012)

---

Jeff Moden (5/15/2012)

---

Since you used a...

Jeff Moden (5/15/2012)

---

dwain.c (5/15/2012)

---

Jeff Moden (5/15/2012)

---

Since you used a recursive CTE for...

Another puzzle:

DECLARE @t TABLE (ID INT IDENTITY, strcol VARCHAR(100))

INSERT INTO @t

SELECT '[p]a]a]s]s][p'

UNION ALL SELECT '[z]z]z]z]y][y'

;WITH Tally (n) AS (

SELECT TOP 100 ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) FROM sys.all_columns)

SELECT...

Note that the computed result after all THENs (or ELSE) must match in datatype.

I don't see that as a problem in your CASE (:-)) but I thought I'd mention it.

Jeff Moden (5/15/2012)

---

Yes. ...

Jeff Moden (5/15/2012)

---

Since you used a recursive CTE for this task, that...

Here's a solution that may work if you won't or can't use a CLR:

DECLARE @t TABLE (strcol VARCHAR(100))

INSERT INTO @t

SELECT 'here is some text'

UNION ALL SELECT ' and HERE is...

I can't make sense of...

Jeff Moden (5/12/2012)

---

BWAAA-HAAAA!!!! So! Did you pick the slowest...

Jack Corbett (5/14/2012)

The only thing I"d quibble with is where you say "(i.e., the last) record" as ordering is not guaranteed in SQL Server so you aren't guaranteed...

I saw an article that may help with this: http://www.sqlskills.com/BLOGS/BOBB/post/Using-the-OUTPUT-clause-results-and-INSERT-SELECT.aspx

Adapting the code there to your problem (alas, without being able to test in my SQL 2008 playground):

CREATE TABLE Stock (Stock...

Steve - Thanks for the vote of confidence to us dinosaurs.

Have you considered taking the two WHERE clauses from your two DELETEs and combining them with an OR instead of trying to use CASE?

Note that all of your title tags were incorrectly constructed. After fixing that, I came up with the following:

DECLARE @XML XML

SET @XML = CAST('<DocumentElement>

<QuestionList>

<QuestionId>Q1000</QuestionId>

<Title>Apple</Title>

<Sequence>3</Sequence>

<MergeSequence>1</MergeSequence>

</QuestionList>

<QuestionList>

<QuestionId>Q1028</QuestionId>

<Title>Banana</Title>

<Sequence>3</Sequence>

<MergeSequence>2</MergeSequence>...