My random rumblings

Use the following if you need to use the output of a stored procedure.

declare @t table(vbuNo bigint, thirdPartyId int, username varchar(512))

insert into @t

    exec proc_GetAVMVehicles

select distinct VbuNo from @t order by VbuNo