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 WHERE dok_Typ = 2 AND dok_DataWyst = DATEADD(dd, DATEDIFF(dd, 0, GETDATE()),0) AND dok_PlatnikId = [ID_KONTRAHENTA] ORDER BY dok_Nr