Laufzeit von Stored Procedure verkürzen

[Bummi]

nur schematisch ....

Code:

Create Table #pl
(
Value Varchar(20)
)

insert into #pl
SELECT Value FROM [inventory].[dbo].[fnSplit](@Productline, ';')

....


Select ALL_MaterialGrid,ALL_Brand,ALL_ProductLine,ALL_LowestPLC_SKU
,(CONVERT(Float, REPLACE(ALL_AvailableStock, ',', '.'))  as ALL_AvailableStock
....
....
...
into #tmp1
from inventory.inv_all
Where ALL_ProductLine   in (Select * from #pl)
and ....


Ceate Table #Result
(
Storage varchar(30),
Typ varchar(20),
[PLC_<25] int,
........
)


insert into #Result

Select
'Warehouse' as Storage,
'SKUs' as Typ,
(Select Count(*) from #tmp1
where
...
...
...
and ALL_AvailableStock > 0) as [PLC_<25],
......

insert into #Result
......


--final:

Select * from #Result