Viewing 15 posts - 20,026 through 20,040 (of 22,202 total)
I'm doing about 35 miles each way here in the US. The trick I've found that works is to come in early and leave early. Avoid the common commute times....
July 7, 2008 at 6:43 am
It really sounds like you're trying to generate reports.
I'd suggest one of two options, first, use a reporting tool, like the Reporting Services tool that comes with SQL Server or...
July 7, 2008 at 6:36 am
Personally, I'd go with option 2. That way, you don't have to worry about spelling and, when another state, "suspended" or something, comes along, you're ready and won't have to...
July 7, 2008 at 6:26 am
We get these debates where I work a lot. For some reason, many of my fellow DBA's believe that every known bug has to be addressed prior to release or...
July 7, 2008 at 6:13 am
May as well pile on to this one...
It's not a problem. Half the time when I type up the question to post it up here when I'm stuck, the act...
July 7, 2008 at 5:27 am
Not to mention, is there more than one access path? Can people modify the values after they've been entered? If so, are there triggers in place to account for that...
July 3, 2008 at 12:12 pm
Then that doesn't sound like a structural problem. It must be one of logic.
There's no way for innacurate numbers to be entered or values to be changed over time?
July 3, 2008 at 9:42 am
How far is it off? Hundreds & thousands or only a few dollars or cents? If it's the smaller number, it could be rounding errors. You didn't specify the data...
July 3, 2008 at 9:12 am
There isn't a replacement. From the BOL:
ALL
This option is deprecated and maintained only for backward compatibility. It does not grant all possible permissions. Granting ALL is equivalent to granting the...
July 3, 2008 at 9:05 am
It does parse, but try generating an estimated execution plan. It fails immediately. Parse and compile aren't the same.
July 3, 2008 at 7:56 am
I've done this two different ways.
First was to add an effective date column and then always sort by effective date to get the latest effective value.
Better was to create...
July 3, 2008 at 7:47 am
Viewing 15 posts - 20,026 through 20,040 (of 22,202 total)