SELECT ProductID, ProductName, CategoryID
FROM dbo.udf_GetProductsByCategoryID(1)