This is NOT pretty, but it IS functional.

--am trying to write a query against a table of invoices, returning all relevant rows for a particular InvoiceId. Heres some sample data:

--Create...

capnhector (11/28/2012)

---

What i came up with was to turn it into an adjacency list hierarchy and then we can recourse through that. of course i could be completly off...

What value(s) are able to escape the ELSE trap at the end of your CASE statement?

jimgleason512 (11/28/2012)

---

Thanks, Evil Kraig. Your answer makes perfect sense for the larger SQL, which actually 'UNIONs' 3 queries use multipple table-joins, MAX(), placeholder columns and all sorts of...

No.

To help you with this we're going to need more information. What is DB2, is that a database on the server or is that your linked server? What...

Do you perhaps have a second select running after the main query that gives you rowcounts or the like? These rows would be added to the first 'total rowcount'...

You're on the right track but you missed a small detail that would make your life a lot easier. It's in the precedence constraint (the green lines you drag...

Personally, unrestricted with warnings that watch the drive(s) itself for space issues.

tan110 (11/27/2012)

---

SSIS - Using Dataflow task to insert records 47 mill records from a SQL Server 2008 r2 db to a destination SQL Server 2008 r2 db, but the log...

Paul Smith-221741 (11/28/2012)

---

The Data is looking like the following

Textbox43 Textbox44 ExpressionResult

50 ...

The datasource is linked directly to the schema of the table. When the schema changes, anything that connects to it must be...

You'll find most folks here are a bit loathe to answer interview questions, and we've become pretty adept at picking them out when someone isn't up front about it. ...

wolfkillj (11/26/2012)

---

I hope that the OP simply mistyped his question and meant to say that "SELECT <column_name>" will be better than "SELECT *". There are many more, and more important,...

Long list of reasons, anything from the target field in the table being defined as NOT NULL to row redirection in your components. Use the dataviewer on the dataflow...