Viewing 15 posts - 38,311 through 38,325 (of 39,754 total)
So are you looking for, say between 12/31/01 and 1/15/02, the following data:
PT001 3
OT002 1
What I am asking is what results go with this source data.
Steve Jones
February 13, 2002 at 1:19 pm
Not sure what you mean. Can you clarify a little more with some data examples.
Steve Jones
February 13, 2002 at 1:16 pm
My bad, I misunderstood. Try this:
create table MyTable
( myid int
, my1 datetime
, My2 datetime
)
go
insert MyTable select 1, '01/09/02', '01/14/02'
insert MyTable select 1, '01/10/02', '01/23/02'
insert MyTable select 1, '01/11/02', '01/22/02'
insert MyTable...
February 13, 2002 at 1:15 pm
Interesting article. I'd like to see more information about how you came to these conclusions, but it is a good explanation of your tests and results.
Steve Jones
February 13, 2002 at 12:38 pm
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
Viewing 15 posts - 38,311 through 38,325 (of 39,754 total)