RBarryYoung (1/10/2009)

---

You would be better off sticking with the newer JOIN syntax:

SELECT ...

FROM (...) AS t CROSS JOIN @blocks b

...

SELECT ...

...

And also, LEFT JOIN is not required here. You can just write it as:

SELECT t.calenderDate,

...

Instead of that CASE in WHERE clause, you could write this:

SELECT t.calenderDate,

...

This could also serve your purpose:

DECLARE @maxrows INT

SELECT @maxrows = COUNT(1) FROM Table1 -- or SET @maxrows = 10;

SELECT TOP (@maxrows) col1 FROM Table1

UNION ALL

SELECT TOP (2) col1 FROM...

You could apply an identity column if there isn't any.

ALTER TABLE table1 ADD id_temp INT NOT NULL IDENTITY(1,1)

-- This adds an identity column (id_temp) temporarily. You can remove the column...

I replaced the http path with a local file path and it worked fine for me. Are u sure the file exists in the path specified?