These are really superb series...all vedios are crisp and clear.. directly goes into brain..I wish I would've come here very long before..but I am sure it will take me beyond from here
Awesome! I appreciate it, that would really help with something I'm working on at work where I have to use a matrix and let the user select the row, column or data fields. The error I was getting referred to a data type issue and I'm not sure what I'm doing wrong in the example - again thank you for your help - your videos are outstanding.
2 question please: 1- What's the purpose of ( ) on the SELECT Statement within the first IF statements, doesn't the BEGIN & END do the job of telling the system what to return? 2 - Could you have used an ELSE clause for that last statement? if yes, would you need ( ) ? Thanks
Hi Bijou, 1 - The ( ) within the IF statements are not required at all. I may have had a reason for including them (perhaps for aesthetics) but it's over 8 years since I recorded the video so I'm afraid I can't remember what that reason was! 2 - Yes, you could use an ELSE clause for the final statement (I assume you mean line number 29) but you wouldn't need ( ) here either. I hope that helps!
As written, wouldn't it still return "You must choose ALL, AWARD, or FINANCIAL" even if you DID provide one of those three when executing the procedure? Wouldn't you have to nest those IF statements and then have the last SELECT statement after an ELSE statement?
great video. I have a question. Would you be able to do a video on Dynamic Matrices in SSRS? you have a tutorial on your website and I followed it, but i'm getting errors when running the report. i have a requirement to create a report like this, but cant seem to find any documentation online and your link below is the only one that has anything on the subject.
I tried doing this tutorial and used the database creation file you provided here, but the database does not have the FilmGenreID column in the tblFilm table .... did you make this column in another tutorial that I missed .... or am I missing something altogether? .... Thank you, your tuts are excellent. :-)
Hi Nick , you could write an INSERT INTO statement to create a new record in the Film table, or an UPDATE statement to alter an existing record. You could also right-click the table in the Object Explorer window and choose to Edit the records if you prefer to do this by hand. I hope that helps!
Hi there, it looks like the download folder didn't include the modified version of the database with the Genre table. That should be fixed now and here's an alternative link you can use to create the Movies database with the Genre table drive.google.com/file/d/1HF30umHFgWIMpkRiPrVFWtOyqbM4341E/view?usp=sharing Hope it helps!
These are really superb series...all vedios are crisp and clear.. directly goes into brain..I wish I would've come here very long before..but I am sure it will take me beyond from here
Thank you! Happy to hear that you're finding the videos useful. Thanks for watching and for taking the time to leave a comment!
I enjoyed the video.
Especially BEGIN, END and RETURN key words use.
Thanks a lot for educating me.
well illustrated and clear explanation , Thank you
Thanks! Happy to hear that you found it useful!
I found that I needed to add USE MOVIES before the command at 9:20 for it to work.
Thanks for the videos.
Great Video. Straight forward and easy to follow. Thank you!
its very simple and goes straight to your mind , thanks for great tutorials !
Bravo! Andrew. Well learned is well taught.Thanks, indeed.
Hard to find such simple explanation....... great n thanks for this informative vid:)
Excellent video .....Nice Teaching....Goood job......Thank you....
Awesome! I appreciate it, that would really help with something I'm working on at work where I have to use a matrix and let the user select the row, column or data fields. The error I was getting referred to a data type issue and I'm not sure what I'm doing wrong in the example - again thank you for your help - your videos are outstanding.
Absolutely first-class. Thanks so much for the education!
2 question please:
1- What's the purpose of ( ) on the SELECT Statement within the first IF statements, doesn't the BEGIN & END do the job of telling the system what to return?
2 - Could you have used an ELSE clause for that last statement? if yes, would you need ( ) ?
Thanks
Hi Bijou,
1 - The ( ) within the IF statements are not required at all. I may have had a reason for including them (perhaps for aesthetics) but it's over 8 years since I recorded the video so I'm afraid I can't remember what that reason was!
2 - Yes, you could use an ELSE clause for the final statement (I assume you mean line number 29) but you wouldn't need ( ) here either.
I hope that helps!
@@WiseOwlTutorials Oh, that makes sense. It might be 8 years old but the course is golden mine for some of us. Thank you.
@@BijouBakson I'm really happy that you're finding it useful, thanks for the support!
As written, wouldn't it still return "You must choose ALL, AWARD, or FINANCIAL" even if you DID provide one of those three when executing the procedure? Wouldn't you have to nest those IF statements and then have the last SELECT statement after an ELSE statement?
Awesome videos.Learnt a lot. Enjoyed everymoment
When would you use this instead of case / end statement
Hi Andrew,
excellent video as always.
Could you post the types of genres there are in the DB?
Thanks again.
Andi
thanq sir...u provided beautiful explanation for nested-if and if in stored procedures..can i expect videos regarding while,triggers, views from you..
good job, thank you very much, please more :)
Sorry sir but I would like to know how to add 'FilmGenreID' in my Film table cuz I don't see that column in table
Thanks very useful sharing
You're welcome, thank you for watching!
great video. I have a question. Would you be able to do a video on Dynamic Matrices in SSRS? you have a tutorial on your website and I followed it, but i'm getting errors when running the report. i have a requirement to create a report like this, but cant seem to find any documentation online and your link below is the only one that has anything on the subject.
great videos. Thank you .
Is there a Elseif statement to replace the nested if?
I tried doing this tutorial and used the database creation file you provided here, but the database does not have the FilmGenreID column in the tblFilm table .... did you make this column in another tutorial that I missed .... or am I missing something altogether? .... Thank you, your tuts are excellent. :-)
No problem sir, just had to make sure I wasn't crazy LOL :-)
:-D ... A Wise Owl you are :-D lol ...again, ty and excellent vids ... the SSRS vids are awesome
I am trying to find exact age for actor using datediff and if statements but can't succeeded van you please help
i cant post the link for some reason, but its on your website.
MAKE AN SSRS MATRIX DYNAMIC, LIKE A PIVOT TABLE
Great! Thank you so much
You're very welcome Cristian, thanks for watching!
Hi Andrew
How do I enter data for FilmGenreID?
Hi Nick , you could write an INSERT INTO statement to create a new record in the Film table, or an UPDATE statement to alter an existing record. You could also right-click the table in the Object Explorer window and choose to Edit the records if you prefer to do this by hand.
I hope that helps!
FilmGenreID is not a valid column in the table called tblFilm.
Hi there, it looks like the download folder didn't include the modified version of the database with the Genre table. That should be fixed now and here's an alternative link you can use to create the Movies database with the Genre table drive.google.com/file/d/1HF30umHFgWIMpkRiPrVFWtOyqbM4341E/view?usp=sharing
Hope it helps!
thanks a lot, a very helpulful video
thanku brother
You're very welcome, thank you for watching!
helpfu