@ScottPletcher Yes, lots of data rows. REPLACE performs OK, but I thought I could find a better way.
@

@ScottPletcher I am trying to avoid 26 REPLACE. That is what...

I use Jeff's function all the time, and I can't even think of a...

robert.sterbal 56890 (7/7/2015)

---

Is there a simple way to get a single row table with variable numbers of columns to output with 2 columns?

i.e.

colA colB colC

1 5 23

colA...

This is perfect! Thank you Mark!

Using ROW_NUMBER() for display purposes.

CREATE TABLE #Relationships

(

IDINT

,NameVARCHAR(50)

,ParentIDINT

)

INSERT INTO #Relationships(ID, Name, ParentID)

SELECT 1, 'Walt', NULL

UNION ALL SELECT 2, 'Frank', NULL

UNION ALL SELECT 3, 'Steven', 1

UNION ALL SELECT 4, 'Selma', 1

UNION...

Interesting article. However, the code in the article is basically re-numbering manually instead of taking advantage of the built in Row_Number() functionality.

This seems to be a lot simpler:

(Note: I...

Awesome article! Easy to read and very informative.

I especially liked that you provided simple easy-to-understand examples. 🙂

...

We don't actually need the Color table or the List table at this point. What we're really interested in is figuring out the answer to your question of "find if...

CELKO (5/13/2011)

---

I know this is a skeleton, but you got so much so wrong in so little code. Colors would be encoded with an industry standard (Land numbers, Pantone, etc),...

Thanks for pointing me in the right direction, Mike!

SwePeso's solution worked for me.

Posting the solution here in case this helps others:

--10 times the record, 7 times the duration.

/* ...

Thanks for the great article Jeff!

Eagerly awaiting the varchar(max) versions so I can incorporate them into my databases. 🙂

Does anyone have a theory as to why the CTE beats the...

That worked! Thanks!

Jason Selburg (4/15/2011)

---

Goldie Lesser (4/15/2011)

---

Hi,

.............

For example, I start with a list of entities: 32, 54, 67, 148.

I would need to insert the following values into the enemies table.

OriginalID | EnemyID

148...