Now, I want to store the results of this query in a variable in SSIS.

But I am getting the results as: 16:52:45

I do not understand the datatype that I can...

Thank you Lynn.

I got one more help which mentioned:

SELECT

MIN(starttime) as Minimum,

MAX(endtime) as Maximum,

CONVERT

(varchar,(MIN(starttime) - MAX(endtime)),108) as Diff

FROM

dbo.TableName

WHERE

startime

BETWEEN

'2009-04-13 00:00:00.000'

AND

'2009-04-13 08:30:00.000'

This is also working fine.

Yes. I want it in HH:MM:SS format, because most of the times I will be having less than 24 hours, except for some cases. So, thats fine with me.

Thank you for your prompt reply.

I have around 22 columns in my flat file and there are two datefields, for which I have used DB_Date.

All others are char and one...

Yes. When I run the following query:

SELECT DISTINCT

DATEADD (dd,0, DATEDIFF(dd,0,...

When I am using SSIS, I am getting the results as following:

04/02/2009 12:00:00 AM

04/01/2009 12:00:00 AM

03/31/2009 12:00:00 AM

03/30/2009 12:00:00 AM

03/29/2009 12:00:00 AM

03/28/2009 12:00:00 AM

03/27/2009 12:00:00 AM

And when I am using...

Worked perfect, Thank you so much!

That worked perfect. But still one question.

Can you please tell me is it possible for me to get the StartDate from Table1 and insert the UpdatedStartDate as EndDate in Table1...

I agree with you, but the simple UPDATE statement is not working here.

UPDATE dbo.Table1

SET StartDate = '08:30:00.000'

WHERE StartDate = '00:00:00.000';

This will not work as I have not mentioned dates at...

It is a table where I have this column as StartDate and I want to populate another table EndDate with the new values, I mean Date 00:00:00.000 to Date 08:30:00.000

I figured out my mistake. I was putting a wrong logic and so I was not getting the desired output.

I will now work on it.

Once again, thank you for your...

My criteria matches to the first one that you have mentioned.

LTRIM([FirstName]) == ""

I want to get all the records...

I got it. It is the ID number only I guess, but still I do not see the data subtracting one row from the other. I am now making sure,...

Lynn Pettis (3/26/2009)

---

Changing methods a bit here, so here is some test code for you to play around with:

create table #TestTab2 (

Dept char(2),

...

Thank you for all your efforts. Next time I shall post my questions in a well organized manner, so that it becomes easier for the one who helps me by...