Sergiy (12/22/2015)

---

If it's in production code - the developer who did it must be sacked.

If it's in a dynamic SQL -...

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Of course when scanning the whole table the difference may be rather minor. It's the prevention...

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Of course when scanning the whole table the difference may be rather minor. It's the prevention of seeks that...

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Of course when scanning the whole table the difference may be rather minor. It's the prevention of seeks that is always the...

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Of course when scanning the whole table the difference may be rather minor. It's the prevention of seeks that is always the major concern with...

ScottPletcher (12/22/2015)

---

Of course when scanning the whole table the difference may be rather minor. It's the prevention of seeks that is always the major concern with implicit column conversions....

Sarcasm noted.

USE [master]

RESTORE DATABASE [AdventureWorks2014Test] -- Restore to a Different name

FROM DISK = N'C:\SQLBackups\AW2014.bak' -- Using the backup of the "production" database

WITH FILE = 1,

...

I would if I had any firearms. There are two I would like to...

Silver Spoon really doesn't seem to care about learning anything. Just the answer, that's all he is interested in.

I really hope there is someone else there who knows more...

Everything you need (and more) is up there. Trying figuring out what you think you need...

Would help if you posted the DDL for the tables including indexes and uploaded the actual execution plans instead of just posting pictures.

Luckbox72 (12/21/2015)

---

For anyone else looking for the correct formula I found another post were someone was having the exact issue I was.

Follow this link for the corrected script

http://stackoverflow.com/questions/20972209/xirr-calc-in-sql

This works in...

What is the data type for this column: [Gen_ Prod_ Posting Group]

If it is integer, your problem is allowing the @GPPG variable to contain values other pure numeric values. ...

tinausa (12/15/2015)

---

Thanks, the categories are in a table, but not aranged as from and to values.

Also, number of categories may change from one product to another. Some have 3 and...

First, I'd write it as an inline table valued function, not a scalar function. Also, from what I can see it is rather simple. Does the below, even...