CREATE PROC [dbo].[sp_GetallEqupments] 100 @SFBId int as begin --V.VesselPosition as PositionInVessal,C.Capacity as Capacity, select EquipmentId,EquipmentName,Make,Model, Head,RPM, --,Quantity,MakersAddress,Yard,HullNo,YearOfManufactured,CriticalEquipments,RunningHourBased, --InheritRunningHoursfrom,NoOfUnits,E.CreatedBy,E.CreatedDate, S.SubFunctionalBlockName,F.FunctionalBLockName,F.FunctionalBLockId --,Sno from PMS_TBL_EQUIPMENT_MASTER E inner join dbo.PMS_TBL_SUB_FUNCTIONAL_BLOCK_MASTER S on S.SubFunctionalBlockId=E.SFBId inner join dbo.PMS_TBL_FUNCTIONAL_BLOCK_MASTER F on F.FunctionalBLockId=S.FBId --inner join dbo.PMS_TBL_EQUIPMENT_CAPACITY_MASTER C on C.CapacityId=E.Capacity --inner join PMS_TBL_EUIPMENT_VESSELPOSITION_MASTER V on V.VesselPositionId=E.PositionInVessal where E.SFBId=@SFBId and E.IsActive=1 order by EquipmentId asc end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)