Viewing 15 posts - 38,446 through 38,460 (of 39,901 total)
You are welcome. Don't really know of a way to run a stored proc asynchronously. I think it won't return intermediate result sets.
HAve to test it though?
Steve Jones
February 14, 2002 at 2:17 pm
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
Viewing 15 posts - 38,446 through 38,460 (of 39,901 total)