I am tring to pass comma split multi values in for a paramater in to ssrs. The Sproc that is points to uses dynamic sql and the paramater is nested in a an oracle query
in visual studio I have multi values selected but it does not seem to work.. below is the stored procedure
alter PROCEDURE dbo.[USP_SALES_LAUNCH_XX]
, @TIMEFRAME CHAR(30)
--SET @EM_ITEM_NUM = '1100015'
--SET @TIMEFRAME = '18 Months'
declare @sqlQuery VARCHAR(8000)
declare @finalQuery VARCHAR(8000)
SET @sqlQuery = 'select
sum(oss.SLS_QTY) as QTY
,sum(oss.SLS_AMT) as AMT
,TO_CHAR(oss.INVC_DT, ''''MON, YYYY'''') AS MYDATE
View Complete Post