The parameter is a varchar (a string), and must be converted to an int for his calculation.

So it can't have / in it.

assuming he wants year last (is start date...

Charles Deaton (7/11/2011)

---

I looked at full text for this and can't see that it would work. We do currently use full text but on a "comment" value stored in the...

Heh, my first time bit of practice using UNPIVOT, and I discover that I should never seldom use it.

Now I have to find an excuse to practice using CROSS APPLY.

opc.three (7/8/2011)

---

SQLkiwi (7/8/2011)

---

16-core test machine:

---------------------------------------------------------------------------

build temp tables

---------------------------------------------------------------------------

String...

opc.three (7/8/2011)

---

Nevyn (7/8/2011)

---

Do you want to show 4 nulls if there...

Do you want to show 4 nulls if there is a...

Jeff Moden (7/7/2011)

---

For what it's worth, here's my rendition of how this problem might be solved. It doesn't preserve dupes and it sorts the HobbyNames on each row alphabetically....

I think you misunderstood the question, Mike. They are asking if the same hobby (Tennis in the example) appears twice in the four possible hobby records whether you want...

Is the query above correct? Why would you link the tables on the two identity rows?

Was that meant to be "inner join EMaster a on a.sid = b.salesofficerid"??

Anyway, the answer...

You had a typo in your solution (used hobby1 twice from the first table), but that wouldn't effect the performance.

But doesnt this build...

My first instinct would be to create a nonclustered index on EvidenceLetter in Podrobnosti, and then populate the form using a stored procedure that takes EvidenceLetter as input and performs...

Yeah, I'm not sure if he thought he'd get 6 or 7 different working answers.

The string manipulation is probably the fastest.

I wanted to try the UNPIVOT/PIVOT just for the heck of it.

Using Opc.Three's test setup, here is what I did first:

;WITH OneTableCTE AS

(

SELECTa.id,

a.hobby1...

Can't you just unpivot and then repivot?

gary.proctor (7/6/2011)

---

Wow.

Thank you for the immediate responses.

Unfortunately I abreviated the example for the sake of space.

While MIN & MAX solution will work nearly every time...

It is possible...