Viewing 15 posts - 511 through 525 (of 575 total)
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...
March 1, 2004 at 6:07 pm
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...
February 26, 2004 at 6:28 pm
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!
February 26, 2004 at 6:07 pm
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...
February 26, 2004 at 6:05 pm
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...
February 25, 2004 at 7:30 pm
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...
February 25, 2004 at 6:57 pm
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...
February 23, 2004 at 9:39 pm
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.
February 23, 2004 at 9:11 pm
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...
February 22, 2004 at 10:14 pm
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...
February 22, 2004 at 9:33 pm
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!
February 22, 2004 at 9:21 pm
FORGET about the loop!
Just do it the way I showed you!
February 22, 2004 at 8:56 pm
I'm assuming jeffwe is talking about using the BCP Process I have mentioned in a DTS Package!
February 22, 2004 at 7:02 pm
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)
February 22, 2004 at 6:37 pm
You can use BCP to export all Data from all Tables to flat files. As for the Objects, just script them!
February 19, 2004 at 11:30 pm
Viewing 15 posts - 511 through 525 (of 575 total)