I need to check the number of notes issued with template 55 to create a report.
The problem is that I'm having to put zero values in the quantity column even though they have no value at all.
Ex:
empresa filial data quantidade
5...
People, I have a table in SQL with the following columns "pv, product, values".
Currently I have a registration form, where the person inserts these values and he goes to this table with id auto increment.
But I need to generate a control...
The string fields of the tables in my database are coming with fixed length as true.
So if the size is 60, and I saved a string with size of 30, it fills the string with spaces up to the full size. If it is in edmx and set manually to false it w...
The query runs fine sqldeveloper but when calling via .bat does not recognize commands like ( case, nvl,sum )
Has anyone gone through this?
'C: \ oracle \ app \ oracle \ product \ 11.2.0 \ server \ bin \ sqlplus.EXE @C: \ V1.sql'...
Hello, I'm new to sql and need help:
I have the following columns:
Usuário | Ranking | Posição
Fulano 300 1
Ciclano 400 2
Beltrano 500 3
I wanted to know how to put this position 1 2 3 ... without being...
I'm trying to display data from a table in my SQL Server database using PHP, but I'm not getting it.
The code does not error but also returns nothing.
The code is this here:
<?php
$serverName = "MIRCIA-PC\PRIMAVERA";
$resultadoectionInfo...
I am having difficulty connecting twice to my database, each time I connect to a table
the code and the following:
Categories
<!-- Portfolio Grid -->
<section class="bg-light" id="portfolio">
<div class="container...
I have an SQL table with Continents, Countries, Regions, Cities.
Continents have parentID = 0 , countries have parentID = continentID , regions have parentID=countryID and cities have parentID=regiaoID , continentI...
Good morning,
I need to get a report that is not made available by the system, working with the invoices table. In this table there is the data of the customer, consumer unit and the value of the flow. It turns out that a customer can have more...