How to Change 2nd Parameter Value Based on 1st Parameter Selection

Hi,

Why do you need to get Parameter2 as a parameter ? you can use a dataset with a query Like :

Select 

Case When @parameter1 = 'A' then 20 

Else 40 end 

END 
AS Param2

Sts

---

Dj's | Please mark as answered or vote helpful if this post help resolved your issue. Thanks!