Yes, got it, sorry.

For this example, why even use LIKE?

SELECT

S.TTR_ID

,S.TTR_TXT

FROM dbo.TBL_TEST_RX S

--WHERE S.TTR_TXT LIKE '[%][ ]%';

WHERE LEFT(S.TTR_TXT, 2) =...

Anyone actually check this code?

I believe the RANK statement in the CTE is incorrect (see corrected version below) if the intent is to remove duplicates for ItemNumber only. At...

Actually for readability, this one's even better,

It has only 32 "words" compared to your 70,

182 non-space characters to your 363,

and runs just as fast:

select

u.UserID

, stuff((

select ', ' +...

OK, then use GROUP:

--An alternative without ROW_NUMBER()

--How about this?

select

u.UserID

, stuff((

...

--An alternative without ROW_NUMBER()

--How about this?

select distinct

u.UserID

, stuff((

select ', ' + u2.RoleName

from @UserRole u2

where u2.UserID = u.UserID

and u2.RoleAssignedDate = (

select min(u3.RoleAssignedDate)

from @UserRole u3

where u3.UserID = u2.UserID

and u3.RoleName = u2.RoleName

)

order by...

-- how about?

SELECT

pv.ProductID

, pv.Version

, pv.MinorVersion

, pv.ReleaseVersion

, pv.StandardCost

FROM Production.ProductVersion pv WITH (NOLOCK)

WHERE EXISTS (

SELECT *

FROM (

SELECT TOP 1

pv2.ProductID

, pv2.Version

, pv2.MinorVersion

, pv2.ReleaseVersion

FROM Production.ProductVersion pv2 WITH (NOLOCK)

WHERE pv2.ProductID =...