This does not work as I have to give the user two value options for export. One option is the actual ID value of 1 or 2 and the...

I cannot tell you how much I appreciate it. I tend to learn from examples and this will give me great insight into how to write more powerful queries....

The columns are null values so it is truly "No Data." I do have some columns that have default values that might come into play but the columns I...

I really appreciate the reply to my message. I actually just found a similar request in another post that does the same thing that you posted.

DECLARE @t...

I really appreciate the depth on such a common topic. This is a simple scenario with great depth of information that should help any newcomer understand the nuances of...