Skip to content

Instantly share code, notes, and snippets.

@dnasca

dnasca/DateRange2.sql

Created April 28, 2015 22:43
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dnasca/8458b26121ce6b7ff4a2 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dnasca/8458b26121ce6b7ff4a2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DateRange2.sql
exec ('
SELECT DISTINCT ' +
@SearchField + ' FROM SchemaAudit WHERE StartDate >= "'
+ CAST(@DateFrom as varchar(20))
+ '" AND EndDate >= "'
+ CAST(@DateTo as varchar(20))
+ '"
ORDER BY ' + @SearchField +' ASC')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment