Thanks for this. I almost fell of my chair laughing - when I was a junior DW developer, contracted to a huge bank, I once made the naive comment of "why don't you just add a 'Not Specified' option to your account types, instead of using NULL - SURELY the developers are smart enough to keep the data clean"... Unfortunately the senior developer was in the room and didn't think I was funny, and I was almost escorted out of the building... You have to appreciate the lengths SQL, DW, and ETL developers have to go to, to keep data clean!!! The unsung heroes of the development game!! Thanks for a great episode. Loved this one!!
Bert, seriously thank you so much for the time to put together all the content you have in your channel. I’m not a Developer or a DBA, just an analyst who had to learn all this by reverse engineering others code. That approach is great and all but personally leaves me with so many performance questions. I’ve binged you’re channel like Netflix haha but because of that I’ve GREATLY improved the performance of my queries. Just wanted to say thank you and no matter how little a topic may seem to an expert like you, please keep making these tutorials. Even yesterday I used ISNULL to join with on what will be a very large table. 🤦♂️ I’ll be changing that in just a few minutes! Thanks from Texas!
This is exactly what I needed. Thank you. I'm having to left join a third table where the first and second table, also connected earlier on a left join, is null. I think the solution you taught is the solution to what I was struggling with last week!
Thanks for this. I almost fell of my chair laughing - when I was a junior DW developer, contracted to a huge bank, I once made the naive comment of "why don't you just add a 'Not Specified' option to your account types, instead of using NULL - SURELY the developers are smart enough to keep the data clean"... Unfortunately the senior developer was in the room and didn't think I was funny, and I was almost escorted out of the building... You have to appreciate the lengths SQL, DW, and ETL developers have to go to, to keep data clean!!! The unsung heroes of the development game!!
Thanks for a great episode. Loved this one!!
Couldn't agree more! How many times do we also get "but you don't look like you're doing anything!" ….
Bert, seriously thank you so much for the time to put together all the content you have in your channel. I’m not a Developer or a DBA, just an analyst who had to learn all this by reverse engineering others code. That approach is great and all but personally leaves me with so many performance questions. I’ve binged you’re channel like Netflix haha but because of that I’ve GREATLY improved the performance of my queries. Just wanted to say thank you and no matter how little a topic may seem to an expert like you, please keep making these tutorials. Even yesterday I used ISNULL to join with on what will be a very large table. 🤦♂️ I’ll be changing that in just a few minutes! Thanks from Texas!
Wow..clever guy..this one item has given me so many sleepless night and in 4 minutes it's over! thanking you
This is exactly what I needed. Thank you. I'm having to left join a third table where the first and second table, also connected earlier on a left join, is null. I think the solution you taught is the solution to what I was struggling with last week!
Is this applicable (adding ISNULL condition) only on tables having composite keys?
I have a question Can candidate key can have null values ?
So, if left outer join and table A has null values and table B also have null values, so from table A also null value will not come right?
Very nice! Clear and concise, exactly the solution I was looking for! Subscribed! :D
Thanks for your video. I already had the coalesce solution but it wasn't going to work for what I need to do. 2nd version looks good
That's a very cool solution. Thanks!
Thanks for the video!
Didn't know Charlie Puth knew SQL
Thanks bro
Bro you look handsome❤YoU