Gail, (or someone else fairly familiar with profiler), here is one that could possibly use a little more detailed assistance.

If you have a test system (other than you desktop preferably) you should be able to use Profiler to trace the execution of both procedures and use that to provide...

What changes to the code have you tried to make it work for multiple items? That is what I want to see. Where are you having problems. ...

I'd use the decimal data type. Check it out in BOL.

How about you give it a try first. Show...

Lowell (8/19/2009)

---

After Dave inferred that it was the # seconds since 01/01/1970, it was pretty easy...but how the heck did he figure out the starting date?

Dave had you tripped...

Can't find it now, but I read a post earlier this morning where the OP thought he couldn't use an ORDER BY in a query because he was using a...

Silverfox (8/18/2009)

---

stephen.lappe (6/3/2009)

---

The organization I work for tells me that I am the Senior Production SS DBA. I fell like a junior one though.

Sys Admins, with management approval, decide...

I think you said it, contact Microsoft or the vendor of the software you are evaluating.

If you double click on the error message SSMS will sometimes take you straight to the problem. It works in this case. Look at the sixth CASE statement...

RBarryYoung (8/18/2009)

---

Lynn Pettis (8/18/2009)

---

RBarryYoung (8/18/2009)

---

Grrr. Another person who seems to think that I should be doing their work for them. ... :angry: My back really hurts right now...

RBarryYoung (8/18/2009)

---

Grrr. Another person who seems to think that I should be doing their work for them. ... :angry: My back really hurts right now and I fear...

What is needed is the DDL for the tables (or a least enough of it to work on the query), sample data for the tables (fake data is fine as...

Not sure, but this is looking more like FIFO Inventory problem than an Aging problem.

From looking at the sample data in the spreadsheet, you are deduction the (-n) from the...

harry.sh16 (8/17/2009)

---

My Destination column data type cannot be changed it has to remain numeric but i can make it to numeric(2,0) or numeric (3,0) depending on the source which has...