Once Again, No Records Returned....

The following sproc returns no records in query analyzer, although it doesn't error out either. Last time adding the length to the end of the variable fixed this problem, but this time it's an integer type which doesn't accept a length. Any ideas?











----------------------------------------------------------------------------------------------------


CREATE PROCEDURE spUnitsbyUnitID


@unitid int


AS





SELECT


E.camid, E.camname, E.cammodel, E.unitid,


D.contactid, D.Contactfname, D.Contactlname, D.Contactphone, D.Contactcell, D.Contactcompany, D.unitid,


C.videoserverid, C.videoservermac, C.videoserveruser, C.videoserverpass, C.videoservermodel, C.videoserverip, C.unitid,


B.radioid, B.radioip, B.radiomac, B.radioessid, B.radiouser, B.radiopass, B.unitid,


A.unitid, A.unitcity, A.unitname, A.unitalias, A.unitdeploydate, A.unitpickupdate, A.unitattatchedcams, A.unitenabled





FROM tbl_units as A





INNER JOIN tbl_radios as B ON A.unitid = B.unitid


INNER JOIN tbl_videoservers as C ON A.unitid = C.unitid


INNER JOIN tbl_contacts as D on A.unitid = D.unitid


INNER JOIN tbl_cameras as E on A.unitid = E.unitid





WHERE A.UnitID = @unitID


GO


-----------------------------------------------------------------------------------------------------