Untitled

INSERT @t_table_parameters(

       parameterid,
       defaultValue,
       FieldLabel,
       SQLParameter,
       NumOrder,
       Mandatory)
SELECT (SELECT id FROM report.parameter WHERE parameterName = 'StartDate'),  -- report.parameter
       NULL,
       NULL,
       '@d_start_date',
       10,
       1
UNION
SELECT (SELECT id FROM report.parameter WHERE parameterName = 'EndDate'),  -- report.parameter
       NULL,
       NULL,
       '@d_end_date',
       20,
       1
UNION
SELECT (SELECT id FROM report.parameter WHERE parameterName = 'ConcessionType'),  -- report.parameter
       'All',
       NULL,
       '@v_concession_type',
       30,
       1
UNION
SELECT (SELECT id FROM report.parameter WHERE parameterName = 'BillingOrg'),  -- report.parameter
       'All',
       NULL,
       '@v_billing_org',
       40,
       1