if Customer Model No - A001
Customer Order No - Ord200
Order Qty -10
Order model - 311A //if it will 311A-01, 311A-02... and other data will same then...
CREATE PROCEDURE OrderNo
(
@CusModlNo nchar,
@CusOrdNo nchar,
@OrderModelNo nchar,
@OrderQty int
)
AS
BEGIN
with nums as
(select '-01' as srno union all
select '-02' as srno union all
select '-031' as srno union all
select '-04' as srno union all
select '-05' as srno
)
insert into TableName
select @CusModlNo, @CusOrdNo + srno, @OrderModelNo, @OrderQty)
from nums;
END
GO
Happy Coding!
:)