Viewing 15 posts - 38,716 through 38,730 (of 39,466 total)
Haven't seen this. Is this a single dynamic properties task and a single bulk load?
I'll check it out tomorrow or Mon.
Steve Jones
December 8, 2001 at 3:07 pm
You can do anything as long as teh driver allows it. As far as I know, you can move this data using DTS, just not sure if there are any...
December 8, 2001 at 1:59 pm
you probably want to do a subquery
select colour, ..
from MyView
where modified = ( select max( modified) from MyTable)
Steve Jones
December 8, 2001 at 1:57 pm
Why can't you delete the existing one? I have a series on version control going on now that covers some of these items.
Steve Jones
December 8, 2001 at 1:55 pm
December 8, 2001 at 1:53 pm
Agreed. If you want to go to SQL Server we can help. If you are moving to Oracle, I suggest you check out their site.
Steve Jones
December 7, 2001 at 3:41 pm
December 7, 2001 at 3:34 pm
That's quite a topic. Usually most companies will have some sort of docucment style for technical tdocs. Start there.
Then work one section at a time. Perhaps, "installation of SQL Server"...
December 7, 2001 at 11:02 am
Not that clear. Can you post a sample data?
Are you looking for the most recent inserted record or the greatest value for itColourID?
Steve Jones
December 7, 2001 at 11:01 am
I'd get some help on this one and get access to the server (even if its with an admin) to do some debugging. David has the right idea.
Steve Jones
December 7, 2001 at 10:59 am
Good luck. I'd be interested in hearing how this turns out and what the reactions are.
Steve Jones
December 7, 2001 at 10:57 am
You can designate any stored procedure to run at server startup. In sql 2000, you set the server to run these with:
sp_configure 'scan for startup procs', 1
Set the procedures with
sp_procoption
Sets...
December 7, 2001 at 10:56 am
Good idea. Also, if you can give the names of the columns and table that are not working, we will try to test it.
Steve Jones
December 7, 2001 at 10:53 am
December 6, 2001 at 8:19 pm
December 6, 2001 at 8:16 pm
Viewing 15 posts - 38,716 through 38,730 (of 39,466 total)