--BIREPORT--

SELECT
  CONTRACTNUM AS Kontraktsnr,
  ITEMID AS "Individuell tjänst",
  FORMAT (STARTDATE, 'yyyy-MM-dd') AS Startdatum,
  FORMAT (ENDDATE, 'yyyy-MM-dd') AS Slutdatum
FROM
  XLN_EXU_INDIVIDUALSERVICETRANS
WHERE
  CONTRACTNUM IN ('kontraktsnr')
  AND ITEMID = 'RabattInd392'

--Area52--

SELECT
  sourcecontractno,
  articleid,
  startdate,
  enddate
FROM
  src_xln_contractprices
WHERE
  sourcecontractno IN ('kontraktsnr')
  AND articleid = 'RabattInd392'

--productdb--

SELECT
  elavtalId,
       productTypeName,
  startdate,
  stopdate
FROM
  Avtal_Elavtal_Priser
WHERE
  elavtalId IN ('avtalsid')
  AND productTypeName = 'Rabatt månadsavgift 39,2'