mm (8/19/2009)

---

You shouldn't be so gumpy Lynn... Remember back in the days when you were working on a problem and you just couldn't figure it out and your boss...

Hey, now I really like the avatar...

Don't you just love these? Of course when it starts, they don't bother to provide data that is represetative of the problem they are trying to solve.

You do realize we are volunteers with jobs of our own. We give of our time as we have time available. If this is a critical issue, seems...

Thanks Gail for jumping in on this one.

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...