smoothdeveloper

create procedure dbo.dynamic_simple_contingency_table_query
  @withExpression nvarchar(max) -- ^ optional with CTE expression
  , @selectStatement nvarchar(max) -- ^ select statement, should return at least three columns, whose name matches following parameters
  , @row_column_key nvarchar(max) -- ^ column name which identifies row keys (result will have as many distinct rows as found here)
  , @column_column_key nvarchar(max) -- ^ column name which identifies column keys (result will have as many distinct values as found here)
  , @fact_column_key nvarchar(max) -- ^ column name which contains facts
as
begin
declare @sql nvarchar(max)
set @sql = @withExpression