Rob Millerd (12/13/2008)

---

Yes, I would like to see how you would do it in T-SQL. I am currently parsing this file...

Heh... I also keep a read-only CD handy for those places where they don't allow you to carry in or out any type of writable media. I've even had...

Man, I gotta agree with ya there. Forms it's...

Could be... you should be on at least SP2.

Heh.. see? You've got nothing to worry about, ol' friend... you know all the tricks. 😀

You bet... thank you for the feedback.

I'm not sure why your good script isn't working in 2k5 for neneco56 either... works fine for me.

Ok... I tried a couple of things out and even the use of non-breaking spaces is no guarantee either in the normal window or a code window...this really stinks especially...

Just one reason... formatting. I spend a bit of time making sure that the code is properly indented for high readability....

Damned smiley faces!!! Make sure that you change all the smiley faces in the code above with right parenthesis...

Since this is a "2005" forum, it would have been nice to know that...

As ironic as that sounds and this will also sound, I still think it's a bad idea... and, I prefer to not be a contractor... I prefer to be an...

Dang... I gotta get new glasses or stronger coffee. I mean really... I didn't even see the ops first post last night, only the short one I quoted in...

xsaycocie (12/12/2008)

---

Yep did that with a group by but the result is .01 off

The above return the following:

TT

---

3.05

7.64

2.55

25.45 and the compute total of 38.69

When I group by... the total is...

I'm acutely aware that there are a number of tricks to being a highly productive SQL Programmer, and I cringe at the thought that I only know a few of...