Here is the place to start:

https://www.google.com/search?q=truth+tables&rlz=1C1EJFC_enUS816US816&oq=truth+tables&aqs=chrome..69i57j0l5.2671j0j7&sourceid=chrome&ie=UTF-8

I learned about them back in the late 70's while taking a micro electronics class in college.

• This reply was modified 6 years, 11 months ago by Lynn Pettis.

One thing I will tell you that may help is to create a truth table using the rules.  Working through that should help answer your questions regarding the interaction between...

With the new SSC, everything is supposed to run through a dev/QA cycle before prod. We have PRs that require review before they get merged into a deployable...

So, speaking of formatting tools, I just got a complaint because I formatted the code from the stored procedure that I worked on and that generated too many...

Instead of a # temp table, write the data to a permanent table and then drop the table after the BCP export.

Also, stop putting a semicolon before the WITH when...

You really should post your solution. It may help others with a similar problem.

I am sure it can, unfortunately it has been over nine years since I did anything with SSIS so my knowledge is not what it used to be.  One of...

I have been doing this for over 30 years. I found that people who post bad SQL on forums also write bad code in production. As one guy told...

Joe,

In addition to what Thom said, the OP also stated that he is stuck with what he has at this time.  Sometimes you don't have the option to fix things...

When I came back from Afghanistan four years ago I found myself winding down my officiating soccer.  Partly because I coached a U18 girls competitive team in the Fall of...

You are comparing apples to oranges.  The ORDER BYs aren't the same.  If you can't recreate the issue it tells me that it has something to do with the actual...

I have to agree, need to see the code, DDL, and some sample data that recreates the issue.

Change this, FOR XML PATH(''), TYPE).value('.', 'VARCHAR(MAX)'),1,1,'' ), to use NVARCHAR(MAX) in place of the VARCHAR(MAX).  The implicit change is causing you to lose the UNICODE values.

I was getting ready to review Service Broker as I am looking at using it is a small project, so well timed question.  I was able to answer it without...

Sounds like a change that happened at a previous employer after I left.  We had setup numerous SSIS packages using dynamic configurations so we could develop and deploy them to...