Here is how all of the threads that you have started sound.

There were two crocodiles flying. One to the south but another one was blue.

Question: How many seats...

capn.hector (4/13/2012)

---

ok on topic: http://www.sqlservercentral.com/Forums/Topic1283271-392-1.aspx how do you long time posters keep going when you run into people like this. (one thread there are more out there)...

stephanie.sullivan (4/13/2012)

---

I was more thinking as a way of producing the tally table itself - Jeff uses an identity and cross joins sys columns. This method may or may...

Wow your first post and you posted all the ddl and sample data perfectly!!! Excellent!!! I wish everyone who posted paid as much attention.

Now for your issue. I see what...

Excellent job posting ddl and sample data. You need to do a dynamic cross tab. Jeff has a couple articles that explains this.

Cross Tabs and Pivots, Part 1 – Converting...

And for what it is worth the image is deprecated. You should instead use varbinary(max).

http://msdn.microsoft.com/en-us/library/ms187993%28v=sql.105%29.aspx

You may find some benefits by removing these huge columns from this table into either their...

stephanie.sullivan (4/13/2012)

---

prima facie this seems a good way to produce a tally table

I'm also going to have a play to see whether you can have a formula as the...

Scott D. Jacobson (4/13/2012)

---

I'm also going to have a play to see whether you can have a formula as the increment field. I'm not sure yet just how useful...

What is wrong with IDENTITY? It is super easy...

Thomas Abraham (4/13/2012)

---

Nice question. As others have said, I don't use the with ties much, but it was good to have to study it a bit. Thanks for the effort!...

EL Jerry (4/13/2012)

---

I entered the values in random order so it would not be that easy or obvious when you look at it on the screen 🙂 ....

I too was wondering why the sequence thing was such a big deal. Thanks okbangas for your example and explanation. That looks like it could be really useful in certain...

Post it?

Well it sounds like you have now done all the work to create the sql. Give it a try, I think you are closer than you think.

GSquared (4/12/2012)

---

I'm in the top 25 (usually in the top 10),...