May 24, 2010 · I have a table (that relates to a number of other tables) where I would like to filter ONE of the columns (RequesterID) - that column will be a combobox where only people that are not sales …

Aside from the dirty feeling I get when doing dynamic SQL, my query is fairly large (I'm selecting a couple dozen fields, joining 5 tables, calling a couple of functions), so it's a big giant string all …

SQL: Filtering a query with multiple conditions Asked 12 years, 3 months ago Modified 12 years, 2 months ago Viewed 32k times

Filter based on an aliased column name Asked 15 years, 10 months ago Modified 7 years, 10 months ago Viewed 30k times

Oct 29, 2010 · I'm making select with a union. SELECT * FROM table_1 UNION SELECT * FROM table_2 Is it possible to filter query results by column values?

Dec 11, 2012 · I have a column in my table for dates (DateTime) and I am trying to create a WHERE clause that says, WHERE dates BETWEEN 12-11-2012 and 12-13-2012 A sample value of dates …

Sep 2, 2017 · SQL Server datetime filter query Asked 8 years, 3 months ago Modified 8 years, 3 months ago Viewed 71k times

Dec 2, 2011 · On SQL Server (2008), if I want to filter a string field that starts with something, what is the best way? Asked 14 years ago Modified 14 years ago Viewed 12k times

I have a relatively simple query joining two tables. The "Where" criteria can be expressed either in the join criteria or as a where clause. I'm wondering which is more efficient. Query is to fi...

Jan 1, 2020 · The second approach is less performant in most RDBMS (SQL Server for sure) due to the conversion (calculation) done on the field itself, which will prevent the database server to use …