Ok so no that I have that, I am looking to do a case so that if the value can be converted to minutes, hours or leave as seconds. Not...

This is what I have done, then I take that and do a DATEDIFF on the 2 values to get the seconds.

CONVERT(varchar(8),CONVERT(datetime,case

...

I am subtracting Pending time 735510.30987 from Delivered time 735510.40448 and get call duration 0.09474, but I want to convert this to standard time.

CONVERT(nvarchar(20),@startdate) + ' and ' + CONVERT(nvarchar(20),@enddate)

DECLARE @startdate datetime

declare @enddate datetime

set @enddate = '10/1/2014'

SET @startdate = '10/11/2014'

select field1,field2,COUNT(FIELD3) from TABLE where date between @startdate and @enddate group by field1,field2

I actually saw another problem with the code

I replaced between with "AND" and put BETWEEN where it should go.

between' + CONVERT(nvarchar(20),@startdate) + ' and+ CONVERT(nvarchar(20),@enddate) + ')

Now I am getting this error (Incorrect syntax near '8'.) after I converted the parameters to nvarchar.

Thank you, I will review this and give it a go, I'll post my results of the use of this process. Thank you again.

I didn't think that little of data would be that big of problem, but creating a dynamic table name is what has me stumped, from what I read it's not...

Yes it would, be however the data within these table is a lot, some more than 17mb, my lead advises not to load all of this as it would cause...

Will this be the same with SSIS 2010?

Ok...This may be a strange question< but after the first initial load would I need to changed this SSIS package so it wouldn't reload all of these tables again. SO...

I have used this for files, but with table names I wouldn't know what or where to start, from what I have read says table names can't be dynamic.

Everything is the same.

Yes I did, and the example you provided did not help, but thanks for your attempt.