SELECT dok_NrPelny AS [Dokument], CONVERT(VARCHAR(10), dok_DataWyst, 120) AS [Data wystawienia], dok_WartNetto AS [Netto], dok_WartBrutto AS [Brutto], dok_Wystawil AS [Wystawil] FROM dok__Dokument INNER JOIN kh_Pracownik ON dok_PlatnikId = pk_IdKh WHERE dok_Typ = 2 AND dok_DataWyst = DATEADD(dd, DATEDIFF(dd, 0, GETDATE()),0) AND pk_Id = [ID_PRACOWNIKA] ORDER BY dok_Nr