Hello
I'm having a demand where for a certain reason, XML was generated with the order of the tags exchanged ...: (
Scenario: I have a column in the SQL Server database (from the 2008 release) that contains NF-e XML saved from a Windows app...
I have a code that aims to return open invoices from a customer in a specific time period. But I want to add a field that displays the total number of invoices, regardless of the debit period.
The code looks like this:
SELECT
fatura.num...
I have a problem with a report from Pentaho, prd. It does not generate the PDF report because of the amount of special characters. I wanted a way in the sqlserver to remove the characters without losing the formatting of the text. Because the te...
I'd like a suggestion to improve the performance of these methods. It has taken them too long to finish.
Please if the question is not very clear just to mention that I try to improve I will make some images available with the codes. https://i.s...
I have two tables: col (contributor) and Indicacao .
I made select to know how many leads each employee has. It is working but I can not filter by date using between .
SELECT c.id, c.nome, funcao, area, count(p.cpf...
I have columns that were written to the sql server with a capital letter, when I get it in php, I need them to recognize both lowercase and uppercase.
For example:
select * from rzv_aluno
records:
AL_NOME, AL_EMPRESA... etc
In php I...
I developed a page in PHP for internal use of the company I work with and only very few people use it. You can use this page to do some queries, insertions, changes and deletions of a table in a MySQL database, however I believe that my PHP code...
I would like to know how to update a select with data coming from another.
I currently use SQL, I already have a connection created:
$connection = new COM("ADODB.Connection"); //instancia a classe de conexao
$connection->Open("PRO...