That's why I put "new" in parentheses... haven't need MERGE in SQL Server 😉

The loop idea isn't actually a bad one (I refer to it as a "DELETE CRAWLER"), but deletes, by themselves, run pretty quickly depending on the criteria. I'd limit...

PaulB (8/2/2008)

---

I've been there, I done that.

1 Brace for impact, keep your poker face no matter what you see.

2 All Oracle documentation is online and free... try http://www.oracle.com/pls/db102/portal.all_books

3 Subscribe a...

If it's only for two flights, then a simple join between destination of first flight and start of second flight for a given passenger number should do it.

If you want...

I agree with Steve... doesn't matter what the insert order is, you should use ORDER BY in your queries and NOT rely on a physical order. You can force...

What I think is interesting about that blog, is that it's the person writing the blog who is sometimes the "dumbass". One guy wrote about the ol' turbo button...

That's correct... I missed that little "nuance"...

The code needs to look like this... Note the parentheses around @ExStr in the EXEC statement.

DECLARE @ExStr varchar(500)

SET @ExStr = 'CREATE TABLE dbo._X080805...

jon.hart (7/30/2008)

---

I'm using a machine dedicated to this SQL 2008 evaluation. VMs do not provide a genuine real worl experience, whatever Microsoft say. Yes I can uninstall and...

Put the table name in brackets.

Based on the previous questions asked by Lateesh, I'm gonna say this isn't homework...

SELECT STR(STUFF(1234567,4,0,'.') ,5,1)

It depends... if you're not going to do anything to the values other than add or subtract... no problems. If you're going to do anything else (like multiply or...

Chris Morris (8/1/2008)

---

Hi Meeraj, apologies for the delay in replying to you.

Here's a script for creating a Numbers or Tally table, which you will see often on this forum.

IF...

With the advent of VARCHAR(MAX), there's just no need for cursors anymore... for example...

DECLARE @sql VARCHAR(MAX)

SELECT @sql = COALESCE(@SQL+CHAR(10)+' UNION ALL --------------------'+CHAR(10),'')

+REPLACE(

' SELECT '' '' AS...

Nah... don't bother changing it if you're just going to use recurrsion....

As Ryan suggested, you should consider NOT storing delimited data in a single column...

If it's not something you can control, then Vaseem was on the right track. Even with...