Viewing 15 posts - 38,266 through 38,280 (of 39,720 total)
Personally I be scared to see stored procedures or any SQL object in VB, C, etc. Those guys are funamenatally row or object oriented. SQL and RDBMSs are set oriented....
February 14, 2002 at 2:15 pm
February 14, 2002 at 2:11 pm
Can't be imported. If you want to move as flat files, save as structured storage file.
Steve Jones
February 14, 2002 at 2:07 pm
Not really. You could insert a value into some other table and query this periodically.
Steve Jones
February 14, 2002 at 2:06 pm
I work at a starup( 35 people, 8 in IT) and all developers have Domain admin rights, including me. Not that I agree with this, but havn't been able to...
February 14, 2002 at 12:21 pm
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
Viewing 15 posts - 38,266 through 38,280 (of 39,720 total)