Not objecting to Jeff's comment, and I was off on reading the columns so I meant to say the "committed_fund_item_id" column but ...

Bill Maners (10/19/2007)

---

The activity_id is the same for...

Your getting each individual record because you have activity_id in your select. Remove it and you'll get the totals.

Nanda,

I'm not clear on what you want to do? Can you provide expected results?

:blush:

Well, we'll just let Steve say it was intended to be that way and take the credit for thinking ahead... LOL

Actually Steve, I think I've found a use for this "bug".

I can set up a rule in outlook to move the "NEW POSTS" into a folder different than the "NEW...

Just like "Why get a Barkingdog fixed if he ain't broke" LOL

Man, that's just wrong on so many levels....:hehe:

Aaron,

I agree. I haven't come across a situation where either preform better. I guess it's a lot like Common table Expressions, in that they are function identical as temp tables,...

There a a few usefull new keywords in '05

EXCEPT, INTERSECT, and ROW_NUMBER just to name a few...

Wag that tail all you want, just don't go poo on the carpet! :hehe:

Aaron,

I agree. And ELEGANCE is in the eye of the beholder... :Whistling:

It's not necessarily eloquent, but it's new :hehe:

SELECT colA from TableA

EXCEPT

SELECT colB from TableB

OK, I spent WAY to much time on this. Primarily because I was stubborn and tried to find a way to do this in one statement. In the end I...

I'm not a 100% on this, but I believe the BETWEEN function does it's comparisons at the binary level. At least that's my best guess.

thus......(extra zeros removed)

MSD154001_________converted to binary would...

That's what the DATENAME function does. It converts the date you supply with the actual DATE NAME. just replace the dates in the above query with your parameters.

This is from and article by Jeff Moden, and is pretty nifty!

http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/

SELECT

(DATEDIFF(dd, '9/1/2007', '9/8/2007') + 1)

-(DATEDIFF(wk, '9/1/2007', '9/8/2007') * 2)

-(CASE WHEN DATENAME(dw, '9/1/2007')...

Just curious, but if every entry is going to have the same value, why are you storing it at all?:hehe: