What is the most efficient way to calculate the average of dates in the same column by sqlserver bank? I need to get the date of the last 3 sales of a customer, and return in days to know if that customer buys, for example, every 30 days, 60 in...
I have ADOConnection , a ADODataSet , DataSource , ADOQuery , a DBGrid and a DBEdit .
The DBEdit is with the DataField = numero property.
A button with the test:
AdoQuery1.close;
AdoQuery1....
I need help solving an incompatibility problem.
The company I'm working on is migrating from a SQL Server 2008 to 2012 Bank, but we've identified some issues.
The main one is the declaration of (NOLOCK) without WITH in VIEWs, FU...
I have a problem with the SQLSERVER database.
I try to connect from a point to the server and the error appears:
Network-specific or instance-specific error when connecting to
SQL Server. The server was not found or was not accessible...
Good morning!
Is there a way to create a query that brings the "product" and all "Components and Subcomponents" of the structure of this product?
Let me try to explain better
Structure
Image
LinktoImage: link
Text format...
How do I perform an update at the same time on two different tables?
I have a table named Tarefa and another called VinculoReferencia , both have the field Taridinclusao where is this field that needs to be updated at th...
I'm having problems when I select a date column in SQL Server. It turns out that my data is in the dd/mm/aaaa format and when I select that column the SQL inverts getting aaaa-dd-mm and in fact it would have to be aaaa-mm-dd...
In the query below the following error occurred:
Converting a varchar data type to a smalldatetime data type resulted in a value out of range.
By analyzing, I realized that if I take out the dbo.FN_CALC_HORAS_UTEIS function, it...
How can I put a mask in an HTML form in the date and monetary value fields, then send that data to the database without having to convert the strings to types date and money ?
I explain:
I have a form with date mask in DD/M...
Everyone, good afternoon! I'm having trouble with the query below. I want you to bring all the tasks only when the maturity (field) of them is equal to the month after the opening date (tardata). However, nothing came up in the query.
select *...