Hi Solomon,

Yep, adding the notation character to that one line appears to do this job. I tested Comments, Posts, and Pages, and all 3 now correctly stored the characters.Well done...

Casting a literal NULL to a data type in a CASE is somewhat pointless; it'll be converted to the highest precedence data type of the non-NULL literals or column (which...

Jeff would be referring to their very well known DelimitedSplit8k function, which also...

Well no, but there were no parameters in your script, nor was it provided as a Procedure; I...

Assuming that if there is a *** to start a section, there is always a corresponding *** to end it, then I would actually use a could of CHARINDEXes in...

If I am understanding what you appear to be describing, you could use a VALUES table construct:

SELECT V.I,
       ISNULL(YT.YourColumn,0) AS YourColumn
FROM...

The problem is the parser here. You are attempting to create the same object twice in the same batch, and thus the parser sees the second attempt to create the...

Hi Solomon,

Sorry not replied to this, December wasn't a great month for me, so didn't have my head in the game. I'll have a look at this later this week...

If I can find what I saw at the time and pass along some suggested changes, could you help me test it? And if successful, I can post the...

Thanks Solomon. It's bitterly disappointing that this was raised back in April of last year and not fixed yet; I didn't even think to look for a report and I...

True, though one would expect SSC...

I've edited the initial post, nothing I can personally do about SSC's data choices unfortunately.

Yep the question I wrote doesn't have a question mark in it, it had a...

I assume all you need it this:

LEN((DT_WSTR, 4) [Your Column]) == 4

If the values can also be longer than 4 characters as well increase...

I assume all you need it this:

LEN((DT_WSTR, 4) [Your Column]) == 4

If the values can also be longer than 4 characters as well increase the length of...