#Parameter1:Periode:monthtable:monthtable
-SQL-
SELECT        dbo.PRIVAT.NRPRIVAT, dbo.RECALL.Datum, dbo.RECALL.Zeitvon, dbo.RECALL.Zeitbis, dbo.ANREDE.Anrede_D, dbo.TITEL.TITEL_D, dbo.PRIVAT.NAME, dbo.PRIVAT.VORNAME, dbo.PRIVAT.STRASSE, dbo.PRIVAT.COADRESSE, 
                         dbo.PRIVAT.PLZ, dbo.PRIVAT.ORT, dbo.PRIVAT.TELP, dbo.PRIVAT.FAXP, dbo.PRIVAT.TELG, dbo.PRIVAT.FAXG, dbo.PRIVAT.E_Mail, dbo.PRIVAT.Briefanrede, dbo.get_adresse_direkt(dbo.privat.nrprivat,0) as Adresse,
			dbo.get_adresse_direkt(dbo.privat.nrprivat,1) as AdresseEinzeilig
FROM            dbo.PRIVAT INNER JOIN
                         dbo.RECALL ON dbo.PRIVAT.NRPRIVAT = dbo.RECALL.Nrprivat LEFT OUTER JOIN
                         dbo.TITEL ON dbo.PRIVAT.NRTITEL = dbo.TITEL.NRTITEL LEFT OUTER JOIN
                         dbo.ANREDE ON dbo.PRIVAT.NRANREDE = dbo.ANREDE.NRANREDE
WHERE        dbo.recall.aktiv=1 and (YEAR(dbo.RECALL.Datum) = substring('#Parameter1',4,4)) AND (MONTH(dbo.RECALL.Datum) =left('#Parameter1',2))