Questions tagged as 'sql-server'

Tagged questions
1
answer

TALEND UPDATE FILA

Good, I am updating a database from a .txt file, specifically I am updating the following values. With the tmap I make the corresponding relation between the data of the .txt and the attributes of the database and then I do the update i...
asked by 17.03.2016 / 09:26
1
answer

sql server subqueries 2016

It is necessary to know the name of the students whose average grade of programming of the second year is higher than that of the program. Here I enclose my query: select nombre from alumno innner join matricula on (alumno.#a=matricula.#a...
asked by 14.06.2016 / 19:22
0
answers

SQLTableDependency does not work after Restore the Database

Dear I was practicing receiving notifications of changes in the Tables with SQLTableDependency in a testing environment. I did not have any problem, but then when I took the database to a production environment (Backup and then Restore) it did n...
asked by 01.01.2019 / 18:49
2
answers

Reports in SAP Crystal Reports with SQL queries

In SAP B1, you already have a report called "Provisional Balance" by default, and it shows you the initial Balance, Debit, Credit and Current Balance. It's the Next: Well here the question is to generate that same report in SAP Cryst...
asked by 05.04.2017 / 19:14
0
answers

PROBLEM WITH COLLATION (NULL) CREATING A DATABASE SQL SERVER

I am creating a database with the following command: CREATE DATABASE CARGADOR COLLATE SQL_Latin1_General_CP1_CI_AS GO When I execute the following command: select [Collation] = DatabasePropertyEx('CARGADOR','Collation') The result is:...
asked by 28.12.2018 / 04:27
4
answers

Pivoter table in SP Sql Server

I have a case where I have to pivot a temp table that I use in SP, this table must have a format by Number of Month example: My sp executes the following :, but to achieve the above, a pivot is necessary, but I have sincerely trie...
asked by 17.04.2016 / 02:47
1
answer

specify language in localdb

I have a system to which I have created a demo, but I use the dates in the DMY format (Day / Month / Year) which is the default format in Spanish, but when I took the database to local db for the demo was put in English (apparently there is no w...
asked by 20.04.2016 / 19:14
0
answers

Result value indicates how many records you have to return the left join query SQL [closed]

Hello good day I want to ask the following question I want the result value will indicate how many records you have to return the query of the left join I have the query: SELECT * FROM ( SELECT '001' AS CLAVE2, 'MOV1' AS MOV UNION ALL...
asked by 01.12.2018 / 03:44
2
answers

Error in SQL statement with Count Distinct

I'm trying to perform a SQL query to a database to get the number of pieces, for each position-phase and I used the following query: SELECT maquina AS PUESTO, fase AS FASE, COUNT(DISTINCT pieza) AS PIEZAS FROM tabla1 LEFT JOIN tab...
asked by 30.11.2018 / 11:36
1
answer

How to make a sum of the result of a query?

I hope you can support me, I need to make the sum of the result of the wages that I throw the previous query. The result I need would only be $ 17,500     
asked by 29.11.2018 / 08:59