Posts by Mauricio Barcelo da Costa • 91 points
10 posts
-
0
votes0
answers23
viewsQ: Consultation of Total General
I am with the need to build a query where I have the following situation Table 1- Sales [1]: https://i.stack.imgur.com/6GOO7.png In this table I have other vendor codes with other values. I am…
-
0
votes0
answers24
viewsQ: Repeat parent group to each child group interaction
I have the following situation. I have a data structure that follows the following hierarchy. 1 Ship has N exporting companies 1 Enterprise exporter owns N export notes 1 Export note has N product…
-
0
votes0
answers33
viewsQ: SQL Server Grouping Conditionally
I have the following problem. I have a relationship between 2 tables (1)Tb_log_relac_nfs and (2)Tb_fat_notafiscal_item. Table 2 is where I write both input and output notes. 1 is one that stores the…
-
0
votes0
answers25
viewsQ: Strange behavior with group concealment
I have a strange situation in my report. It has two groups of lines where the first level is hidden and expands when selected in the second, but in the report view it is not reduced. He’s showing…
-
0
votes1
answer138
viewsQ: SQL - Searching XML data
I have a table in which one of the fields is an XML The XML structure is the Brazilian standard schema of CTE (Electronic Transport Knowledge) <cteProc xmlns="http://www.portalfiscal.inf.br/cte"…
-
1
votes1
answer8375
viewsQ: Use CASE in a WHERE clause
I need to use a condition within a filter parameter in a report. Basically the rule is determined by a vachar field that the value of it is’T' or 'P'. I tried a solution like below but it did not…
-
0
votes0
answers20
viewsQ: Failure to Implement Reporting with Reporting Service
I have a report developed with SQL Data Toosl but when trying to implement it I get the message that the server has not been located, but it is configured in the properties of the report. It follows…
-
4
votes2
answers2954
viewsQ: Search XML field information in SQL
I need to perform a search inside a field where it stores an XML The XML is from a CT-e and in it has a series of tags and I need to find a data within a specific tag. Below the structure of the…
-
2
votes1
answer105
viewsQ: Adding a Character to a column value
I would like to know whether it is possible to include a character set at the end of a column data. For example: 'Coluna 1- Quantidade |10000 |20000 |15000 |20000 I want to extract a query where I…
-
1
votes2
answers89
viewsQ: SQL SERVER - Calculus
I have a question to put together a panel of indicators and I’m not getting out of it. I basically have two tables. Table 1: CONTRACTS Fields: Company ID, Contract ID, Product ID, Quantity Table 2:…