[font="Comic Sans MS"]FLOAT cannot be counted on for exact math. Save yourself grief and avoid FLOAT like the plague. The decimal number 0.1 cannot be exactly encoded as a binary...

Wunderbar !

This instance is one of the single most valuable benefit of browsing through the SSC forum questions, out of sheer interest in learning more, not just because a topic...

Probably a dumb question, you are doing the work on CTE2 so ... HOW is the original SourceData table updated (I ran it and sure enough table SourceData appears to...

[font="Comic Sans MS"]Ah but that was a MIXTURE, not pure water. Even CO₂ dissolved in water is a mixture.

And for an amazing development, check out NITINOL - a shape memory...

Jeff Moden

Beer has some interesting freezing qualities... take it down to somewhere between 26 and 28^oF and it's still liquid. Give it a little bit of a sharp...

My basic question on all this is: yes, but WHY does one need it ?

Maybe building up an additional field such as a running subtotal ? For a report ?

My...

Tony Palmeri (6/5/2015)

---

It occurs to me that the best way to *understand* what is actually happening with your sorts, is to simply include each of your sort-expressions, verbatim, in your...

[font="Comic Sans MS"]While this does not answer your question, I suggest you use from now on (does not invalidate what you have done, just easier) the following to ease your...

[font="Comic Sans MS"]Though I could add a bit more info on how to use the CASE statement.

Note: the purpose of the following approach was to enable a user to dynamically...

[font="Comic Sans MS"]This also does not help with the added complexity of wanting it sorted up or down![/font]

Jeff Moden (6/4/2015)

---

]

BWAAA-HAAAAA!!!!! If that were true, there would be no use for forums at all because everything that...

[font="Comic Sans MS"]Thanks.[/font]

To: sgmunson and Luis Cazares

Thank you both for your suggestions, both are viable alternatives. (I was really looking for an "Aha ! moment" about these new T-SQL functions to replace...

Eric M Russell (6/4/2015)

---

The solution to this problem depends on why (or if) the rowset displayed to users really needs to contain a list of sequential numbers. Attempting to maintain...

[font="Comic Sans MS"]The topic of Running Totals has been covered in excrutiating details on numerous occasions in this forum.

The most recent I can suggest (I started it last week) is...