dynamische WennDann Parameter

declare @v nvarchar(Max);

set @v = ‘Update f

SET f.[Materialeinsatz [EUR] = T.Materialeinsatz FROM F_Sales f LEFT JOIN (SELECT

f.[OrderItemID] ,

CASE ‘

SELECT

@v = @v + CONCAT(‘ WHEN ‘, [Bedingung], ‘ THEN ‘,  [Abrechnungswert])

FROM Test_Staging.[dbo].[T_CO_Abrechnungsschemas] AS TCOAbrS

–where clientId <4

set  @v =@v+ ‘ ELSE f.EK_FA_NEU END  AS Materialeinsatz  from F_Sales f LEFT JOIN D_Lieferant l ON f.OrderItemID= l.OrderItemID

LEFT JOIN D_Produkt p on f.[quantityId]=p.[product_quantityID] ) AS T

ON f.OrderItemID =T.OrderItemID

where f.StornoFlag = 0

‘

select @v

exec sp_executesql @v

Beispiel 2

declare @v nvarchar(max);

set @v =

‘Update d

SET d.MaxProzentDiscount = T.MaxDiscount FROM dArtikel d

LEFT JOIN

(SELECT

d.ArtikelNr ,

d.MandantenNr,

CASE ‘

SELECT

@v = @v + CONCAT(‘ WHEN ‘, ‘Mandantennr= ‘, [Mandant], ‘ AND ‘, [Mappingkriterium], ‘ THEN ‘, [Prozent])

FROM [txtProductMaximalRabatt] AS txtMR

set @v =@v+ ‘ ELSE 0 END AS MaxDiscount from DArtikel d ) AS T

ON d.ArtikelNr =T.ArtikelNr AND d.MandantenNr = T.MandantenNr

‘

select @v

exec sp_executesql @v