Viewing 15 posts - 1 through 15 (of 29 total)
Yeah, I discovered this yesterday. I was running around frantically and my network admins were trying to find good copies in the nightly backups and suddenly! bam! there they were....
April 18, 2002 at 4:56 pm
Should I be looking at any third-party products to make this easier, or is everything I need built into SQL server?
March 18, 2002 at 11:20 am
You should probably post whatever your current solution is so we can look at it.
March 5, 2002 at 9:36 am
Extremely busy. =)
Steve, you've been helpful as always. Thanks again, everyone. I changed it to just dump everything into a temp table at the end and I get my values...
February 25, 2002 at 12:00 pm
I know this one is a doosy, but it's not run constantly. It's part of a paper-tracking product and this is a manager's report for the most part. The flexibility...
February 25, 2002 at 11:45 am
I'll post the code, but it's a little ugly at this point...
I think I may have to take your suggestion of sticking this in a temp table.
--new variables for date...
February 25, 2002 at 11:26 am
Well, the beauty of the business day lookup table is that it *never* has to change. Monday is always 3 business days (depending on how you want to count it)...
February 15, 2002 at 3:59 pm
Steve -
Thanks for your help. You got me on the right track, but my report is kind of a wierd one. I tried your method along with a brute...
February 15, 2002 at 2:50 pm
I had that idea, but I wasn't sure how to join it exactly, since I'm using a date range. Could I join it on the month?
something like this:
on datepart(month, @date1)...
February 14, 2002 at 10:54 am
Thanks!! That looks like it will do the trick. Any ideas for how I might be able to exclude holidays listed in a table?
February 13, 2002 at 4:29 pm
Ok, I kind of get it... but I'm still a little confused. What I'm doing in this case, is selecting how many of our records fall outside given service level...
February 13, 2002 at 12:46 pm
I used the -S flag for the BCP command to specify the servername. Once again, we only have one server and it worked just days ago, but that does appear...
January 4, 2002 at 10:46 am
A change log? Hahahaha... That's a good one.
Well, I figured it out. I had to add the -S flag and specify the server. Don't ask me why... it worked 3...
January 4, 2002 at 10:34 am
I was removed from the system administrator group. I figured this out a few minutes ago. I was able to fix the Agent problem from the server. People at my...
October 17, 2001 at 10:36 am
Viewing 15 posts - 1 through 15 (of 29 total)