Solid content. Please post more videos.

Never knew we could use Range like this. Thank you.

How to do the same in oracle sql, because in oracle sql we don't have this function ?

This is extremely helpful! Appreciated for sharing!

Thanks a lot, with the help of this video, my problem has been resolved

Practice SQL Queries on Your Browser through Interactive Courses - learnsql.com/?ref=otm1ytl

Practice SQL Queries on Your Browser through Interactive Courses - learnsql.com/?ref=otm1ytl

Practice SQL Queries on Your Browser through Interactive Courses - learnsql.com/?ref=otm1ytl

Practice SQL Queries on Your Browser through Interactive Courses - learnsql.com/?ref=otm1ytl

Practice SQL Queries on Your Browser through Interactive Courses - learnsql.com/?ref=otm1ytl

Practice SQL Queries on Your Browser through Interactive Courses - learnsql.com/?ref=otm1ytl

if more columns how to do unpivot?

I found this months ago... Again I remember, thank you

Learned something new. Thanks.

do you know how to change the default text if no data available?

Can also, click on columns and ctrl c and ctrl v and paste anywhere ...

@DT is var or Date is var?

If any data functions don't meet requirement, finally i mostly use this , format (). Thanks for the tip 🙂

Great technique

This is very useful. Thanks.

Thank you

Your content is really helpful.

Useful

Thanks for this. Really appreciate it

Very useful, thank you very much 👍

Thank you so much. Assuming that the target is a database table, how to change this logic to read the files in parallel and load into the target in parallel instead of sequentially? The actual requirement is a SQL task prior to the Foreach Loop is feeding a list of databases against which same SQL has to be run in parallel (as the SQL runs for a long time) on all the databases that the Foreach Loop receives and the data extracted from each database should be loaded to the same target table in the target database.

Useful