動的に作成されたフィルターをSQLServerのストアドプロシージャのパラメーターとして渡し、データをフィルター処理するにはどうすればよいですか？

Finally, I've written Javascript code (a little complex) to :

• Create dynamic filters and its respective inputs
  1. My actual types are only 4 (int,bit,varchar,date)
  2. For 'int' create dynamically an <input type="number">
  3. For 'date' create dynamically an <input type="text"> , with a date plugin
  4. Etc...
• I've created an array to store the id's of my filters and send to the server via AJAX call (and the complete form)

Then in the server code (C#) I've written code to:

• Save the campaign details.
• Loop over the parameter array.
  1. Save each filter added with the CampaignId provided by the AddCampaign stored procedure (after save the campaign), the filter id provided by each select value of the form, and the value provided on the generated input.

And then in SQL Server, I've just used the stored procedure that I've supplied on the question, a little modified:

CREATE PROCEDURE usp_MarketingUsersGetFiltered
-- Add the parameters for the stored procedure here
@CampaignId int,
@Debug BIT = 0
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
declare @sql varchar(max) = '', @Nsql nvarchar(max), @DatabaseId INT;
-- Insert statements for procedure here

set @DatabaseId = (SELECT DatabaseId from tblMarketingCampaigns where Id=@CampaignId);
select @sql +=  ' AND '+quotename(f.TargetColumn) + f.Operation + 
            case f.InputType 
            when 'int' then cf.Value
            when 'bit' then cf.Value
            else quotename(cf.Value,'''')               
            end
from dbo.transMarketingCampaignFilters as cf
join dbo.tblMarketingCampaignFilters as f
on cf.CampaignFilterId = f.Id
where cf.CampaignId = @CampaignId

 set @sql = '
 select MarketingUserId,
        FirstName,
        LastName,
        tblMarketingUsers.Email as UserEmail,
        CompanyId,
        CompanyName,
        Address1,
        Address2,
        City,
        SmartInsightProfile,
        LastLoginDate,
        AdvancedProfileStatus
 from dbo.tblMarketingUsers 
 left join dbo.tblCompanies on tblMarketingUsers.CompanyId=tblCompanies.Id
 where DatabaseId = @DatabaseId
 '+ @sql+'
 OPTION (RECOMPILE)';

if @Debug = 1 print @sql;
set @Nsql = @sql;
exec sys.sp_executesql @Nsql,N'@DatabaseId INT',@DatabaseId;

END
GO

My tables are something like this

Where tblMarketingCampaignFilters stores rows similar to :

（Id、Name、InputType、TargetColumn、Operator）

（1、 'Advanced Profile Status'、 'int'、 'AdvancedProfileStatus'、 '<'）

（2、 '最終ログイン日'、 '日付'、 'LastLoginDate'、 '<'）

（3、 'Geo Location（City）'、 'varchar'、 'C​​ity'、 'LIKE'）

そして最終結果：

 select MarketingUserId,
        FirstName,
        LastName,
        tblMarketingUsers.Email as UserEmail,
        CompanyId,
        CompanyName,
        Address1,
        Address2,
        City,
        SmartInsightProfile,
        LastLoginDate,
        AdvancedProfileStatus
 from dbo.tblMarketingUsers 
 left join dbo.tblCompanies on tblMarketingUsers.CompanyId=tblCompanies.Id
 where DatabaseId = 3
  AND [City]LIKE'%salta%' AND [SmartInsightProfile]!=1 AND [LastLoginDate]<'20150708' AND [AdvancedProfileStatus]<42
 OPTION (RECOMPILE)

助けてくれてありがとう！

これが最善の方法ではないことはわかっていますが、今ではうまくいきます。

これが他の誰かを助けることを願っています。