DECLARE @dates VARCHAR(100)	
declare @jobid VARCHAR(max)	= 
								('101038,
								101039,
								101040,
								101044')

DECLARE @Tmp TABLE(JobIDs VARCHAR(40))
	
INSERT INTO @Tmp (JobIds)
		SELECT CAST(Items AS VARCHAR(40)) FROM InterfaceSystem.dbo.fn_SplitString(@jobid,',')


		


SELECT @dates = COALESCE	(@dates ,'')  + CONVERT(VARCHAR(100),i.itt_appointmentdateandtime, 103) +','
				FROM		LibertyGasGroup_MSCRM.dbo.FilteredITT_instruction I 
				WHERE		i.itt_jobcodeid in (select JobIDs from @Tmp) 
				AND 
							(i.itt_outcome = 2)
				GROUP BY	i.itt_appointmentdateandtime
				
select	distinct	i.itt_outcome
			, j.itt_id
			, substring(@dates, 1, charindex(',', @dates)-1) as date1
			, substring(@dates, 12, charindex(',', @dates)-1) as date2
			, substring(@dates, 23, charindex(',', @dates)-1) as date3
			, substring(@dates, 34, charindex(',', @dates)-1) as date4
from		LibertyGasGroup_MSCRM.dbo.FilteredITT_instruction i 
			inner join LibertyGasGroup_MSCRM.dbo.FilteredITT_job j on j.ITT_jobId = i.itt_jobcodeid
			
where (i.itt_outcome = 2)
		and i.itt_jobcodeid  in (select JobIDs from @Tmp)

DECLARE @dates VARCHAR(100)	
declare @jobid uniqueidentifier	= 
								('d63b6001-59fd-e111-94eb-001517a81d9d,
a149467b-b9f5-e111-94eb-001517a81d9d,
441ca81a-bdf5-e111-94eb-001517a81d9d,
d28923b2-bcf5-e111-94eb-001517a81d9d')

DECLARE @Tmp TABLE(JobIDs VARCHAR(40))
	
INSERT INTO @Tmp (JobIds)
		SELECT CAST(Items AS uniqueidentifier) FROM InterfaceSystem.dbo.fn_SplitString(@jobid,',')


		


SELECT @dates = COALESCE	(@dates ,'')  + CONVERT(VARCHAR(100),i.itt_appointmentdateandtime, 103) +','
				FROM		LibertyGasGroup_MSCRM.dbo.FilteredITT_instruction I 
				WHERE		i.itt_jobcodeid in (select JobIDs from @Tmp) 
				AND 
							(i.itt_outcome = 2)
				GROUP BY	i.itt_appointmentdateandtime
				
select	distinct	i.itt_outcome
			, j.itt_id
			, substring(@dates, 1, charindex(',', @dates)-1) as date1
			, substring(@dates, 12, charindex(',', @dates)-1) as date2
			, substring(@dates, 23, charindex(',', @dates)-1) as date3
			, substring(@dates, 34, charindex(',', @dates)-1) as date4
from		LibertyGasGroup_MSCRM.dbo.FilteredITT_instruction i 
			inner join LibertyGasGroup_MSCRM.dbo.FilteredITT_job j on j.ITT_jobId = i.itt_jobcodeid
			
where (i.itt_outcome = 2)
		and i.itt_jobcodeid  in (select JobIDs from @Tmp)

ALTER function [dbo].[fn_SplitString]
(
	@String nvarchar(MAX),
	@Delimiter char(1)
) Returns @Results Table (Items nvarchar(4000))
As
Begin
	Declare @Index int
	Declare @Slice nvarchar(4000)
	
	Select @Index = 1
	
	If @String Is NULL Return
	While @Index != 0
		Begin
			Select @Index = CharIndex(@Delimiter, @String)
			
			If (@Index != 0)
				Select @Slice = left(@String, @Index - 1)
			else
				Select @Slice = @String
				Insert into @Results(Items) Values (@Slice)
				Select @String = right(@String, Len(@String) - @Index)
			
			If Len(@String) = 0 break
		End
Return
End

INSERT INTO @Tmp (JobIds)
		SELECT CAST(Items AS VARCHAR(40)) FROM InterfaceSystem.dbo.fn_SplitString(@jobid,',')

and i.itt_jobcodeid  in (select JobIDs from @Tmp)