Scott and Michael,

Thank you both for taking the time to help with this query.  I guess I never tried this because my thought process would be that this query would...

• This reply was modified 2 years, 9 months ago by  Owen White.

Nothing like going to the beach in the middle of the summer to cool off only to find out that the water is almost 80 degrees!  Not the cool off...

Jeff W,

You have provided a very strong argument for rewriting this in SQL code itself.  Based on all of the feedback, I think no matter what I do I am...

Jeff M,

I can't stop laughing at your response.  You are correct that I am trying to leverage previous work done in the stored procedures instead of rewriting the logic again. ...

Michael,

Unfortunately, I am not able to purge the data prior to loading.  This must be a RBAR - find and create or update based on the existence of the record....

Phil,

Thank you for the reply.  Unfortunately, a ExecSQL Task will not work for our scenario.  I do understand the RBAR process that we are doing as time is not an...

The issue seems to be fixed in later versions of SSIS/Visual Studio.  My current version of Visual Studio was 2012.  Once I upgraded to VS 2019, the issue no longer...

I would prefer not take the XSD out of the equation but I can try that. The XSD ensures the incoming files meet the requirements of the data collection. The...

Thank you!  That was my mistake.  I thought the QoD would get reviewed before they published it.

To all,  I apologize for the bad example in the CASE Statement and it was not a trick question.  Yes, it should have been the following:

CASE my_field ...

This was my...

I want to thank you for this clear explanation. So when using the LIKE keyword 'AAA ' is returned because trailing spaces are ignored. 'AAA...

I am not trying to be difficult but no one in this thread has answered my question. How does SQL know to look for anything trailing the AAA and...

You never answered my question!

I still do not understand the answer to my question, where is the wildcard in the question why does it assume % at the end?

I have to be honest in that I cheated. Where is it documented that not using % assumes % at the end? I thought that this was a...