SELECT     t.idTicket, k2.text AS statustext, t.erstellDatum, t.ablaufDatum, t.gueltig, t.einmalig, g.nname, t.ausfuehrender, t.empfaenger, k.text AS rubriktext,
                     p.posNr, p.anzahl, p.gegenstand, p.hersteller, p.seriennummer
FROM         dbo.Ticket AS t
INNER JOIN dbo.Genehmiger AS g ON t.fkGenehmiger = g.idGenehmiger
 INNER JOIN dbo.Kuerzel AS k ON k.zeichen = t.rubrik
 INNER JOIN dbo.TicketLog AS l ON t.lastFkTicketLog = l.idTicketLog
  INNER JOIN dbo.Kuerzel AS k2 ON k2.zeichen = l.status
   INNER JOIN dbo.TicketPos AS p ON t.idTicket = p.fkTicket
WHERE     (k.klasse = 'ticket.rubrik') AND (k2.klasse = 'ticketLog.status')
AND ISNULL(idTicket,'%') like @idTicket
AND convert(varchar(10),t.erstellDatum,102) >= convert(varchar(10),convert(datetime,@erstellDatumVon,104),102)
AND convert(varchar(10),t.erstellDatum,102) <= convert(varchar(10),convert(datetime,@erstellDatumBis,104),102)
AND k2.zeichen like @statusText
AND ISNULL(empfaenger,'%') LIKE @empfaenger
AND ISNULL(ausfuehrender,'%') LIKE @ausfuehrender
AND k.zeichen like @rubrik
AND ISNULL(einmalig,'%') LIKE @einmalig
AND ISNULL(g.nname,'%') LIKE @genehmiger
AND ISNULL(gueltig,'%') LIKE @gueltig