Viewing 15 posts - 76 through 90 (of 122 total)
I have 36,465 records in my table and 21,776 will be removed. And this is a one time thing, that's for sure. I'm going to fix my insert...
October 7, 2011 at 2:12 pm
DISCLAIMER: Before I get too much egg on my face, let me say that a) I am cringing as I click "Post Reply" b) it's actually been so long...
July 26, 2011 at 4:16 pm
GSquared:
I checked the Addresses table and it covers United States and Canada so it is a large area. As far as accuracy, I have asked what the tolerance should...
June 2, 2011 at 3:10 pm
VERY helpful information Dixie Flatline. Are you suggesting using geometry instead of geography, or ditching both, period? Understanding testing is definitely needed. We are just expecting that...
June 2, 2011 at 2:26 pm
Thank you for your reply. I've just started testing how to work with our data, simply to get the concepts down. I think I've definitely settled on storing...
June 2, 2011 at 1:48 pm
mister.magoo (12/6/2010)
Another "ugly" method...just for the sake of it...
select *,CASE WHEN 32*Work0110+16*Work0210+8*Work0310+4*Work0410+2*Work0510+Work0610 NOT IN (0,1,2,3,4,6,7,8,12,14,15,24,28,30,31,32,48,56,60,62,63) THEN 'Y' ELSE 'N' END
from #Employee
Ewww.... yeah, I'll agree with you on this one....
December 6, 2010 at 4:32 pm
Oh man! That's MUCH cleaner than where I was going! I was capturing the min and max rows (using row_number()) where hours were entered. Then capturing rows...
December 6, 2010 at 4:13 pm
Thank you very much for the reply Andrew. Turns out we had a consult session with Microsoft last week here are some items from my notes:
- EF may not...
September 29, 2010 at 5:11 pm
Very good point: "So I would be looking for clarification of the requirements, and making it clear that there is a performance issue, if they want to search the...
August 31, 2010 at 2:55 pm
roger.plowman (8/31/2010)
August 31, 2010 at 1:15 pm
I have to join in as well. This community is priceless. This is the first place I look when I need to find a solution to a problem....
August 30, 2010 at 9:06 am
Bravo! I love (and learn best from) step by step instructional articles like this. I've created some SSRS reports but it is not something I do often so...
August 26, 2010 at 9:32 am
I have had to send many a batch emails for my company and as a .NET developer, I send via .NET. As someone else susggested, I record the date...
May 27, 2010 at 12:18 pm
talltop-969015 (1/20/2010)
LSAdvantage (1/20/2010)
January 20, 2010 at 9:21 am
Viewing 15 posts - 76 through 90 (of 122 total)