You think that's funny - try picturing him with...

Ray M (12/10/2008)

---

are you trying to exceed the nvarchar(4000) to use in an sp_executesql statement?

I don't know that you can.

what in the world are you trying to execute that is...

The loop will tend to incur a rather severe penalty on larger sets. You could use something like this (note that this syntax could simply be used inside of...

I don't know how big the script you need is, but you can concatenate multiple nvarchar's together during the EXEC call.

declare @nv1 nvarchar(4000)

declare @nv2 nvarchar(4000)

select @nv1=replicate('select getdate();',235);

select @nv2=replicate('Print ''Hello There''',210);

select...

Of course - close encounters with high velocity pork chops (whether fired from slingshot,...

kanejeeves (12/10/2008)

---

Dcarlson (12/10/2008)

---

Steve Jones - Editor (12/10/2008)

---

I think the nomenclature here is confusing people.

The database is the schema+data+physical files. You wouldn't put this into VCS. You would put in the...

That was a half thought not fully finished. There are a LOT of times when you can have a full environment wiothout having to have a full copy of...

GilaMonster (12/9/2008)

---

Matt Miller (12/9/2008)

---

while (@i<50000)

BEGIN

SELECT *

Into #tempTable

from MyHumongousTable --1,750,000 rows

update MyNewTable

...

Lynn Pettis (12/9/2008)

---

While you are at it, here are two of my favorites from my previous employer (yes, I stll remember the code well, and it is also COBOL).

IF X...

Grant Fritchey (12/9/2008)

---

That last query... the uh... you know it... well... uh...

Never mind. That actually makes my current local favorite look intelligent:

DECLARE @i int

SET @i =1

IF @i = 0...

You declare @note, but never give it a value. So - you don't get anything qualifying for your query.

Which is really fine, because that's not how you want to...

kanejeeves (12/9/2008)

---

What do you do with different releases then? For ex, TFS/DEV/Release1, TFS/DEV/Release2...

Steve Jones - Editor (12/9/2008)

---

Roy, when you say promote and merge into the mainline, you really mean two developers communicating, correct? Someone has to physically look at the patch that...

It looks to me the easiest way owuld be to put the second if inside of a SQL variable statement...

Keep in mind that the BETWEEN statement you're using MIGHT double count some items. depending on how you store those values - it could be counting the first of...