|
|
Posted by Skip on 08/23/06 00:50
Hello,
I am reposting this from another group, because I had no responses.
I need to get the max row date from the following query. There is a
date field in rcompl.date_time. There can be several rows identical
except the date_time in which I need only the max of those rows. Thanks
select rcompl.*,fastener_database.dbo.fastener_db_working.*
FROM Rcompl LEFT OUTER JOIN fastener_database.dbo.fastener_db_working
ON
substring(Rcompl.hole_name,1,len(Rcompl.hole_name)-2) =
fastener_db_working.[Serial Number]
where len(hole_name)>2 and status<>'5' and program_id in (select
program_id from nc_programs where job_id =@job_id)
Navigation:
[Reply to this message]
|