Read a Table and add those records into a existing parameter that was send from a SSRS report
Posted on 2016-11-29
I need to read a Tablea, then add those records (10 varchar) into a existing SSRS report parameter (@Temp) before I process that parameter in the Stored Procedure. The parameter will already have choices in it (from the SSRS report), I just need to add more choices to it.
Parameter @Temp already contains: 'Chilly,Luke Warm,Hotter'
Parameter @Temp already will contain when done: 'Chilly,Luke Warm,Hotter,Hot,Cold,Warm,Warmer'
Table =Tablea Fld = Flda