Free for PREMIUM members
select NULL as 'Value'
, 'All dates' as 'Label
Select distinct yourDateField as 'Value'
, CONVERT(nvarchar(12), yourDateField, 103) as 'Label'
Where "apply your selection criteria here"
Open in new window
IF @date is null
Select your report records without a date filter, or to include all desired dates
else if @date is not null
Select your report records with the date parameter in the where clause
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.