Viewing 15 posts - 841 through 855 (of 1,183 total)
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)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 19, 2007 at 8:34 pm
Your getting each individual record because you have activity_id in your select. Remove it and you'll get the totals.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 19, 2007 at 4:41 pm
Nanda,
I'm not clear on what you want to do? Can you provide expected results?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 19, 2007 at 5:57 am
:blush:
Well, we'll just let Steve say it was intended to be that way and take the credit for thinking ahead... LOL
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 18, 2007 at 6:15 pm
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 18, 2007 at 6:06 pm
Just like "Why get a Barkingdog fixed if he ain't broke" LOL
Man, that's just wrong on so many levels....:hehe:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 18, 2007 at 6:02 pm
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,...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 18, 2007 at 5:38 pm
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:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 18, 2007 at 5:28 pm
Aaron,
I agree. And ELEGANCE is in the eye of the beholder... :Whistling:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 18, 2007 at 5:22 pm
It's not necessarily eloquent, but it's new :hehe:
SELECT colA from TableA
EXCEPT
SELECT colB from TableB
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 18, 2007 at 4:47 pm
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 18, 2007 at 9:47 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 18, 2007 at 7:54 am
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.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 18, 2007 at 6:46 am
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')...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 18, 2007 at 6:27 am
Just curious, but if every entry is going to have the same value, why are you storing it at all?:hehe:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 17, 2007 at 11:39 am
Viewing 15 posts - 841 through 855 (of 1,183 total)