CELKO, Sorry the method in which I supplied the data didn't meet your high standards. I will tell you what I think there...

Seth,

You are awesome. Work like a charm. Any chance of giving a breif explanation of what it is doing. I am not familiar with the ";with C1...

Mike01,

Thank for the reply. I am not sure what BOL is but your reply gave me something to do a google search on and I found the answer.

The max...

Lowell and ksullivan,

Thanks to you both. Works great! ksullivan thanks for showing both options.

Lowell,

Thanks for the quick response. I have tried:

DATEDIFF(n,dbo.Assgn_Patient_List.Start_DTime, dbo.Assgn_Patient_List.End_DTime)*1.0 /

DateDiff(n,dbo.Assgn_Shift_Summary.Start_DTime,dbo.Assgn_Shift_Summary.End_DTime) AS PercentofTimeOnShift

DATEDIFF(n,dbo.Assgn_Patient_List.Start_DTime, dbo.Assgn_Patient_List.End_DTime) /

DateDiff(n,dbo.Assgn_Shift_Summary.Start_DTime,dbo.Assgn_Shift_Summary.End_DTime)*1.0 AS PercentofTimeOnShift

but I end up with the same result of zero. Did...

That does work. I can live without the newline and just separate each criteria with a semi-colon.

The script run fine on my test server which is 2005 but I...

Bob and Flo,

I finally found time to run this against our test system and it works like a perfect.

THANKS!!!

Well...this looks like the solution. I will try to run this against my test database tomorrow. I will take some time for verification of the data. I...

Bob and Flo,

I have tried to run your solutions but I am getting errors as listed below. I am wondering if it is because we run SQL2000, which I...

Bob and Florian,

Thanks for the super quick response I really appreciate it. I had read the information at the link you provided Bob but obviously didn't comprehend it. ...