Questions tagged as 'sql'

Tagged questions
2
answers

Query without repeating sql server

Someone can help me get a query without repeated data by "column", and try the famous DISTINCT but only remove the repeated fields of all the columns that you select, SELECT DISTINCT RUC, BUSINESS NAME , TRADENAME , HOME , TELEPHONE , email, web...
asked by 03.03.2018 / 19:24
0
answers

SSIS error when I want to see the execution report

I get this error when I want to see the job log of an SSIS package.    "Error: failed to convert parameter value from to string to datetime -> string was not recognized as to valid datetime" I enclose the photo with the error. In the p...
asked by 06.03.2018 / 11:42
0
answers

Pass result through a link to another form

I have a doubt that I do not know if it is viable to carry it out. I'm using a plugin for moodle called "configurable report". This plugin allows you to create reports through sql queries that you create yourself. I have been given the case o...
asked by 01.03.2018 / 08:20
1
answer

Problem connecting Yii2 with SQL Server

I'm trying to connect my Yii2 application with a database in SQL Server, the version I'm using is 10.0, this is my error message:    exception 'PDOException' with message 'SQLSTATE [08001]: [Microsoft] [ODBC Driver 11 for SQL Server] Named Pi...
asked by 01.03.2018 / 02:10
1
answer

Problem when executing SQL Server statement

I have a problem executing a statement in SQL Server CREATE TABLE venta ( idVenta INTEGER PRIMARY KEY, Fecha DATE NOT NULL, Cliente_Cedula INTEGER NOT NULL, producto_idProducto INTEGER NOT NULL, empleado_Cedula INTEGER NO...
asked by 28.02.2018 / 01:05
2
answers

organize the months in SQL

I'm running a SQL query to show me the total result for months by selecting the year but when it is executed it shows me the badly organized months and I used the ORDER BY function in DESC and ASC and do not want to organize, here I leave the SQ...
asked by 26.02.2018 / 22:05
1
answer

Problems with MariaDB, slow query

On the server I have two databases. db production and db_test production, the two are the same in fields, tables, relationships, etc, since tests are done with db_test production. The problem arises when I want to make a simple query in PHPMYADM...
asked by 26.02.2018 / 20:36
1
answer

postgresql - how to send a table parameter in a function?

I am using postgresql, I would like to know how to send a table parameter in a function. I have already created the type type_detalle_ac: CREATE TYPE public.type_detalle_ac AS ( id_componente integer, precio numeric(10,2), cantidad integer,...
asked by 02.03.2018 / 15:45
0
answers

Why does data.rows.length return 0 when making an insert in a BD SQLite?

I'm having problems inserting data into a SQlite database on Ionic 2. basically I do not know if it's really inserting me. This is the method of the creation I insert test = "prueba"; initializeDatabase(){ return this.sqlite.creat...
asked by 25.02.2018 / 14:23
0
answers

Connect to Google SQL Cloud from Compute Engine (NodeJS)

I have a NodeJS project and an SQL instance already configured. I'm trying to connect to the BD (running the app) but I can not get it. I'm reading all the tutorials but I can not connect. I have tried with "localhost", with the IP that the S...
asked by 24.02.2018 / 23:52