This is similar to the option previously posted by Anthony using the DelimitedSplit8k.

WITH CTE AS

(

SELECT *, MAX(ItemNumber) OVER(PARTITION BY hid) - 1 AS thisItem

FROM #test

CROSS APPLY dbo.DelimitedSplit8K (hid,',')

)

SELECT Item

FROM...

Just if anyone wants an example that is not as complex as the one from Drew (that problem required a more complex solution than this one).

WITH CTE AS(

...

If you were working on a 2012+ version, you could use try_parse, try_convert or try_cast.

Otherwise, you need to do it manually.

SELECT *

FROM tbl

WHERE CASE WHEN Column1 NOT LIKE...

That should correct that issue, unless is code related. You still have to work on that...

kaj (11/17/2015)

---

You have a few places in your query where you apparently need trimming on join fields:

UPPER(LTRIM(RTRIM(FIS2_Account_Shared.TD_LEGAL_ENTITY))) = UPPER(LTRIM(RTRIM(FIS2_Acct_Lgl_Ent.MNEMONIC)))

OR UPPER(LTRIM(RTRIM(FIS2_Account_Shared.TD_LEGAL_ENTITY))) = UPPER('TD SECURITIES CANADA')

In my limited experience...

It's too late for that. Unless someone wants to...

If you...

Yes, it's...

Step 1: Prepare 3 envelopes. :hehe:

SoHelpMeCodd (11/17/2015)

---

Passing a delimited string certainly works. But I am currently working an issue where one sproc uses STUFF FOR XML to create a delimited string. A second sproc accepts...

ChrisM@Work (11/17/2015)

---

From some time yesterday through to the present I've been noticing something a little odd. In the workplace, on the commute home last night (the walk, the tube, the...

Anything or nothing that is not...

Empty space in data files won't hurt performance, unless the disk is full and that prevents OS operations. Growing a file is expensive, so you must plan to leave free...

If I understand correctly, you want something like this:

SELECT DISTINCT ProjectName AS Project

FROM Timesheet

WHERE (@ProjectType = 'P25, R&D' AND (ProjectName LIKE '2%' OR

...

Jabba