How to group a table T-SQL
How to group table below to receive this result.
How to group a table T-SQL
How to group table below to receive this result.
Find if any row parameter value was equal to 1 in period of time
I have a problem constructing a query.
SQL Server pivoting on data without an aggregate
I know there are lots of existing questions about pivots, but I’m struggling to understand what I’m doing wrong.
SQL Server pivoting on data without an aggregate
I know there are lots of existing questions about pivots, but I’m struggling to understand what I’m doing wrong.
Improve performance of WHERE clause
I have a query in T-SQL (for SQL Server 2012) that works, but this clause in WHERE is causing the query to run really slow. The rest of the query is very simple (I have tested it without having this clause and it is fast without it but we need it):
Improve performance of WHERE clause
I have a query in T-SQL (for SQL Server 2012) that works, but this clause in WHERE is causing the query to run really slow. The rest of the query is very simple (I have tested it without having this clause and it is fast without it but we need it):
Substitute EXISTS in WHERE to a TEMP Table
I have a query in T-SQL 2012 (sql server) that works but this clause in WHERE is causing query running really slow. The rest of the query is very simple (I have tested it without having this clause and it is fast without it but we need it):
Is it possible to specify condition in Count()?
Is it possible to specify a condition in Count()? I would like to count only the rows that have, for example, “Manager” in the Position column.
Is it possible to specify condition in Count()?
Is it possible to specify a condition in Count()? I would like to count only the rows that have, for example, “Manager” in the Position column.