At a guess, I would think you need to contact Microsoft.

I don't know if this document tells you anything helpful (I haven't read through the whole thing yet). Microsoft...

What logic determines IN verses OUT?

Hard coding based on the dates given is not wise. Ideally, code should be written to logically decide what fits either circumstance depending on other...

Orlando Colamatteo (2/13/2016)

---

I would say it as "because integrating with Excel sucks that way." It is not technically Excel that...

Alan.B (2/23/2016)

---

I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then...

djj (2/18/2016)

---

Hey, who shut down the water cooler? I do not post often here, but I read it every day. Usually there is a lot going on by...

Honestly, if knowing how SQL Server works is NOT part...

So what smtp stuff are you logging? IIS stuff? Or database mail?

Sean Lange (2/12/2016)

---

Brandie Tarvin (2/12/2016)

---

Thank you backup, Sean. I'm still shaking my head over the OPs initial "you're wrong, that can't be done after all" and then "Well, prove it"...

I know this thread is "dead," but ...

Update for those who stumble across this thread like I just did, if you have a 64-bit box, follow the instructions here or...

TheSQLGuru (2/11/2016)

---

Whenever I am building out dynamic SQL I always use SET QUOTED_IDENFITIER OFF first and then use double quotes in the outer sections of text. Then I never have...

Thank you backup, Sean. I'm still shaking my head over the OPs initial "you're wrong, that can't be done after all" and then "Well, prove it" responses.

EDIT: I found it...

webrunner (2/12/2016)

---

I eventually found out what was happening.

I was using @[User::Variable] = 0 instead of the operator to check for equality @[User::Variable] == 0. Once I fixed that the branching...

The reason I haven't shared the code is because this is a great time...

Well, I'm sorry to disagree with...

Nevermind. Found my answer here: https://msdn.microsoft.com/en-us/hh500335(v=vs.103).aspx