Improve a MS-SQL Query with a Loop

We need a improvement of a MS-SQL Query - At the moment the query looks like this: declare @InventurDatum AS DATETIME; declare @InventurDatum2 AS DATETIME; SET @InventurDatum = CONVERT(datetime, '01/03/2018 00:00:00', 103); SET @InventurDatum2 = CONVERT(datetime, '28/03/2018 23:59:59', 103); SELECT [login to view URL], [login to view URL], [login to view URL], ( select sum([login to view URL]) from tbestellpos asdf LEFT JOIN tBestellung bes ON asdf.tBestellung_kBestellung = [login to view URL] WHERE asdf.tArtikel_kArtikel = [login to view URL] AND [login to view URL] > @InventurDatum and [login to view URL] < @InventurDatum2 ) as Verkauf, CAST((select A.fLagerbestand-coalesce(sum([login to view URL]),0 ) FROM [eazybusiness].[dbo].[tArtikelHistory] AS D WHERE A.kArtikel=[login to view URL] and [login to view URL] != 1AND [login to view URL] > @InventurDatum) AS int) as 'Anfang', CAST((select A.fLagerbestand-coalesce(sum([login to view URL]),0 ) FROM [eazybusiness].[dbo].[tArtikelHistory] AS D WHERE A.kArtikel=[login to view URL] and [login to view URL] != 1AND [login to view URL] > @InventurDatum2) AS int) as 'Ende' FROM [eazybusiness].[dbo].[tlagerbestand] AS A LEFT JOIN tArtikelBeschreibung cd ON [login to view URL] = [login to view URL] LEFT JOIN [eazybusiness].[dbo].[tArtikel] AS B ON [login to view URL] = [login to view URL] WHERE [login to view URL] != 1 AND [login to view URL] = 1 and [login to view URL] = 1 order by [login to view URL] asc ####### What we need is kind of loop within this query through each day between @ InventurDatum and @ InventurDatum2 which returns the amount for each day in a single row with the day as the rows headline.