Hello Amir, NICE EXPLANATION. I got a doubt here. when you write the query - 'select * from dbo.totalsale where region in (@region)' in SSRS. The parameters that we are passing in are also with out quotation marks. I mean we pass ASIA,EUROPE. Here we get output successfully. Why we keep quotation marks in stored procedures? Please clear my doubt Amir...
nice video! just one question, do we must use dynamic SQL in this case? I don't really see the point why we use dynamic SQL. Thanks!
Nice video. I have one question. Here we are retrieving records from a table. Can we use a CTE instead of table?
Thank you.
Hello Amir, NICE EXPLANATION. I got a doubt here.
when you write the query - 'select * from dbo.totalsale where region in (@region)' in SSRS. The parameters that we are passing in are also with out quotation marks.
I mean we pass ASIA,EUROPE. Here we get output successfully. Why we keep quotation marks in stored procedures?
Please clear my doubt Amir...
Any other easier ways of doing this
I don't think so. You will get used to it , if you practice couple of times:) all the best