GSquared (4/20/2011)

---

GilaMonster (4/20/2011)

---

LutzM (4/20/2011)

---

Is there any other method than using the mouse pointer? There are so many words on the screen. How else to keep track where the next word...

You're most welcome Amy.

This article should help you out: SQL Server Ranking Functions[/url]

Well, what you have is one of the standard date formats (20/120). I guess what you need is to pick which one you actually want... this might help you out:

SET...

Well, yeah, but...

;

WITH cteAccountOrder (ColumnName, ColumnOrder) AS

(

-- the preferred sorting order when > 2 accounts in a row

SELECT 'Acc1', 1 UNION ALL

SELECT 'Acc3', 2 UNION ALL

SELECT 'Acc2', 3 UNION ALL

SELECT 'Acc4', 4

),...

What you are looking for is to PIVOT the rows into columns. Please check out the two articles linked to in my signature dealing with CROSS-TAB or PIVOT tables: Parts...

Brandie Tarvin (4/20/2011)

---

WayneS (4/19/2011)

---

Greg Edwards-268690 (4/19/2011)

---

GSquared (4/19/2011)

---

And Joe's answer,...

Just to make sure you understand... the temporary tables still physically reside in tempdb. They still show up in tempdb.sys.tables and tempdb.sys.columns (indexes, constraints, etc.) They are just of the...

Greg Edwards-268690 (4/19/2011)

---

GSquared (4/19/2011)

---

And Joe's answer, while demanding that...

Edit: in hindsight, I was inappropriate. Comments removed.

have you tried varbinary?

NP. After you have tested everything out, please respond back with how things are going. (BTW, I only tested this on a SQL 2008 box, but I believe that it...

MV,

If you're willing to help us help you, I think we can come up with something.

What I need is for you to read the first article in my signature, then...

Look at the two links in my signature dealing with Cross-Tabs and Pivot tables. Part 2 covers dynamic pivoting.