Just make coma(,) separated string of Asset_Type id like '1,2,3,4,5,6,7,8' and pass it to the procedure.
Make one store procedure which accept the id of Asset_Type in string like '1,2,3,4,5,6,7,8'.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[SP_getAllVendorDetails]
(
@Asset_TypeID varchar(max)
)
As
Begin
EXEC(
'select distinct(Vendor_Name) FROM vendor WHERE Asset_TypeID IN (' + @List + ')'
)
End
so it will return distinct vendor list