Category Archives: T-SQL

OUTER JOIN Filter by WHERE or ON Clauses ?!

If you would like to filter a RIGHT OUTER JOIN, e.g. then you have to put Table_1 columns in ON clause and Table_2 in WHERE clause, e.g. If you swapped it or put all conditions in WHERE clause then it … Continue reading

Posted in Databases, Programming, SQL-Server, T-SQL | Tagged , | Leave a comment

Black Box

We have a black box application (closed code) which sends data to a white box application (open code). The data that had been sent changed, and after investigation I discovered that the data is hard coded inside the application’s code … Continue reading

Posted in Design, Programming, SQL-Server, T-SQL | Tagged , | Leave a comment