procedure for filtration

See more:

SQL

USE [DevOverall]
GO
/****** Object:  StoredProcedure [dbo].[usp_GetFilterHolidayListing]    Script Date: 05/08/2013 19:16:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
ALTER PROCEDURE [dbo].[usp_GetFilterHolidayListing]
@ERROR_MSG VARCHAR(500) OUT,
@DAY INT,
@NIGHT INT,
@PRICES VARCHAR(20),
--@DATE DATETIME,
@HOLIDAYTYPEID INT,
@CITY VARCHAR(100)
AS
BEGIN TRY 
BEGIN
     SELECT HOLIDAYNAME,HOLIDAYTYPEID,HOLIDAYSUBTITILE,HOLIDAYSTARTPRICES,SEARCHKEY,CITY,VALIDDATETO,DESTINATIONGUIDE,HOLIDAYDESCRIPTION,IMAGES,SHORTDESCRIPTION, ID,
		(CAST(DURATIONDAY AS VARCHAR)+' '+'DAYS' + ',' +  CAST(DURATIONNIGHT AS VARCHAR)+' '+'NIGHTS')AS DURATION 
		FROM HOLIDAYDESCRIPTION WHERE 
		CITY=ISNULL(@CITY,CITY) AND 
		HOLIDAYTYPEID<=ISNULL (@HOLIDAYTYPEID,HOLIDAYTYPEID) AND 
		--[HOLIDAYVALID]<=ISNULL (@DATE,HOLIDAYVALID) AND
		 DurationDay<=ISNULL(@DAY,DurationDay) AND 
		 DurationNight<=ISNULL(@NIGHT,DurationNight) AND 
		 HOLIDAYSTARTPRICES<=ISNULL (@PRICES,HOLIDAYSTARTPRICES) AND 
		 [STATUS]=1 
		 ORDER BY 
		 HOLIDAYNAME,HOLIDAYVALID,SEARCHKEY,HOLIDAYSUBTITILE,CITY,HOLIDAYDESCRIPTION,HOLIDAYSTARTPRICES,
		 DESTINATIONGUIDE,SHORTDESCRIPTION,IMAGES,DURATIONDAY,DURATIONNIGHT,DURATION	
END				  
END TRY      
BEGIN CATCH   
SET @ERROR_MSG=ERROR_MESSAGE()
RETURN ERROR_NUMBER()
END CATCH

i m using this procedure for filtration (supose we have display 10 results & using the filter than result will display according to the condition)I want to results from this procedure so plz tell me this procedure is correct or not