Is BadgeType = Reader in your sample data?

I dont seem to understand what is in your sample data and whats in your expected result. Also, can you be more...

UNPIVOT it is 🙂

Can you show us the expected output out of the sample data you provided?

LOL.. I'm master of NONE :w00t:

Try this chunk instead

,(select

CASE

WHEN cptcode LIKE '%99281%' then '1'

WHEN cptcode LIKE '%99282%' then '2'

WHEN cptcode LIKE '%99283%'...

I find the column name is incorrectly mentioned

Select col1, col2,col3 =

case col3 when > 0.7 then 0.7 else col3 End

That "equals" sign was missing.

Is that it or am i...

Slightly improved version

DECLARE @Tab TABLE

(

column1 INT

,column2 VARCHAR(2000)

)

INSERT INTO @Tab

SELECT 1, 'wo 99808944.PDF|F|Q:\Links\WO...

That is because the 99808944.PDF did...

How about this?

DECLARE @Tab TABLE

(

column1 INT

,column2 VARCHAR(2000)

)

INSERT INTO @Tab

SELECT 1, 'wo 99808944|F|Q:\Links\WO...

Union ? Why union? I gave a cross-tab type query. The UNION ALL is for...

Without a predefined pattern, it is tough to find out the file names.

It is possible though, if we have the list of file extensions, but still, the whole string should...

This?

DECLARE @Tab TABLE

(

Src VARCHAR(10)

,Category VARCHAR(3)

,Amount DECIMAL(10,2)

)

INSERT INTO @Tab

SELECT 'Source...

Jeff Moden (3/22/2012)

I have to say that I agree with that. If the rows are in the random order provided...

Yep

Select '(' + LastName + ') , ' + FirstName AS FullName From Table

Select FirstName + ' (' + LastName + ')' AS FullName From Table

No Need to join.. Just the concatenation operator "+" to concatenate them

Like

Select FirstName + LastName AS FullName From Table