Thanks very much!

SELECT U.id, U.requirement

FROM #myTable1

UNPIVOT (requirement FOR col IN (req1, req2, req3, req4, req5)) U;

It never ceases to amaze me how much a question can change from first post to solution.

An entertaining one recently started like this:

---

dear friends

how can i convert a field with...

Robert Frasca (2/16/2010)

---

The whole point of this exercise is to set MAXDOP just for this query but the number of cpu's can be variable. Now, I just realized that...

IS NULL and IS NOT NULL are provided to facilitate comparisons with NULL. Using a function like ISNULL(X, Y) instead is a bit of an odd choice - and...

I hope you now understand why my reply did answer your question on the other thread 🙂

Paul

The original question was from August 2008.

Tell us about your problem - it's likely to be different.

If you really need to store (persist) all the values, the best you can do is...

Here we go then...

-- Switch to the tempdb database

USE tempdb;

GO

-- Drop any objects created by this script if they are still around from a previous run

IF OBJECT_ID(N'dbo.SampleData', N'U') IS...

RBarryYoung (2/16/2010)

---

Paul White (2/16/2010)

---

This strikes me as very funny - but I'm not sure why. Am I missing a...

dr_csharp (2/16/2010)

---

You know that if you don't get an 'appropriate answer' after 3 days, you're...

This strikes me as very funny - but I'm not sure why. Am I missing a reference, or are...

dr_csharp (2/16/2010)

---

Any other details you'd like...

Right. I think I have worked out what you are trying to do. Correct me on the following where I am wrong:

You have data stored in a database...

dr_csharp (2/16/2010)

---

i dont know what do u mean by limitation, cause this function has...