I would think Mark's solution with a range table and using an INNER join would be better. I would also move the ORDERing out of the procedure and into the...

No questions are stupid, they're just sometimes "untimely" as in the answer comes to you right after you ask it.

UPDATE yourTable

SET yourColumn = UPPER(yourColumn)

SELECT UPPER('yourText')

This is NOT a direct answer to your question, but perhaps it will get you thinking towards a "compact" solution.

This requires the use of a numbers or "tally" table described...

In your case, just plug the numbers into your query.

With all due respect, this community is for people looking for assistance, not complete solutions.

I think I speak for eveyone here in saying that we would more than happy to...

ramaanujamr (6/5/2008)

---

are you guys (jason and Kenneth) having majic wand!. Amazing u guys replied just like a sec. I am sorry i was on vacation. I am working on...

OUCH, stay away from cursors!!!!

I would suggest ...

DECLARE @concatRow VARCHAR(MAX)

-- create...

DECLARE @t TABLE (testData VARCHAR(50))

INSERT @t

SELECT 'ghghgh ghghgh ghghg' UNION ALL

SELECT 'ghghgh ghghxxxhghg' UNION ALL

SELECT 'ghghgxhghg' UNION...

Hmmm, not off the top of my head.

You also need to think about the special case when E.OBSERV_VALUE = @VALUE. 😛

SELECT

DISTINCT C.TEST_DESC AS LAB_TEST_DESC

,E.RESULT_DESC

FROM .....

WHERE

(C.TEST_DESC = @test-2...

That is indeed correct.

CREATE PROCEDURE dbo.PrepTickets_GET_ALL(@partialKey VARCHAR(12) = NULL)

AS

BEGIN

SET NOCOUNT ON

SELECT

*

FROM

...