Best answeres tagged with sql

2

answers

How to fix accent query data sql server [closed]

Good morning! Well, how do I perform the correction of data accents from a select in the sql server. For some records that were meant to come as Sergio, Sergio is coming.

asked by 13.07.2017 / 14:20

1

answer

How to return pilot names in SQL table?

I have the following tables below, and would like to return only the name of the riders who have never participated in a race in a Brazilian circuit in the country brasil . Table Structure: PAIS (id, sigla, nome) EQUIPE (id, nome, pa...

asked by 14.07.2017 / 16:22

1

answer

Query rows having maximum value in a column

I have a problem with a query in a Oracle database in a table with 3 columns: ID_Loja | Channel | Sales_Value There is the possibility of having more than one sale per store and I want to know which channel is assigned to...

asked by 21.05.2017 / 23:00

1

answer

CPF Validation - Integration Services

I'm importing a base with CPFs for my DW but I need to do CPF validation within SSIS. Does anyone have any idea how I can do this? Thank you! edit: I was able to solve it the way I wanted it. I used the script component, I got a...

asked by 23.05.2017 / 22:16

1

answer

SQL query with SUM, displaying the return in rows [closed]

So I have a question that is consuming my insides. Could someone please tell me how to return a total of records from a query, via SUM (SQL Server) function, displaying the total of rows proportional to the number of records rather than the valu...

asked by 05.05.2017 / 23:52

1

answer

Error executing Oracle command

Well, good afternoon, I'm having trouble calling a function in Oracle ... The function is this: function mataSessao(){ $connect = oci_connect('xxxx','xxxx','xxxxx','xxxxx'); $IDSESSAO = $_POST['idsessao']; $IDSERIAL = $_POST['id...

asked by 08.05.2017 / 19:50

1

answer

Set up school report

asked by 15.06.2017 / 17:19

3

answers

How to return empty record of a Select?

I'm creating a system in PHP and it has a Script that selects the module data requested by the user. Script creates the form to display and edit the data as per the field information of the tables. The problem I'm facing is that when the r...

asked by 14.06.2017 / 21:07

1

answer

Delphi Add line in SQL error LIST OF BOUNDS (3)

I have a problem adding a line in my SQL LIST OF BOUNDS (3) Delphi : clausulaIn := 'AND A.NNUMEMAPAF IN (0'; while not Q_Mapas.Eof do begin clausulaIn := clausulaIn + ',' + IntToStr(Q_MapasNNUMEMAPAF.AsInteger)...

asked by 28.04.2017 / 16:27

2

answers

SELECT that brings active products in one company and that are not active in all other

I have a table that shows the products that are Active (A) or Inactive (I) in 16 branches. That is, there are 16 rows for each product. I want to select all products that are Active (A) in company 16 and at the same time must be Inactive (I)...

asked by 19.04.2017 / 17:01

Questions tagged as 'sql'