SELECT DISTINCT
		 o.id, o.name AS 'Procedure_Name' , oo.name AS 'Table_Name', d.depid
--, d.depnumber  -- comment this out returns unique tables only
FROM sysdepends d, sysobjects o, sysobjects oo
WHERE 	o.id=d.id 
		AND o.name= 'uspGetBillOfMaterials'   -- Stored Procedure Name
		AND oo.id=d.depid 
		--and depnumber=1
ORDER BY o.name,oo.name

id Procedure_Name Table_Name depid depnumber
2123154609 uspGetBillOfMaterials BillOfMaterials 213575799 2
2123154609 uspGetBillOfMaterials BillOfMaterials 213575799 3
2123154609 uspGetBillOfMaterials BillOfMaterials 213575799 4
2123154609 uspGetBillOfMaterials BillOfMaterials 213575799 5
2123154609 uspGetBillOfMaterials BillOfMaterials 213575799 7
2123154609 uspGetBillOfMaterials BillOfMaterials 213575799 8
2123154609 uspGetBillOfMaterials Product 1717581157 1
2123154609 uspGetBillOfMaterials Product 1717581157 2
2123154609 uspGetBillOfMaterials Product 1717581157 9
2123154609 uspGetBillOfMaterials Product 1717581157 10