Conditional WHERE Clauses and Boolean Algebra
Utilize simple boolean algebra and nullable parameters to implement conditional WHERE clauses without dynamic SQL.
2010-08-31
17,821 reads
Tony Alicea
Blogs
Function Vs. Performance
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that...
Daily Coping 3 Oct 2022
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
Scary Scalar Functions - Part Four: Your Environment
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
Forums
SQL Server Licensing Question
I'm in the process of replacing a sql server 2012 with 2019. How do...
SSRS Reporting
Anyone can give me a sample program on how to pass parameters from SSRS...
How to show currency symbol in column header
In our reports we display the currency ($) symbol in the column header for...
Ask SSC