I'm glad that I could be of help. It's weird to be called Sir Luis, makes me feel like someone important. 😀

Not exactly what you might be looking for, but instead of trying to add commas after each character, you can use a subquery in the IN clause. Something like this:

WITH...

Save it as .sqlplan (right click to save) and below the post editor, there's an attachments option.

Could you post some sample data in consumable format(Insert statements or a CTE)? That would help us to know what would be the best option.

Do you only have those characters at the end of your string? you could simply use REPLACE or if you just want to eliminate the last ones, there's a more...

I don't believe that there's a performance difference. However, I'm not sure why would anyone use so many gotos, seems like spaghetti code for me.

dwain.c (10/9/2013)

---

Luis Cazares (10/9/2013)

---

You need a Units table or at least a Units set to look for all units. after that the rest is easy, just add a RIGHT JOIN.

SELECT...

Let me quote myself.

And to quote Nevyn

And second, you...

That's because JOINs don't support correlated subqueries. Change the INNER JOIN for a CROSS APPLY. 😉

You need a Units table or at least a Units set to look for all units. after that the rest is easy, just add a RIGHT JOIN.

SELECT

count(fr.[Unit]) as Actual,

fr.unit,

[1st_of_month],

last_of_month

FROM...

Jeff's string splitter uses CTEs, but that would have been my first suggestion.:-)

Why do you want to limit the methods? You might be losing performance over strange requirements.

You could use CLR, but I'm not sure if that counts as a loop for...

Have you tried the TRY..CATCH to handle errors?

http://technet.microsoft.com/en-us/library/ms175976(v=sql.105).aspx

It would be great to at least cover the basics.

It seems important to be prepared if MS ever discontinues the extended procedures.

There might be something weird. Maybe the collation used or the way you expect your results.

This returns 'False' for me with the following collation SQL_Latin1_General_CP1_CI_AS

IF 'alphabet' > 'ax'

SELECT 'True'

ELSE

SELECT 'False'

What...