Viewing 15 posts - 38,041 through 38,055 (of 39,490 total)
on sql server 2000, the sp_change_users_login will help fix user and logins.
Steve Jones
February 14, 2002 at 12:18 pm
you need to include day and year, or convert to characters and strip off the times.
Steve Jones
February 14, 2002 at 11:26 am
February 14, 2002 at 11:25 am
The zeros would be a problem unless you store a 0 value for each date. I see why you want a table of all days.
For the basic data, couldn't you...
February 14, 2002 at 11:07 am
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
Viewing 15 posts - 38,041 through 38,055 (of 39,490 total)