Why is this a requirement?

I suggest that you read up on the new hierarchyID datatype in 2008. You can start here.

# 1. In your example, the optimizer uses the nonclustered index because it is a "covering" index containing all the columns needed to satisfy your query. ...

In the future, you can answer questions like this one for yourself by displaying the actual execution plans when you run the two queries. You should see...

Just a suggestion, but rather than create the formula, let your users define the marginvalues and the accompanying pay percentages. Store them in a table just like you...

Quick war story: Someone once asked me to look at a cursor-based query they wrote to split a single large table into three separate tables. ...

Instead of using EXEC, take a look at books online here for examples of using sp_executeSQL to do a "parameterized" dynamic SQL query, passing variables from the calling procedure into...

Pay close attention to the dangers of SQL injection attacks. Done carelessly, your query can create a huge security risk to the DB.

I don't see what you're showing as being any simpler than what a cursor looks like in T-SQL. The question is, what exactly are you trying to...

He's right. I would say this is one of those jobs better handled outside SQL.

Way to go, Gianluca !

Have a great vacation, Roy. Surely, it must be well-deserved.

Redgate has a very nice little utility called SQLSearch.

It's very handy for finding strings (like table names) within all objects in a db (or all dbs on...

Has anyone seen the Green Lantern movie yet?

While your desire not to have to make identical changes in 100 places is commendable, there isn't any sort of a "column loop" in T-SQL. You...

Jayanth_Kurup (6/23/2011)

---

Having been there I would say there is no such thing as a silly question. While I try not to give the full answer if i feel the person...