erikd (12/20/2013)

---

Nuts. The query I had did it pretty quick with about 40 columns and 200k rows. For some reason I felt silly writing OR 40-ish times, but not enclosing...

Thanks for sharing...

erikd (12/20/2013)

---

Just kind of eyeballed this because I just used similar syntax to find the max value across multiple columns for something else.

SELECT TOP(1) TimeStamp,

(SELECT MIN(g)

...

andyscott (12/20/2013)

---

Unfortunately not. If it can't be done using standard...

Kurt W. Zimmerman (12/20/2013)

---

Sean;

Interesting solution... I had something much like yours getting the same results the only difference is I split out the 3 different subjects into separate...

For this type of heavy string manipulation I would rather use CLR. Is that an option at your shop?

You better read up on sql injection. This code is very vulnerable.

It would be much better if you posted your table as a create table followed by insert statements.

I took the liberty of formatting your query so we can read it.

SELECT...

Thanks for the ddl and sample data!!! What you are describing is a cross tab or pivot table. I generally use the cross tab approach because I find the syntax...

Since you are pretty new around here and the Holiday Spirit took over I put this together for you as an example of how you should post your tables and...

Doh!!! Sorry about getting your name wrong. :blush:

Grant Fritchey (12/19/2013)

---

Sean Lange (12/19/2013)

---

Koen Verbeeck (12/19/2013)

---

GilaMonster (12/19/2013)

---

Not that I would stoop so low as to beg for votes, but I do need a new costume (Star trek if anyone...

Koen Verbeeck (12/19/2013)

---

Sean Lange (12/19/2013)

---

Koen Verbeeck (12/19/2013)

---

GilaMonster (12/19/2013)

---

Not that I would stoop so low as to beg for votes, but I do need a new costume (Star trek if anyone...

GilaMonster (12/19/2013)

---

Sean Lange (12/19/2013)

---

Koen Verbeeck (12/19/2013)

---

GilaMonster (12/19/2013)

---

Not that I would stoop so low as to beg for votes, but I do need a new costume (Star trek if anyone cares)

https://www.surveymonkey.com/s/TribalAwardsVoting

:-D...

Shanmuga Raj (12/19/2013)

---

CREATE TABLE [dbo].[Product_Table](

[Product Id] [char](10) NULL,

[IsPrimary] [int] NULL,

[Quantity] [numeric](18, 0) NULL

) ON [PRIMARY]

INSERT INTO Product_Table ([Product Id], IsPrimary, Quantity) VALUES ('P001', 1, 0)

INSERT INTO...