declare  @HOLECOORD  table (holeid varchar(255), projectcode varchar(255), coordinateset varchar(255), x float,y float,z float)
insert into @HOLECOORD  (holeid, projectcode, coordinateset, x,y,z) values ('UZ-001', 'UZ', 'WGS84', 100,200,300)
insert into @HOLECOORD  (holeid, projectcode, coordinateset, x,y,z) values ('UZ-002', 'UZ', 'WGS84', 100,200,300)
select * from @HOLECOORD
declare @DRILLINGDETAIL table (drillingdate varchar(255), shift varchar(255), holeid varchar(255), projectcode varchar(255), name varchar(255), value varchar(255))

insert into @DRILLINGDETAIL   (drillingdate, shift, holeid, projectcode, name, value) values ('27-oct-2017','day','UZ-001', 
'UZ','DrillDepth','20')
insert into @DRILLINGDETAIL  (drillingdate, shift, holeid, projectcode, name, value) values ('28-oct-2017','day','UZ-001', 
'UZ','DrillDepth','20')
insert into @DRILLINGDETAIL (drillingdate, shift, holeid, projectcode, name, value) values ('29-oct-2017','day','UZ-001', 
'UZ','DrillDepth','20')
insert into @DRILLINGDETAIL (drillingdate, shift, holeid, projectcode, name, value) values ('27-oct-2017','day','UZ-002', 
'UZ','DrillDepth','20')
select * from @DRILLINGDETAIL

select shift,holeid,projectcode,name,value from @DRILLINGDETAIL WHERE ... GROUP BY shift,holeid,projectcode,name,value