Now that is something that you might want to consider a CLR assembly for.

Oh, right. :w00t:

Lynn Pettis (12/9/2008)

---

IF TAX_CODE = 1 THEN TAX_CODE = 0

ELSE IF TAX_CODE = 0 THEN TAX_CODE = 1.I think that this is called a "Toggle". 😀

GilaMonster (12/9/2008)

---

I still think my favourite has to be this piece of code that I found when one of the devs complained that the dev server was very slow. The...

Why is this a requirement? It...

It doesn't work like that. SMO objects are not persistent objects in a database, like SQL Server objects are. SMO objects are ephemeral instances of SMO classes that...

Ah vendors. Gotta love'em.

Why can't you just execute the script?

Alan Naylor (12/8/2008)

---

Ths is the correct solution.

Declare DDOKRaw cursor for

Select [field name],startingposition, fieldlength from dbo.TablefieldPositionLength

DECLARE @insert_part varchar(4000)

DECLARE @value_part varchar(4000)

DECLARE @loop int

Declare @fn varchar(128)

Declare @sp-2 varchar(128)

Declare @fl varchar(128)

Open DDOKRAW

Fetch...

Dan Epps (12/7/2008)

---

Not without tons of mods the the forum software. We're only talking about a half-million or...

But this is more than bad design, it's just completely unnecessary. Excel adds nothing to this process, except limitations and overhead.

Kris (12/8/2008)

---

The reason it must dragged into a spread sheet is because researcher want to be able to extract the data from the DB and perform statistical analysis on it...

Dang, every time I see that "NOT EXISTS using a JOIN" trick, I think that it's a No-Op and I take it out... 🙁

Anyway, this corrected version gives correct...

Glad we could help.

What do you mean by a "Snapshot"?