select* from IT_Ticket_Details

 select* from IT_Ticket_Developer_Master 



 create proc Kpi_Ticket_Details @id bigint
 as
 begin

 --declare @id varchar(250) ='Issue Reported To';
 --module name
 if (@id ='Type of Issue')
 select row_id , Module_Name from IT_Ticket_Module_Master
 --issue type
 else if (@id='Module Name')
 select Iss_id , issue from  IT_Ticket_IssType

 --ticket severity
 else if (@id ='Severity of Issue')
 select rowid , problem from IT_Ticket_Severity

 --issue reported to
 else if (@id = 'Issue Reported To')

 select emplno , name from IT_Ticket_Developer_Master where fc= 'y'




  

CREATE Function IT_Ticket_Allocation()Returns Table Return   
  



Select  top 10000000  A.Row_id ,ReportedBy ReportedBy,SUBSTRING(ReportedBy,len(ReportedBy)-6, 7) TNO, Cell phone,Problem Severity_Iss ,Em1.Name Reported_TO,  
 Module_Name, Components,Issue Problem,UPper(Issuse_Describ)Issuse_Describ,Format(Date,'dd-MMM-yyyy hh:mm tt') Reported_Date,Approval ,Filepath,Fc_Name from IT_Ticket_Details A   
Left join IT_Ticket_Module_Master B on A.Module_id = B.Row_id   
Left Join IT_Ticket_Comp_Master C on A.Comp_id = C.Row_id and B.Row_id = C.Module_id   
Left Join IT_Ticket_IssType D on D.Iss_id = A.Type_Iss   
Left join IT_Ticket_Severity E on E.Rowid = A.Severity_Iss   
Left Join IT_Ticket_Developer_Master F on f.Emplno = A.ReportedTo  
Left Join Employeemas EM on Em.tno=SUBSTRING(ReportedBy,len(ReportedBy)-6, 7)  
Left Join (Select Emplno,NAme from IT_Ticket_Developer_Master) EM1 on Em1.Emplno=A.Fc_Name  
order by Row_id desc




create proc kpi_module_name
as 
begin

select * from IT_Ticket_Details
end

--Issue Reported To
create proc kpi_Reported_to 
as
begin

select name , emplno from IT_Ticket_Developer_Master where fc = 'y'
end