Glad it worked for you.

I looked in Itzik Ben-Gan's book on Window Functions to get more information about the difference between Row_Number, Rank and Dense_Rank

"When the ordering is unique, both...

;with cte as

(

select SALESMAN_ID, ORDER_NO, ORDER_TOTAL,

Row_Number() over (partition...

smitty-1088185 (11/22/2014)

---

How can I find the tables

below that failed and were never successful for the same day? Some tables may succeed or fail

more than once on the same...

JeeTee (11/11/2014)

---

How I've dealt with getting a set of unique identifiers ahead of time is to insert a dummy row into your iterating table (#RIN_Table in your example) and then...

JeeTee (11/11/2014)

---

Also, as a side note, even though this is a 2008 specific forum, if you have 2012 +, if all you need is the number and you don't care...

Jack Corbett (11/11/2014)

---

Is the RIN required to be sequential (No Gaps)? If not, this will work and eliminates the need for the temp table to generate the identity...

Anyone have an idea on this? :unsure:

Try this:

CASE WHEN T3.LineTotal IS NULL THEN T0.Rate * SUM(T0.LineTotal) - (T0.DiscPrcnt / 100) ELSE ((T0.Rate * SUM(T0.LineTotal)) - (T0.DiscPrcnt / 100)) + T3.LineTotal) END AS 'Total NATIVE'

It looks like...

I have never been a...

Luis Cazares (10/14/2014)

---

I'm not sure if a "WHEN NOT MATCHED BY SOURCE" would be what you need. It gives the expected result, but I'm not sure if it's the logic...

Anybody have a thought on this?:-)

sistemas_casinomnes (9/30/2014)

---

Hola, tengo el sgte inconveniente con una tabla de 9000 filas, la cual en teoria no es una tabla grande, cuando se realiza un SELECT de esta tabla demora...

Welsh Corgi (9/30/2014)

---

What would be the most straight forword to Calculate 90 days and 3 Years ago from an Effective Date in a table?

I need to return the effective date...

You could do this with a stored procedure, but if it were me, I would do the grunt work in the front end and just pass the completed query to...

Long standing bug in SSMS. Many posts about it on other forums. They say that by deleting SQLStudio.bin it will solve the issue. It does not.