and ((b.string_value IS NULL) OR (b.string_value not in (select ExaminationID from lab.dbo.tbImgInfo where (ExaminationID IS NOT NULL))))

and not exists (select 1 from lab.dbo.tbImgInfo where (ExaminationID = b.string_value))

where (a.image_id>=11111)

where (a.image_id>=@image_id)

select top 30 a.image_id,a.patient_id,a.updated_date,a.updated_time,
lab.dbo.RmDateToDT(a.updated_date,a.updated_time) as upd_date,a.image_date,a.image_time,a.image_type,a.image_subtype,a.image_format,b.string_value,c.external_id 
from Romexis_db.dbo.RIM_Image_Info a(nolock) 
left join Romexis_db.dbo.RIM_Image_Attrib b(nolock) on (b.image_id = a.image_id) and (b.attrib_type=171) 
left join Romexis_db.dbo.RRM_Person c(nolock)  on (c.person_id = a.patient_id) 
where (a.image_id>=57400) 
and not exists (select 1 from lab.dbo.tbImgInfo(nolock) where (seq=a.image_id))
and not exists (select 1 from lab.dbo.tbImgInfo(nolock) where (ExaminationID = b.string_value))
order by a.image_id

  |--Compute Scalar(DEFINE:([Expr1014]=[lab].[dbo].[RmDateToDT]([Romexis_db].[dbo].[RIM_Image_Info].[updated_date] as [a].[updated_date],[Romexis_db].[dbo].[RIM_Image_Info].[updated_time] as [a].[updated_time])))
       |--Top(TOP EXPRESSION:((30)))
            |--Nested Loops(Left Outer Join, OUTER REFERENCES:([a].[patient_id]))
                 |--Nested Loops(Left Anti Semi Join, OUTER REFERENCES:([b].[string_value]))
                 |    |--Nested Loops(Left Outer Join, WHERE:([Romexis_db].[dbo].[RIM_Image_Attrib].[image_id] as [b].[image_id]=[Romexis_db].[dbo].[RIM_Image_Info].[image_id] as [a].[image_id]))
                 |    |    |--Nested Loops(Left Anti Semi Join, WHERE:([lab].[dbo].[tbImgInfo].[seq]=[Romexis_db].[dbo].[RIM_Image_Info].[image_id] as [a].[image_id]))
                 |    |    |    |--Clustered Index Seek(OBJECT:([Romexis_db].[dbo].[RIM_Image_Info].[PK_RIM_IMAGE_INFO] AS [a]), SEEK:([a].[image_id] >= (57400)) ORDERED FORWARD)
                 |    |    |    |--Clustered Index Seek(OBJECT:([lab].[dbo].[tbImgInfo].[PK_ImgInfo]), SEEK:([lab].[dbo].[tbImgInfo].[seq] >= (57400)) ORDERED FORWARD)
                 |    |    |--Clustered Index Scan(OBJECT:([Romexis_db].[dbo].[RIM_Image_Attrib].[PK_RIM_IMAGE_ATTRIB] AS [b]), WHERE:([Romexis_db].[dbo].[RIM_Image_Attrib].[attrib_type] as [b].[attrib_type]=(171) AND [Romexis_db].[dbo].[RIM_Image_Attrib].[image_id] as [b].[image_id]>=(57400)))
                 |    |--Top(TOP EXPRESSION:((1)))
                 |         |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1017], [Expr1018], [Expr1016]))
                 |              |--Compute Scalar(DEFINE:(([Expr1017],[Expr1018],[Expr1016])=GetRangeThroughConvert([Romexis_db].[dbo].[RIM_Image_Attrib].[string_value] as [b].[string_value],[Romexis_db].[dbo].[RIM_Image_Attrib].[string_value] as [b].[string_value],(62))))
                 |              |    |--Constant Scan
                 |              |--Index Seek(OBJECT:([lab].[dbo].[tbImgInfo].[ix_ExaminationID]), SEEK:([lab].[dbo].[tbImgInfo].[ExaminationID] > [Expr1017] AND [lab].[dbo].[tbImgInfo].[ExaminationID] < [Expr1018]),  WHERE:(CONVERT_IMPLICIT(nvarchar(128),[lab].[dbo].[tbImgInfo].[ExaminationID],0)=[Romexis_db].[dbo].[RIM_Image_Attrib].[string_value] as [b].[string_value]) ORDERED FORWARD)
                 |--Clustered Index Seek(OBJECT:([Romexis_db].[dbo].[RRM_Person].[PK_RRM_PERSON] AS [c]), SEEK:([c].[person_id]=[Romexis_db].[dbo].[RIM_Image_Info].[patient_id] as [a].[patient_id]) ORDERED FORWARD)

ALTER FUNCTION [dbo].[RmDateToDT] (@updated_date int,@updated_time int)
RETURNS datetime
AS
BEGIN	
	RETURN CONVERT(datetime,
						(right('0000'+ CAST((@updated_date / 10000) as varchar),4)+'-'+
						right('00'+ CAST((@updated_date / 100) as varchar),2)+'-'+
						right('00'+ CAST(@updated_date as varchar),2)+'T'+
						right('00'+ CAST((@updated_time / 10000000) as varchar),2)+':'+
						right('00'+ CAST((@updated_time / 100000) as varchar),2)+':'+
						right('00'+ CAST((@updated_time / 1000) as varchar),2)+'.000'),126);
END