sqlserver2005多选，多条件查询存储过程

USE [CustomerManagementCenter]
GO
/****** Object:  StoredProcedure [dbo].[sp_ManyIfSearch]    Script Date: 12/30/2010 14:27:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[sp_ManyIfSearch]
(
 @ServiceGroupId uniqueidentifier,
    @TypeId UNIQUEIDENTIFIER,
    @ProjectId UNIQUEIDENTIFIER,
 @Nationality VARCHAR(100),
 @Industry VARCHAR(100),
 @CertificateType VARCHAR(100),
 @CertificateNo VARCHAR(100),
 @Birthday VARCHAR(100),
 @BirthdayEnd VARCHAR(100),
 @CurrentBirthPlace VARCHAR(100),
 @BirthPlace VARCHAR(100),
 @EducationInfo VARCHAR(100),
 @Marriage VARCHAR(100),
 @HaveChild VARCHAR(100),
 @ChildCount VARCHAR(100),
 @ChildAgeInfo VARCHAR(100),
 @LiveTogather VARCHAR(100),
 @RealEstateCount VARCHAR(100),
 @BoughtInfo VARCHAR(100),
 @LiveInfo VARCHAR(100),
 @PersonalYearIncome VARCHAR(100),
 @FamilyYearInconme VARCHAR(100),
 @WorkLevel VARCHAR(100),
 @CompanyType VARCHAR(100),
 @CityIDInCityBasic UNIQUEIDENTIFIER,
 @CityIDInProjctBasic UNIQUEIDENTIFIER

)
AS
  declare @where NVARCHAR(MAX),
    @groupsql varchar(2000),
    @Time datetime
BEGIN

 set @Time=getdate()
 --所在业务组或者客服组的客户组包含的客户id

  set @groupsql='select Customerid
  from tb_CustomerInGroup_Relation
  where groupid in
  (
  select CustomerObjectId
  from dbo.tb_DataAuthority_UserCustomers_Relation
  where userobjectid=
     (select relationid
   from dbo.tb_SysAuthority_UserInGroup
   where userobjectid='''+convert(varchar(36),@ServiceGroupId)+