vchandm23:

What about using modulus (%)? Like some flavor of the following:

select replace(1234.4321 % 1 ,'0.','')

This is a hurried reply, no warranties implied...

Assumptions:

1. table name is dtTable

2. Time spans are in minutes

UPDATE dtTable

SET TimeSpan =

DATEDIFF(minute,t1.dt,(SELECT MIN(t2.dt)

FROM...

You could try updating from a table var, rather than the lengthy CASE statement:

-- CREATE TABLE VAR

DECLARE @Blood_Groups TABLE (Blood_Type varchar(3), Blood_Group varchar(8) )

-- Insert updatable values

INSERT INTO @Blood_Groups (Blood_Type,...

I've found this occurs when there are "extra" rows or columns at the end of a worksheet.  It could be that when you split the file into two you are...

I use a freeware utilitiy called DTSBackup2000, discussed somwhere on this site.  It is very simple to use and works well for moving multiple DTS packages.   I am not certain...