That explains why I didn't see it with my Tally table example as well. Thanks Barry.

Lynn Pettis (12/15/2008)

Username ...

That's really not enough information, but if I had to guess based on the field names:

Username ...

We'll call this one the duplicate then.

Please direct all replies to:

http://www.sqlservercentral.com/Forums/Topic619897-338-1.aspx

Please do not double post. First things first, what version of SQL server are you using?

Eeek. Function subqueries with a cross join on top: join Forms f on f.FormId = f.FormId (And one that is completely wrong, since you already joined that...

Aye, just explaining why Mark's method didn't work in this case for future readers.

One of the items you are trying to insert is too long for your declared column size. Check the lengths against your field lengths.

It is my understanding that 6 and 23 would be returned if they had *ever* been used in that table. (for the GROUP BY ALL method)

This is Barry's original case method applied to your table structure.

SELECT *

FROM #Temp

ORDER BY (CASE WHEN ParentID = '1' THEN 0 ELSE 1 END), ParentId

Notice the way Chris...

If it's something you need to do on a regular basis, you're probably going to want to look into setting up a bulk import job. I've never done one...

Is the dataset generated by the first stored procedure being run once, or does it get generated by the first stored procedure being run multiple times? How long are...

IIRC, You can only pass a table in a parameter as of 2K8. That said, there are a number of other ways to accomplish what you're trying to do,...

Heh, oops, yeah, forgot the ISNULL as I was walking out the door as I posted this. Thanks for the feedback.