how to create and call scalar function in sql server 2008
Your Call works if it were a Table Valued Function. Since its a scalar function, you need to call it like:
SELECT dbo.fn_HomePageSlider(9, 3025) AS MyResult
Try
SELECT dbo.function (parameters)
Or you can simply use PRINT command instead of SELECT command. Try this,
PRINT dbo.fn_HomePageSlider(9, 3025)