I have a problem when putting the query in the body of the email, it is giving me error asking EXISTS in the query how can I solve this.
Follow my code.
DECLARE @p_body as nvarchar(max), @p_subject as nvarchar(max)
DECLARE @p_recipients as...
I have a problem where I need to merge the query return into two tables in a single row.
I thought about using PIVOT but could not because of INNER JOIN .
The query looks like this:
SET LANGUAGE us_english;
SELECT CONVERT(V...
I have in a table the columns:
codigo, cliente, token_md, val, cartcodigo, clientenome, clientesobrenome, clientecpf, clientenascimento
I need to delete exactly 46,550 rows from this table, with no worries of order.
I am a newbie in the database area and I came across a situation that I do not know how to solve. Even looking (at least it seems, rs) simple.
There is the table called dbo.FISICA and another call dbo.MATRICULA , in the dbo.FI...
I am trying to connect a program to the database hosted in SQL Server, but I am having problems ..
When the program runs, the login screen is the first one to appear, and it needs to open the second screen with options to add payments and etc...
I have the (final) code I got on the internet.
In this line of code it gives error in WHERE, since it is a text:
strSQL = " SELECT [VENDAS$].[Data], [VENDAS$].[Vendedor], [VENDAS$].[Total]" & _
" FROM [VENDAS$] WHERE [VENDAS$].[Vendedor] =...
I am trying to perform a query where in one of the columns ( COTA_DIA_ANTERIOR ) returns me the value of the previous day. But it's bringing the value of the day.
SELECT
ET.DT_REFERENCIA
,ET.VL_PU
,(SELECT TOP (1) [DT_REFEREN...
Good afternoon I have 3 questions about a crud I made in my app.
1 I did a field search and it looks like it does not pick up any phone in the j7 line and I wanted to know if anyone can tell me why
2 Crud needs you to put something in Mani...
I'm starting in SQL and I'm having trouble making a query with multiple rows returned. I'm creating a generic twitter clone.
Goal: Return users who are followed by people who
logged in user follows and displays as people he or s...
I have a table in PostgreSQL. I would like to count two columns where one has more record than the other. If I use LEFT OUTER JOIN I think it will work, though, I'm not getting with the PostgreSQL syntax.
The command I am using is as follows:...