3 Replies Latest reply on Jun 14, 2018 5:19 AM by Juergen Voelkening

    how can i get the name of a request offering in a dbo.servicereq query

    AnnetteM Rookie

      Heat 2015 SQL 2014 - How can I get the name of a request offering in a dbo.servicereq query.  I am running a query on service request tickets.  I would like to include the name of the request offering in my results as a column.  I can't figure out what to join or union as nothing matches between dbo.servicereq and dbo.servicereqtemplate.  I want to include:

       

       

      YEAR (ServiceReq.[CreatedDateTime] )  as Year,

      (varchar(3),ServiceReq.CreatedDateTime) as Month

      ,[ServiceReqNumber] as TicketNumber

      ,ServiceReq.[Sisu_CustomerRedID] as Facility

      ,ServiceReq.[CreatedBy]

      ,ServiceReq.[CreatedDateTime]

      ,ServiceReq.LoginID

      ,Servicereq.ProfileFullName

      ,ServiceReq.Source

      ,ServiceReq.CustPriority

      ,ServiceReq.[Status]


      FROM {database}.[dbo].[ServiceReq]


       

       

      dbo.servicereqtemplate.name is what I am trying to get