Good morning,
I need to know a% change from last month's job records to job records made this month. For this I need to compare with the current day, for example.
If today was 10/15/2015
I need to count how many tasks were opened between 0...
I'm working on a tuning of a SQL Server database.
Through the query below, I can see how the bank ran some of my heaviest queries.
SELECT TOP 30 deqt.TEXT AS Query,
last_execution_time
FROM sys.dm_exec_query_stats deqs
C...
I have the following SQL, generated by Entity Framework 6.
SELECT
[Project1].[C1] AS [C1],
[Project1].[ID] AS [ID],
[Project1].[CAMPO1] AS [CAMPO1],
[Project1].[CAMPO2] AS [CAMPO2],
[Project1].[CAMPO3] AS [CAMPO3],...
DBMS: SQL Server 2014;
Problem: I need to know which records are duplicated, so that the verification is done in two simultaneous fields, ie if the field "CPF" with the value '83971465842' and the field 'MAT' with the value ' 001 'exists, in...
I created a record with a 58 data.
As I was creating, I was testing and the data was entering the DB, and every time an insert was made, I get the id of the last set / data group entered.
But if I "refresh on the page" when I am go...
Considering the following executed command
BEGIN TRY
-- Generate a divide-by-zero error.
SELECT 1/0;
END TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() AS ErrorNumber
,ERROR_SEVERITY() AS ErrorSeverity...
I'm creating an application that needs to connect to 2 different databases. A database I'm creating (MySQL) and a database I got ready that I have permission to query only (SQL Server). The purpose of the application is to query the data of the...
I'm having problems trying to install MediaWiki using Sql Server.
The following error occurs:
[SQLSTATE 42000] [Error Code 2760] [Microsoft] [SQL Server Native Client 11.0] [SQL Server] The specified schema name "dbo" does not exist or...
How can I do to create a script in SQL where a SELECT runs, and according to the result of a column of this first, a certain condition of another table?
example:
select * from tabela as t
SE t.saldo = 0 entao WHERE t2.outracondicao =...
Does anyone have a query in sql server that returns how many days are missing for a date?
I have the employee's date of admission, I need to know, how many days to complete 45 days, and how many days to complete 90 days.