Hi
In below Sql i want in inner select statement if record is not found then Space should be returned.
select [LogID] ,[ModuleCode] ,[ModuleMasterCode] ,[EntryCode] ,[EmpCID] ,[EmpName] ,[StepCode] ,[EntryDate] ,isnull((select top 1 EntryDate from [PRQS].[dbo].[BackLog] where and StepCode = T0.StepCode and EntryCode = T0.EntryCode),'') FROM [LiveData].[dbo].[EntryLog] T0 where T0.EntryCode = '100'
Thanks