I would have to agree with this. It is hard to diagnosis problems without...

It would help if you'd provide the DDL for your table, sample data in a readily consummable format (that can be cut/paste/run in SSMS to load the table created by...

GSquared (7/14/2009)

---

RBarryYoung (7/14/2009)

---

GSquared (7/14/2009)

---

Gaby Abed (7/14/2009)

---

GSquared (7/14/2009)

I must be missing something. You have my screen name on the part that I wrote. Or are you asking if I'm...

I have run into these myself at times. Not really a sqlservercentral.com problem. Other sites may require...

What would help is if you could post the DDL for the tables, some sample data for the tables in a readily consummable format (can be cut/paste/run in SSMS to...

Nope. From the original post:

The other post I referenced reinforces...

JLSSCH (7/14/2009)

---

The STUFF function should only be executed if the 10th character is an 'H'. Therefore, the STUFF function should be used in combination with a SUBSTRING function and...

Fatal Exception Error (7/14/2009)

---

I am modifying some old code and I am running into a strange error when I run the following

select

column1

,column2

,column3

,TollFree# =CASE

WHEN LEFT(a.phone_txt,3) IN ('800','866','877','888') THEN A.phone_txt

WHEN EXISTS...

In an active/active cluster each instance is only active on one node. For instance, you have InstanceA and InstanceB, with InstanceA running on Node1 and InstanceB running on Node2....

Here is some code with the DDL for the table used. I'll let you populate the table with test data, mine has approximately 20,000,000 rows of data. You...

GilaMonster (7/13/2009)

---

For that matter, anyone heard from Grant? I think...

rf44 (7/12/2009)

---

Lynn,

I never said it was an answer you see all the time. I just replied to the question "What's the worst SQL Server advice you see regularly", and believe...

rf44 (7/12/2009)

---

Maybe I should precise that I never intended to promote or even condone the use of cursors. I know that cursors are not efficient tools in MS SQL Server...

Yes there is. I'll...

Florian Reischl (7/11/2009)

---

It depends on your scripting options. If you select option "Include IF NOT EXISTS" you get this syntax because there is no other way to handle this for...