Is it possible to replicate this code from a stored procedure in a SSRS dataset?
exec @dtEffective = dbo.selUpdEnv 'PrevBusDt','=',@cdUser,'N'
What I'm trying to do is save the effective date in a variable and display the date in a textbox.
I tried creating a parameter called dtEffective and use it in the dataset. But it didn't save the value.