I did try the code you posted and it's not returning the result set I'm looking for. If you take this set of data

RowNumber mftp_type ...

Thanks for the responses. I figured out the query about 10 minutes after I posted here. I was missing the IN and GROUP BY clauses. The final...

Wonderful! Of course the search I was doing "sql server er diagram" was not matching on any keywords. Now that I know it's called system views map, I'll...

Okay,

This morning I backed up the "bad" database and restored it on another server. My program ran just fine.

Then a backed up the "good" database that I restored from...

Okay, I got the solution I wanted. I wasn't filtering on the ASOFDATE to limit the return of the ENTRYDATE field. The query below now returns what I...

Here is the example I've been working with. I'm attempting to use a correlated subquery to get the information but it's returning the entry date of "5-14-2007 13:01:31" where...

Thanks everyone! I knew I would get some good solutions here.

Kyle

Thanks for your reply guys. While I agree to a certain extent that the ScheduleTime could be broken out in to another table (with proper ref. integrity), we're trying...