If you're trying to mimic the results of your SP, i.e., the range appears in two columns, I think this is a pretty simple approach.

DECLARE @INT INT = 225

;WITH Tally...

I appreciate all the responses to my question, especially the Attunity connector which I will need to investigate.

jeffem (6/4/2012)

---

dwain.c (6/1/2012)

---

jeffem (6/1/2012)

---

Dwain, good job on accounting for the missing IDs! 🙂

Just a note about the performance: I did a comparison, and using a table variable will give a...

jeffem (6/1/2012)

---

Dwain, good job on accounting for the missing IDs! 🙂

Just a note about the performance: I did a comparison, and using a table variable will give a bit of...

Koen Verbeeck (6/1/2012)

---

dwain.c (6/1/2012)

---

Calling all SSIS experts that may come to the water cooler for a drink!

I have posted an SSIS question in the SQL 2008 General forum and I'm...

Koen Verbeeck (6/1/2012)

---

dwain.c (6/1/2012)

---

I believe Oracle does have a TOP clause but I'm not really an Oracle guy. I do understand how that would make development less frustrating.

Do you...

Koen Verbeeck (6/1/2012)

---

There's an Integration Services forum in the Datawarehousing section more at the bottom 🙂

Every time you open a package or when you run it, the connection managers will...

Calling all SSIS experts that may come to the water cooler for a drink!

I have posted an SSIS question in the SQL 2008 General forum and I'm not sure that's...

DBCC TIMEWARP (SELECT Timestamp FROM riya_dave WHERE DDL IS NOT NULL)

DBCC TIMEWARP GETDATE()

I do deplore dynamic SQL unless you really need it. Try this:

DECLARE @basetable TABLE

(caseid INT, formname VARCHAR(255), name VARCHAR(255), value VARCHAR(255))

INSERT @basetable(caseid,formname,name,value)

VALUES

(1, 'Highways', 'roadname', 'darlington...

You can also do it with a subquery like this:

DECLARE @Tab TABLE

( ID INT , ColValue INT)

;

INSERT INTO @Tab (ID, ColValue)

...

Thanks Jeff, Paul and Chris for stopping by again.

I'm amazed this discussion thread is still active!

That record was bugging...

I still want to believe that there must be a method to do this with less JOINs. But you're correct, that without them the ROW_NUMBERs just don't seem to...

Como on guys, you ain't tasted nothin' until you've tasted this one.