Keep it simple :-)
T-SQL: LEFT (RIGHT) JOIN and WHERE clause
AUTHOR
Peter Lalovsky
Canada based bilingual data engineer and data architect with more than 20 years experience in IT, including the last 10 years in Data Engineering and Business Intelligence. Consultant and owner of zPL Concept Inc.
LinkedIn | GitHub
LinkedIn | GitHub
You may also like
We usually mask the credit card number in reports or end user data with asterisk (*). Here I show a scalar-valued function that masks […]
Very often we need to bulk export database objects and move them to another server. Manually we do this by right click […]
Set-based Database Development As database developer, we need to switch our mindsets to “Set-based thinking”. In simple words we need to manipulate […]
Using a multi-value parameters in SSRS reports is giving the users the flexibility to filter on one or more values. In the […]