I'd suggest something along the line of:

DECLARE @Files TABLE (FileName varchar(100));

declare @sql varchar(max),

@FilePath varchar(100),

@FileName...

Stefan Krzywicki (9/15/2010)

---

Alvin Ramard (9/15/2010)

---

CirquedeSQLeil (9/15/2010)

---

jcrawf02 (9/15/2010)

---

Couldn't have anything to do with the fact...

Craig Farrell (9/15/2010)

---

For the code, you'll really...

You're quite welcome. Glad I could help.

jeff.mason (9/15/2010)

---

I don't know what I would do when stuck in a rut without a place like this. With so many of you...

FelixG (9/15/2010)

---

I need to get...

jeff.mason (9/15/2010)

---

Yeah, I know, I feel stupid too. What can I say, it was 11:30 PM, we are tired, and stuck in a rut for troubleshooting. We attacked...

Something like this should get the top two of each:

DECLARE @Orders TABLE (ProductCode int, OrderDate datetime, OrderNumber varchar(5));

INSERT INTO @Orders

SELECT 1, '20100915', '11112' UNION ALL

SELECT 1, '20100823', '11122' UNION ALL

SELECT...

Yes.

select t1.*

from dbo.table1 t1

LEFT JOIN dbo.table2 t2

ON t1.col1 = t2.col1

...

Why wait that long? A 5 minute start is all he should get... :w00t:

Craig Farrell (9/15/2010)

---

And thus, we find...

Are the items in bold in the wrong order?

Wouldn't you use DT_DBDATE instead of DT_DBTIMESTAMP? Also, try replacing the "/" with "."

Maybe, but sometimes it's draw,shoot,aim instead of aim,shoot,draw... heh, wait-a-minute... :crazy:

Hey you'll...

I know a lot of people don't like Joe Celko's online personna. You might be interested in how his tone changed in this thread after it was discovered the...

No problem - glad I could help.