Hey, Ninja, I just realized that Varchar(MAX) isn't big enough to handle a database with a lot of tables. I've tried it on two of my "larger" databases (object-wise, not...

I'm curious. Why does a simple concat need variable = variable + string logic? I only ever use that when I'm COALESCING or looping (Cursor or While).

What are you...

The context is this:

RE: datatypes discussion

---

When you specific MAX, the data types can store the same size data as text, ntext, and image types (up to 2 gigabytes) but process...

WayneS (4/12/2011)

---

Brandie Tarvin (4/12/2011)

---

I think this cursor suits Stefan's needs best.

DECLARE OMG_NotAnotherCursor CURSOR GLOBAL_SCREAM BACKWARD_FACING

STATIC_THE_SUPERHERO PESSIMISTIC DB_LOCKDOWN

FOR

SELECT Superpower

FROM dbo.JusticeLeague

WHERE SupType = 'Lightning'

OPEN OMG_NotAnotherCursor

FETCH LAST FROM OMG_NotAnotherCursor

...

You probably didn't see my edited comment.

Check the Server / Instance's "remote query timeout" property. This can be found by right-clicking the server\instance name, navigating to Properties, the clicking on...

This .net application, is it making a Web Service call or is it a direct programmed connection string?

Is there a firewall between the PC this app runs on and the...

I think this cursor suits Stefan's needs best.

DECLARE OMG_NotAnotherCursor CURSOR GLOBAL_SCREAM BACKWARD_FACING

STATIC_THE_SUPERHERO PESSIMISTIC DB_LOCKDOWN

FOR

SELECT Superpower

FROM dbo.JusticeLeague

WHERE SupType = 'Lightning'

OPEN OMG_NotAnotherCursor

FETCH LAST FROM OMG_NotAnotherCursor

INTO @WhatsThisVariableForAgain

WHILE...

Stefan Krzywicki (4/11/2011)

---

GilaMonster (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

Believe me, I don't want to be using a cursor, but it is part of production code and every time I mention changing it to...

Sure it is. Just remove everyone's system access. Then they can't give...

Scope creep.

(and, lemme tell you, Mr. Scope is definitely creepy. @=)

HA! As if.

Cluster down again. Much scrambling to get things working before the BU showed up.

Does it count as murder if...

That's what I figured. But fortunately, that's not a problem for me today.

Jeff Moden (4/7/2011)

---

Brandie Tarvin (4/7/2011)

---

Well, that was harder than it needed to be. And the solution is easier than I expected. Now I just have to replace my field values...

My only issue with sorting was making sure I didn't have two copies of the same record with the errors flipped (Ship Date; Sale Date vs Sale Date; Ship Date)....

Update from the front. I have replaced my multiple inserts with an UNPIVOT. Rather than compare 15 different columns as listed above, I've done the following:

ALTER TABLE DT.Staging

ADD...