Ninja,

Is @todaymidnight the same as @sincedate? Since I've already declared that. Just to clarify.

This is how my SP originally looked:

SELECT DATEADD(dd,0,DATEDIFF(dd,0,GetDate()))

moncallAdd.FirstListing,

DATEADD(MINUTE, mOnCallAdd.StartOnCallTime,

DATEADD(DAY, mOnCallAdd.StartOnCallDate,...

Gila,

Ok so then how would be a better way to calculate that?

Thank you Gila and Ninja. I'll let you know if I have any more questions.

Ok so I was told just a moment ago that both hour and minute would need to be included in my SP. What's the syntax for that?

Sorry about that, I've edited my SP and it now looks like this:

SELECT

moncallAdd.FirstListing,

DATEADD(MINUTE, mOnCallAdd.StartOnCallTime,

...

Gila,

So then what would be a better approximation than that? Basically, what I'm looking to do is if it matches that date, then it'll display it.

Lulz,

What would you suggest I use than other than t-sql? I'm open to other ideas.

Perhaps this is a better question,

Since I don't know what data is going to be populated into this result, what's the best way that I can achieve the results I'm...

Ten,

Since I'm not using Dynamic here .. and this is part of an app, I'm not controlling what is being input into the query. (It will change every time)

This is...

Ok so I did a query based on the date 5/19/2005 with the schedname ZZOB02

and here is some of the sample data from that time

this if from the moncalladd...

Jack,

I'll get you more exact data.

2. Return the timestamp column both as an integer and converted to a date, with your data to check it. DATEADD(MINUTE, timestamp, '1899-12-31 00:00:00.000').

I...

the headers for both are the same but they are

ID Rec Id TimeStamp Schedname ...

Here's two lines of data from the moncalladd table:

17055055426893BITTAR&ESKEW03849010200YIUM 8400384901293TG 8199

27055155427287ZZOB02 ...

I've made further edits to this query and now I'm getting "No o/c listed" as a result when I know that there should be several listings for this time period....