Viewing 15 posts - 8,956 through 8,970 (of 9,720 total)
Wow, this is quite a thread.
Check the references section on the question and you'll see where I got the idea for it. I suppose I should have checked up...
February 14, 2008 at 5:43 am
Wow, guys, you've been a big help.
I have another table in which I keep triangulated totals (not the same as a triangular join). I have to basically add the...
February 14, 2008 at 5:13 am
David, I hate to break the news, but there are no drugs for what people like you & I have.
But they are working on a vacine to prevent future...
February 14, 2008 at 4:14 am
yes, not only save those sql scripts but take them to the next job
But check any confidentially agreements you might have signed on the previous job before you do...
February 14, 2008 at 4:12 am
You make a decent point, Andrew. And Admin accounts should always be heavily audited. We have S.A.M. on our servers which actually makes us enter reasons we logged...
February 14, 2008 at 3:59 am
Thanks, Matt. I appreciate the clarification.
Looks interesting. I'm going to have to test this one and see if it does any better or quicker than what I eventually...
February 14, 2008 at 3:49 am
DOH! Found my error. I had t2.CalMonth - 1 and should have had t2.CalMonth + 1.
I feel sooooo stupid.
Thanks, guys. I appreciate it. As far as...
February 13, 2008 at 12:37 pm
Okay, this doesn't appear to be a CTE problem so much as it is a confusing addition problem.
ARGH.
I've changed this to a WHILE loop only and it's still giving me...
February 13, 2008 at 12:19 pm
Oh, that's a horrible thought!
I want to be able to see these jobs and know what each one does without opening them up and finding the report ID info. ...
February 13, 2008 at 9:37 am
I used to think that too, but actually no. The FROM clause is the one place where the UDF doesn't execute once per row.
Remember that a UDF...
February 13, 2008 at 4:04 am
Sounds like you need to incorporate your reports in a Dashboard tool.
I know Crystal Excelsius does something similar to what you're talking about, but it usually uses Crystal reports instead...
February 12, 2008 at 4:02 am
Andrew said:
I think thats great if you have the time, however as most have better things to do just identify what it is you need and leave it up to...
February 12, 2008 at 3:58 am
The other suggestion will not give you a vertical split. It will give you a horizontal split. There is no way, that I am aware of, of doing...
February 11, 2008 at 8:16 am
The big thing, IMHO, is whether or not your job duties require that kind of access to the server.
Where I work, the DBA team is responsible for the "soft" server...
February 11, 2008 at 8:12 am
Besides - four weeks is the fastest they can grow your pod in....
DUDE! Who told? We had to sign a conference call NDA regarding that information....
February 8, 2008 at 4:02 am
Viewing 15 posts - 8,956 through 8,970 (of 9,720 total)