Ken Messner (6/1/2015)

---

There are times in system design when one may choose to implement significant chunks of business functionality in T-SQL, as opposed to a non-database language. The reasons...

patrickmcginnis59 10839 (6/1/2015)

---

Comes from "Edsger Dijkstra's letter Go To Statement Considered Harmful, published in the...

Hugo Kornelis (5/28/2015)

---

Okay, I am going to contest this one. I know that Books Online says that "Aggregate" can be "a logical operator or a physical operator". But who has...

+1

When I saw "day number" without a qualification of "month" I assumed day-of-the-year was meant. Of course, none of the answers yield 145, so my assumption was clearly false!

Great question! It illustrates the benefits and dangers of using unaliased column names in queries. IIRC SQL looks in the current namespace for a match on the column...

That sounds likely but it is still unacceptable since I changed nothing

Alas, I don't think you can run DESC over OPENQUERY, since it is not a SQL command. I think you can only do that with the SQLPLUS command.

Could...

Thanks for the tip!

Unfortunately, these queries returned empty result sets for me, though the server, schema and tables/views most certainly exist (and I can query them using OPENQUERY)

Actually what I...

Smash125 (5/13/2015)

---

Dell - Internal Use - Confidential

I have kind of tricky requirement.

A.We have Total Budget cap for ‘2016-Q1' is 3600. If the Budget cap goes...

Can you post the segment of XML that covers that field?

No need to use the expression task its true, but the task makes it more visible than buried in the connector properties.

Why not just use an Expression Task (I see you are on SQL Server 2012) to generate the file name? I'm not sure that the script task is necessary...

I'm still looking for mention of "get or set the authentication message" in the reference link. I can't find it there, though the property "specifies the type of authentication"...

Try adding some script tasks/components to the child package that use MessageBox.Show() to tell you where you're at in the child package. YOu can also display useful stuff like the...