sure. things get stored physically on...

sqlzealot-81 (10/10/2011)

---

If the clustered index is not created with the UNIQUE property, the Database Engine automatically adds a 4-byte uniqueifier column to the table. When it is required, the Database...

bradmcgehee@hotmail.com (10/3/2011)

---

I don't think I was a clear in my editorial as I should have been. In regards to the job, I was specifically referring to those DBAs who adamantly...

@@datefirst uses the language settings to determine what the customary first day of the week is. Simply changing the language setting (or having it be different in your connection...

djackson 22568 (9/22/2011)

---

Is Apple doing the same thing again? Not sure. This time they OWN the market in a lot of these products, and are extremely competitive in...

Then Create a view on the table which looks something like

select (nz(ColumnA,"")="") as NoValueA, (nz(ColumnB,"")="") as NoValueB, (nz(ColumnC,"")="") as NoValueC, (nz(ColumnD,"")="") as NoValueD from MyTable

Then your Truth table is...

Your example was showing duplicated combinations, so the ranking would have been there to "break the tie"

To get the result in using a table - join your original table to...

Why not create the actual truth table as a table? You're in a database, tables is something it understands.

just make a table with 6 columns:

RuleRank,

ValueA,

ValueB,

ValueC,

ValueD,

Result

And join to it....

(: Hakuna Matata 🙂 (9/21/2011)

---

Gianluca Sartori (9/21/2011)

---

(: Hakuna Matata 🙂 (9/21/2011)

---

Can we rollback if we use truncate command??? I dont think we can rollback since truncate command does not generate...

he's advocating changes the stored procedure to handle the problem as a set rather than one "seeding row" at a time. So rather than looping through and calling for...

Also - keep in mind that switching the compatibility back to 2000 doesn't turn the DB into a SQL 2000 DB. If you have new data types in place...

iposner (9/19/2011)

---

Colin Barry (9/19/2011)

---

Thought provoking.

Why have a service issue the GUIDs? A small bit of clr code could do what you need and would be fast. You could then let...

Why not implement a CLR function to evaluate this? Give it a formula, and it returns the value (cast into some standard type). CLR will give you a...

IceDread (9/13/2011)

---

Jeff Moden (9/13/2011)

---

I have to ask... where do students get the money to travel from Australia to Europe, spend a couple of weeks doing whatever they want, and then...

You are oging to need to use subqueries to format the XML the way you want it.

The query would look something like:

SELECT Sales.SalesOrderHeader.salesorderid,

Sales.SalesOrderHeader.CustomerID,

Sales.SalesOrderHeader.OrderDate,

Sales.SalesOrderHeader.DueDate,

Sales.SalesOrderHeader.ShipDate,

Sales.SalesOrderHeader.Status,

(SELECT Sales.SalesOrderDetail.ProductID

from Sales.SalesOrderDetail

where...