Viewing 15 posts - 38,011 through 38,025 (of 39,456 total)
Holidays have alsways caused me an issue. Mainly because each country and sometimes each company has different ones. The way I've handled it in the past is to make a...
February 14, 2002 at 10:49 am
February 14, 2002 at 10:33 am
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
Viewing 15 posts - 38,011 through 38,025 (of 39,456 total)