Viewing 15 posts - 11,356 through 11,370 (of 14,953 total)
The most frequent what? Stored proc?
I use server traces to get that kind of data.
January 23, 2009 at 1:29 pm
Sure it can be done in a query. Or a proc. Either one. Here's one way:
;with Breakdown as
(select division,
case
when score between 0 and 1000 then 1
else...
January 23, 2009 at 1:28 pm
Making it so IMEX doesn't require a registry edit to really use (scanning the first 8 rows is just stupid)
Age calculation (as others mentioned)
I like the idea of a Users...
January 23, 2009 at 1:23 pm
Standards are a good thing. Just keep in mind, they do change over time, and something that is 100% compliant today may be 0% compliant tomorrow.
Take a look at...
January 23, 2009 at 12:43 pm
The code (the loop) runs. It just takes a lot longer than other solutions, at least on the machines I tested it on.
January 23, 2009 at 12:35 pm
timothyawiseman (1/23/2009)
Jeff Moden (1/22/2009)
So! Anybody wanna talk about all the companies that use spreadsheets like databases? I'll start... I hate them all. 😛
I cannot possibly agree more....
January 23, 2009 at 12:33 pm
It's because it's going to have to get 12,003 rows out of 21,681. At that point, it's easier to do a scan and join to it than to do...
January 23, 2009 at 12:19 pm
Yes, this can be done with SSIS.
Declare a variable, set up a For...Each...Next loop that goes through the files in the folder, and assign the file name to the variable....
January 23, 2009 at 11:30 am
I must be missing something on DavidB's solution, because I copy-and-pasted it into Management Studio, and killed it when it hit the 1-minute mark, at which point it had printed...
January 23, 2009 at 11:28 am
I think you need to take a look at your code, Chris. It has the same test twice on the last part of the Case statement, and it will...
January 23, 2009 at 11:01 am
Beaurocracy was invented to massively increase the efficency of stopping people from getting things done.
January 23, 2009 at 10:58 am
DTS might be able to do something like that.
But I have to ask, why Access databases? Why not give the sales managers some sort of access to the SQL...
January 23, 2009 at 10:56 am
Did you not read what I posted?
There's no reason to get rude or pushy on this.
January 23, 2009 at 9:42 am
The reason to do a check on @@Rowcount in this case, as opposed to just checking for errors, is that a failed insert isn't necessarily an error.
If it doesn't insert...
January 23, 2009 at 9:41 am
Grant Fritchey (1/23/2009)
GSquared (1/22/2009)
January 23, 2009 at 9:35 am
Viewing 15 posts - 11,356 through 11,370 (of 14,953 total)