/****** Script for SelectTopNRows command from SSMS ******/ SELECT [LN] ,[HN] ,[FULLNAME] , [YEAR] ,[SEX] ,[BIRTHDATE] ,[WARD NAME] ,[PATIENT TYPE NAME] ,[DOCTOR NAME] ,[AN] ,[VN] ,[ORDER DATETIME] ,[IREQ_LAST_CHK_DT] as 'Checkin datetime' ,[RES ITEM NAME] ,[RES ITEM RESULT] ,[RES ITEM REPORT DATETIME] ,[RES ITEM REPORT STAFF NAME] ,[RES ITEM APPROVE DATETIME] ,[RES ITEM APPROVE STAFF NAME] -- ,[IREQ_LAST_APP_DT] FROM [LAB_DB].[dbo].[view_lab_statistic_Result_List] where [RES ITEM STATE] = 'A' and HN in (SELECT distinct HN FROM [LAB_DB].[dbo].[view_lab_statistic_Result_List] where [RES ITEM CODE] in ('IM1429','IM1430','IM1433','IM1448') and ([IREQ_LAST_CHK_DT] Between '@dt1' and '@dt2')) and [RES ITEM CODE] in ('IM1429','IM1430','IM1433','IM1448')
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter