What problem of my store procedure ?

[nUflAvOrS]

What problem of my store procedure ? can anyone help me to solve my problem thanks a lot.

------------------------------------------------------------

USE [Local Mattress System]
GO
/****** Object:  StoredProcedure [WANSERN\wansern].[SP_LoadProduct]    Script Date: 05/06/2008 15:18:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:      Chia Chet Shian
-- Create date: 06/05/2008
-- Description: Load Spec Product
-- =============================================
ALTER PROCEDURE [WANSERN\wansern].[SP_CreateViewProd] 
    -- Add the parameters for the stored procedure here
    @PCRefNo varchar(50),
    @ProductCode varchar(50),
    @Company_Name varchar(100),
    @Brand varchar(250),
    @Model varchar(250),
    @Prod_Type varchar(50)
AS
    if OBJECT_ID(N'View_ProdList',N'V')IS NOT NULL
    DROP VIEW VIEW_ProdList
    GO
    CREATE VIEW View_ProdList AS
    SELECT  Prod_List.PCRefNo, Prod_List.Product_Code, Prod_List.Company_Name, Prod_List.Brand, Prod_List.Model, Prod_List.Prod_Type,Prod_List.Thinkness, Prod_List.T_Unit, Prod_List.Width, Prod_List.W_Unit, Prod_List.Length, Prod_List.L_Unit, Prod_List.Status, Prod_List.Cost
    FROM    Prod_List 
    WHERE Prod_List.PCRefNo = @PCRefNo AND Prod_List.Product_Code LIKE %@ProductCode% AND Prod_List.Company_Name LIKE %@Company_Name% AND Prod_List.Brand = %@Brand% AND Prod_List.Model = %@Model% AND Prod_List.Prod_Type LIKE %@Prod_Type%
    GROUP BY Prod_List.PCRefNo, Prod_List.Product_Code, Prod_List.Company_Name, Prod_List.Brand, Prod_List.Model, Prod_List.Prod_Type, 
             Prod_List.Thinkness, Prod_List.T_Unit, Prod_List.Width, Prod_List.W_Unit, Prod_List.Length, Prod_List.L_Unit, Prod_List.Status, Prod_List.Cost
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
 
    -- Insert statements for procedure here
    
END