Lynn Pettis (1/10/2013)

---

dwain.c (1/10/2013)

---

Lynn Pettis (1/10/2013)

---

I guess you aren't supposed to leave negative comments on articles like this one, http://www.sql-server-performance.com/2012/sql-tuning-tvf-scalar-functions/. I took a bit of an exception to the...

Lynn Pettis (1/10/2013)

---

I guess you aren't supposed to leave negative comments on articles like this one, http://www.sql-server-performance.com/2012/sql-tuning-tvf-scalar-functions/. I took a bit of an exception to the article and left...

jay.schwinn (1/10/2013)

---

Dwain.c,

Thank you for your input and advice. This is indeed how I would like the final output to look. However, I need the groupId to populate automatically...

Have you tried the solution I suggested on your posted test data?

All you need to do is change the hard-coded 206 in the replacement with:

CAST(groupid AS VARCHAR(5))

and I think it...

ScottPletcher (1/10/2013)

---

You might want to review the new functions in SQL 2012 dealing...

Jeff Moden (1/10/2013)

---

Alan.B (1/10/2013)

---

This morning before work for example, after a lot of effort, I finally figured out how to get the Levenshtein Edit Distance between 2 strings without a...

Jeff Moden (1/9/2013)

---

Is that because...

You could possibly do this:

UPDATE Table

SET col1 =CASE department

...

UPDATE TABLE1 SET FIELD1 = .....

SELECT @@ROWCOUNT

UPDATE TABLE1 SET FIELD1 = .....

SELECT @@ROWCOUNT

UPDATE TABLE1 SET FIELD1 = .....

SELECT @@ROWCOUNT

UPDATE TABLE1 SET FIELD1 = .....

SELECT @@ROWCOUNT

UPDATE TABLE1 SET FIELD1 = .....

SELECT...

Lynn Pettis (1/9/2013)

---

dwain.c (1/9/2013)

---

I was referring to this in my prior post:

I...

I was referring to this in my prior post:

I understand how you...

Lynn Pettis (1/9/2013)

---

dwain.c (1/8/2013)

---

Am I the only one that finds these kinds of SQL puzzles fun?

http://www.sqlservercentral.com/Forums/Topic1403293-392-1.aspx

Come on! Surely some of you heavyweights can whip up a cool solution to...

I was just wondering if you had any luck with this.

Lowell (12/6/2012)

---

if you've got the linked server up and running, that's 99% of it;

the rest is just syntax.

something like this is how you update from another table...and it doesn't matter...

And neither do I. I do like a bit of controversy in my otherwise dull life though. 😀