Jeff Moden (12/15/2010)

---

CEILING is the way people do it becaue...

It might be possible to perform the update using a single recursive CTE query, but I'm not sure that in this case it would be the most efficient method.

Here...

Well if you don't want to hang from the ceiling, you could do a handstand on the floor.

SELECT

-1000 * FLOOR(-TESTDATA.Number / 1000.0),

1000 *...

How do you identify top-level nodes, that is rows where the PrevID column does not reference any other parent row? Is the PrevID column NULL valued in this case, or...

Something like this maybe.

I've had to make a few assumptions, such as what exactly you mean by "within 1 minute", and I've also assumed that tables TableA and TableC do...

The () and [] brackets have a special meaning in regular expression syntax so if you need to match these characters you have to escape them by prefixing them with...

Think about what you don't want and then negate it.

WHERE NOT (

(

Status = 'Succeeded'

)

OR (

...

Try using DENSE_RANK() to derive your Order_Rank column value, something like this:

...

DENSE_RANK() OVER (

PARTITION BY ProductGroup

ORDER BY DateRequested DESC) AS Order_Rank

However, there may...

Here is an attempt at solving your problem using the Quirky Update method. You need to be aware of the rules associated with using this technique as described in Jeff...

I haven't had a chance to test this, but...

;WITH cteSEQ AS (

SELECT

[Date],

[Value],

...

If your account number column contains only numeric digits and can be reliably converted to an int (or bigint) type then you could obfuscate the data by converting the column...

Chris Morris-439714 (11/10/2010)

---

andrewd.smith (11/10/2010)

---

Either of these will work and stand a chance of using an index (if such an index exists) on the OrderDate column:

SELECT *

FROM dbo.ZNodeOrder NO

...

If you are concerned about optimizing query performance and/or keeping your working day queries simple, you could amend your calendar table to include an additional indexed column that increments by...

Either of these will work and stand a chance of using an index (if such an index exists) on the OrderDate column:

SELECT *

FROM dbo.ZNodeOrder NO

INNER...

Sachin's solution does rely on the added IDENTITY column to define the order of all the rows in the table, including those rows with a NULL ChangeDate. If there is...