Depending on how you wish to calculate ie;Hours, Minutes or seconds. The following query should get you on the right track!

DECLARE @StartDate DATETIME, @EndDate DATETIME

SELECT DATEDIFF(mi, @StartDate, @EndDate) AS 'Time...

One way to do this is to BULK INSERT from the csv into a temporary table, then from the temporary table insert into the real table using your programmatic logic...

You need to implement Merge Replication. Have a look in BOL and make sure you test frist in a test environment as Merge Replication is not for the faint hearted!

Do yourself a favor and convince your manager that Sybase sucks a big fat one! Also tell him that Microsoft SQL Server has gone leaps and bounds and that they...

mharr,

I'm using MSDE on my desktop. I 'm trying to emulate a remote server by specifying the local hard drive as oppossed to specifying a device that knows where it...

Your problem is indeed with Replication! When an insert takes place on a Table that is replicated that also has a trigger defined on it, 2 transactions will take place!

What...

I agreewith Frank kalis. A single Database approach is the place to start.

I don't know why you are even contemplating multiple Database at this stage! The fist stage is to...

You can't ALTER a Text Column!

You will haveto create a new Column of DataType NText and copy the data in that new Column.

So if it takes 3 minutes to Update 1000000 Records, then it would take 69 Minutes to Update 23000000 records if you were to do it 1000000 records at a...

I apologise!

What is the Primary Key for the table?

The best way to do this is to use a BETWEEN Clause. For example we will use say WHERE PK BETWEEN 1...

How on earth can this be done with CHARINDEX?

CHARINDEX will only Return the starting position of the specified expression in a character string, which will be a number!

FORGET about the loop!

Just do it the way I showed you!

I'm assuming jeffwe is talking about using the BCP Process I have mentioned in a DTS Package!

Try this. Do this at every 1000 records!

SET ROWCOUNT 1000

update sde.conman.navtechQ4_2003 set

    stfips = t1.stfips

    from sde.conman.navtechq4_2003 t

    inner join sde.conman.navtech t1 on (t1.link_id = t.link_id)

You can use BCP to export all Data from all Tables to flat files. As for the Objects, just script them!