Create PROC [dbo].[SP_Planning]
AS
BEGIN
Truncate TABLE Planning
Select * into
Planning
from (select T0.ID,T1.SID,[dbo].[Planning](T1.Id,T0.SId) as Status
from BDetails T0
cross join SDetails T1)
END
Loading
Create PROC [dbo].[SP_Planning]
AS
BEGIN
Truncate TABLE Planning
Select * into
Planning
from (select T0.ID,T1.SID,[dbo].[Planning](T1.Id,T0.SId) as Status
from BDetails T0
cross join SDetails T1)
END
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh KumarPosted Jul 9, 2022, 3:19 AM