- 1. T-SQL example of Case-Sensitive Soundex
- / Transact-SQL /
- ... values. Additional Note how this also picked up typos in the 4th value which is good as I didn't want to overcomplicate things using LEVENSHTEIN and DIFFERENCE: SOUNDEX('Data Not Yet Available') ...
- Created on 10 October 2012
- 2. Basic Oracle Function Structure
- / Oracle PL/SQL /
- What? I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function ...
- Created on 15 January 2012
- 3. SSRS Hide results table if empty
- / SQL Server Reporting Services /
- ... which just overcomplicates basic simple select queries... However set a counter to 1 for each and then get BIDS to do the sum of this using an MDX expression. T-SQL Expression: Consider the following ...
- Created on 29 March 2011