SELECT 
	HOLEID, case row_number() over(partition by Drillingdetail.holeid order by drillingdate) when 1 then DRILLINGDETAIL.HOLEID end as x_holeid,
	DRILLINGDATe ,
	max(   case
				   when [DRILLINGDETAIL].[NAME] = 'EventFrom' and [Shift]='day' then
					   [DRILLINGDETAIL].[VALUE]
				   else
					   '-'
			   end)EventFromDAY 
			   ,max(   case
				   when [DRILLINGDETAIL].[NAME] = 'Eventto'  and [Shift]='day'then
					   [DRILLINGDETAIL].[VALUE]
				   else
					   '-'
			   end)EventTODAY
			 ,
			 max(   case
				   when [DRILLINGDETAIL].[NAME] = 'EventFrom' and [Shift]='night' then
					   [DRILLINGDETAIL].[VALUE]
				   else
					   '-'
			   end)EventFromnight
			   ,max(   case
				   when [DRILLINGDETAIL].[NAME] = 'Eventto'  and [Shift]='night'then
					   [DRILLINGDETAIL].[VALUE]
				   else
					   '-'
			   end)EventTOnight
			    from DRILLINGDETAIL where  [DRILLINGDETAIL].[PROJECTCODE] = 'ma'
		  and cast([DRILLINGDETAIL].[DRILLINGDATE] as date)
		  ='15-jul-2017'
		  Group by HOLEID, DRILLINGDATe, name,value

declare  @drillingdetail  table (drillingdate varchar(255),projectcode varchar(255),  [shift] varchar(255), name varchar(255), [value] varchar(255),[holeid] varchar(255))
insert into @drillingdetail  (drillingdate ,projectcode ,  [shift] , name , [value] ,[holeid] ) values ('15-jul-2017', 'uz','day', 'EventFrom', '1122','MAKH-17-005')