SELECT  GetRepDevPartNo.Installation, GetRepDevPartNo.Installation_ANUM, GetRepDevPartNo.Location, GetRepDevPartNo.Location_ANUM, 
GetRepDevPartNo.id,GetRepDevPartNo.DeviceTag, GetRepDevPartNo.DeviceTag_ANUM, GetRepDevPartNo.partnumber, GetRepDevPartNo.balloon, 
GetRepDevPartNo.balloon_ANUM, GetRepDevPartNo.type, GetRepDevPartNo.quantity AS QUANTITY, .0 AS spare, PartNumber.Quantity_Per_Unit, 
PartNumber.Category, PartNumber.Manufacturer, PartNumber.Catalog_Number, PartNumber.Supplier, PartNumber.Part_type, PartNumber.Use_Unit, 
PartNumber.Order_Unit, PartNumber.Detailed_Description1, PartNumber.Detailed_Description2, PartNumber.Detailed_Description3, 
PartNumber.Detailed_Description4, PartNumber.Detailed_Description5, PartNumber.X, PartNumber.Y, PartNumber.Z, PartNumber.Weight, 
PartNumber.Power_Consumption, PartNumber.Selling_Price, PartNumber.Buying_Price AS BUYING_PRICE, PartNumber.Discount AS DISCOUNT, PartNumber.Assembly_Time, 
PartNumber.Wiring_Time, PartNumber.hour_cost, PartNumber.Additional_Part, PartNumber.Date_Created, PartNumber.Date_Modified, 
PartNumber.Device_Family, PartNumber.Attribute_Text, PartNumber.Single_Wire_Connection, PartNumber.Schematic_Symbol, 
PartNumber.Layout_Symbol, PartNumber.Wire_Diagram_Symbol, PartNumber.Hydraulic_Symbol, PartNumber.Pneumatic_Symbol, 
PartNumber.Single_Line_Symbol, PartNumber.Graphical_Plan_Symbol, PartNumber.Percent_Spare, PartNumber.Discipline,PartNumber.user1,PartNumber.user2,PartNumber.user3,PartNumber.user4,PartNumber.user5,PartNumber.user6,PartNumber.user7,PartNumber.user8,PartNumber.user9,PartNumber.user10,PartNumber.user11,PartNumber.user12,
PartNumber.user13,PartNumber.user14,PartNumber.user15,PartNumber.user16,PartNumber.user17,PartNumber.user18,PartNumber.user19,PartNumber.user20,PartNumber.user21,PartNumber.user22,PartNumber.user23,PartNumber.user24,PartNumber.user25,PartNumber.user26,PartNumber.user27,PartNumber.user28,PartNumber.user29,PartNumber.user30,PartNumber.user31,PartNumber.user32,PartNumber.user33,PartNumber.user34,PartNumber.user35,PartNumber.user36,PartNumber.user37,PartNumber.user38,PartNumber.user39,PartNumber.user40,PartNumber.user41,
PartNumber.user42,PartNumber.user43,PartNumber.user44,PartNumber.user45
FROM PartNumber RIGHT OUTER JOIN GetRepDevPartNo ON PartNumber.project_id = GetRepDevPartNo.project_id AND PartNumber.part_number = GetRepDevPartNo.partnumber WHERE GetRepDevPartNo.project_id=@projectid