Questions tagged as 'sql-server-2014'

Tagged questions
1
answer

Concatenation of Records via FOR XML PATH - SQL SERVER

Good afternoon dear, I have the following problem: I'm developing a Query where I need to check which documents have been delivered by the student, these documents that are in the pre_matricula_doc table and have the following structure:...
asked by 11.12.2018 / 19:27
1
answer

Assign a cursor value to a table column

I have a cursor. I need in an insert to insert the value of each cursor position to a table. How do I do this? I need to insert the value of the exame_cur cursor. My code below: set nocount on declare @id_xfc int, @id_exm_rea int, @id_...
asked by 24.04.2017 / 17:44
0
answers

Scheduling form with several items that need to be rented at the same time

I need to make an appointment book: Scheduling information Sign multiple instruments at once with scheduling information The Buscar cliente button pulls the data (Customer ID and Name) from a customer master table, as well...
asked by 25.10.2016 / 14:38
0
answers

Mobile Report - Reporting Services 2016

This is my first post in the community and I hope to be able to collaborate with my question. I'm working on a BI project where I need to show a quantity of calls on a map, according to the models that exist ready, it's possible to use a colu...
asked by 07.10.2016 / 19:27
4
answers

SQL - Sorting Random Lines

Given the table as an example: I want to sort, between the lines with the same order number, a single line, that is, one of order 1, one of order 2 and one of order 3, randomly. I need a generic solution, which applies to a table with...
asked by 27.07.2017 / 15:53
1
answer

Generate bank script with structure and data

Backup is no way to do, because it depends on the permission of France and so on. So the solution we found here was to try to generate a script that copies not only the structure of the tables, this I already do and did, but type an INSERT loadi...
asked by 27.04.2017 / 23:09
1
answer

Subtraction between two fields of same value does not give zero- SQL Server

Someone could explain me: I made a join between two tables. Both bring the same value in their fields. And when I subtract one value minus the other, it does not give zero. How is this possible? E1_SALDO = 990,42 BAIXZ0 = 990,42 SUBTRACA...
asked by 09.10.2018 / 15:13
1
answer

Create a Table-Relationship (N: N) that relates to a Table-Normal and another Table-Relationship (N: N) in SQL Server 2014 Management Studio

I'm trying to create this SQL Server Data Script, but when I run the following error message occurs:    Msg 1776, Level 16, State 0, Line 161 There are no primary keys or   candidates in the reference table 'tblSupplierInsumo' which   corresp...
asked by 20.01.2018 / 23:40
1
answer

Bulk insert into a table

I have two proc's that my system in VB already uses. One for Insert and one for Update. I need to use it right now, right in the bank. The target table has a composite key as follows. A field named ID_OIT_LET and another field called ID_OIT. ID_...
asked by 20.04.2017 / 14:18
1
answer

Popular table in sql server with data coming from an excel spreadsheet

How do I create a script or via DTS , a way to populate a table in sql server 2014 , with information coming from a excel worksheet? The spreadsheet has several columns, but only two columns will be populated, and two other co...
asked by 18.04.2017 / 19:47