Viewing 15 posts - 38,281 through 38,295 (of 39,720 total)
you can use datepart() with a parameter to find out which days are Sat and Sun. Hint: it returns a number. Exclude these by doing a datepart() in (weekdday numbers).
As...
February 13, 2002 at 12:34 pm
Haven't had an issue and I've run the tuning wizard a few times. It can be slow and uses some resources. Is it possible you are running out of resources?...
February 13, 2002 at 12:33 pm
February 13, 2002 at 12:30 pm
Not sure I understand, but I think a GROUP by will do this. Can you post a sample of 3 or 4 practitioners with a few dates for each?
Steve Jones
February 13, 2002 at 12:30 pm
Why not add a column to Admin.sbo.drivespace called "server". Change your insert to include the column list and exclude this column.
then after the insert, update drivespace to set "server" =...
February 13, 2002 at 11:27 am
February 13, 2002 at 11:24 am
As Andy said, it distinguishes you. Not a guarentee, but every bit helps. Sometimes that cert gets you past the HR people.
Steve Jones
February 13, 2002 at 11:23 am
You can run BCP without the -n or -c options and it will ask you questions about each column. At the end, it will offer to save a format file....
February 13, 2002 at 11:07 am
Easiest way I have seen is a cursor. But pls answer Andy's question. We may have a better solution.
Steve Jones
February 13, 2002 at 10:58 am
February 12, 2002 at 3:08 pm
Can you provide some more information?
If you are receiving the "call to sqlmaint.exe" failed, I get this on some things and haven't found a solution, other than to not...
February 12, 2002 at 2:17 pm
Nice article with good examples. Personally, though, I have a rule of thumb: NEVER use dynamic SQL. That being said, I have used it in places, but only when I...
February 12, 2002 at 12:31 pm
Nice article. I too tried this last year, but was a little ticked that I had to use a cursor to get this info. This should be queryable for all...
February 12, 2002 at 12:26 pm
February 12, 2002 at 12:00 pm
Rule of thumb:
February 12, 2002 at 10:55 am
Viewing 15 posts - 38,281 through 38,295 (of 39,720 total)