Questions tagged as 'sql'

Tagged questions
2
answers

LEFT JOIN SUBQUERY

Hello, I have a small question about SQL since I do not understand anything about it. I have a table where I am doing a select to see the updates with a subquery and I make a LEFT JOIN where the code is: SELECT a.id, a.nome, (SELECT COUNT(c.id)...
asked by 04.07.2018 / 16:33
0
answers

Sql Reporting Services: Two WebPortal URLs

I'm trying to parameterize another URL to use Reporting Services but the following happens. I add the URL below: TheoriginalURLparameterizedintheinstallationworksperfectly: Icanaccessnormally ButwhenItrytoaccessthenewonetheerrorbelowappears...
asked by 04.07.2018 / 16:42
1
answer

SQL Bank Log in Restoring Pending

I have a SQL database that was accessed by someone else and it went into "Restoring Pending" as soon as they accessed it. Is there any way to extract some log or any other more detailed way of knowing how, who and when it was done?     
asked by 03.07.2018 / 15:46
0
answers

Problems with SQLiteHelper

Hello, I have a SQLiteHelper project and I'm having trouble reading SQLiteHelper, the app only runs without it, when I try to use it it gives an error, the application hangs, if anyone can help me find where the error is, thank you.  follow the...
asked by 03.07.2018 / 07:00
1
answer

Catch only the values that are different in the query

I made a query that brings the values of credit and debit, but I need to bring only the values that are different from these two fields. At the moment I do not know why he is bringing everyone. Look at the image: OBS IS IN SQL SERVER sq...
asked by 02.07.2018 / 15:31
0
answers

Value accumulated day by day - Firebird

I'm starting now in the programming area, I'm having a hard time with SELECT which brings the accumulated value day by day of sales, I need this SELECT to play it on the line of a graph indicating the cumulative sales value of the...
asked by 05.07.2018 / 17:54
0
answers

Postgis - Invalid Geometries in Cutouts

Objective: To calculate the area of shp1 that intersects (st_intersection) with shp2 in continental proportion. The shp1 and shp2 are present information for the Brazilian biome of the whole Cerrado, that is, they are relatively large. shp...
asked by 05.07.2018 / 17:28
0
answers

error to the application in the homolog

Good morning, I'm having a problem with the homolog version of the project The index 'IX_ReqCompraId_Id' is dependent on column 'ReqCompraId'. The object 'FK_dbo.Pedidos_dbo.ReqCompra_ReqCompraId' is dependent on column 'ReqCompraId'. The o...
asked by 26.06.2018 / 15:36
0
answers

Master Record Missing

Working with Delphi development and the sql database, and recently I had to delete two menus created using sql tables, but the following error appears when trying to delete them:    "Master record Missing. Delete statement conflited with colu...
asked by 26.06.2018 / 14:14
0
answers

What causes "max_input_var"? [duplicate]

Good evening, I was updating the bd of my project when suddenly: Afterthiswarningstartedappearing,Icannolongerupdatesomeitemsinsertedinthetable.IwouldliketoknowwhatiscausingthiserrorandwhatIcandotosolveit,Ialreadytriedtochangethe"php.ini" but...
asked by 27.06.2018 / 07:37