CREATE PROCEDURE `CustomerOrder_SelectItems_ByCompany`( IN pCompanyId INT) BEGIN SELECT -1 as ItemId ,'Select Item' as Description3 , 'Select No' as No , 'Select No2' as No2 , 0 as RowNo UNION SELECT S.ItemId , S.Description3 , S.No , S.No2 , 1 as RowNo FROM itemmaster S where statusId=1 AND S.CompanyId=pCompanyId END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)