Questions tagged as 'sql-server'

Tagged questions
2
answers

HTML5 and SQL Server integration [closed]

Some course or workshop or whatever ... hehe. That you can recommend me for the integration of HTML5 with SQL Server. Let's talk about the fact that with MySQL it is more friendly and / or flexible to link it to HTML5, but if you could guide me...
asked by 14.07.2017 / 19:04
1
answer

Topology optimal sql servers separated by 10000 km

Hello everyone and thanks in advance for your answers. I describe the situation that arises to me. I have 4 bbdd that I have to keep exactly the same between two separate 10000km servers. The size of these together are 200 GB (One of them...
asked by 08.05.2017 / 11:17
3
answers

Query two records in the same SQL Server table

I would like you to resolve this doubt. I want to make a query of a user table, but I want to do it so that I can display two results, since I want to compare the information of two users. When I make a normal query it would be like this:...
asked by 05.07.2017 / 23:43
2
answers

QUERY SQL - Separate String

I am working with some queries and the need has arisen to have to stay with only a part of a field, that is, I have a field that has a final extension similar to this 13123243534.Consumo and at the same time other values in that Same fiel...
asked by 09.08.2017 / 14:52
2
answers

Group Querys in a Stored Procedure SQL

Good morning, I have a problem and I do not know how to solve it, I need to make a report, which I requested certain measurements by MES. What I have is the Query of each measurement, but I do not know how to group all these Querys through an SP...
asked by 11.09.2017 / 15:40
1
answer

How to unify two tables into one?

I am working on a report which should show the information of an item, as well as its locations, the different warehouses and their current stock. Use SQL server with an openquery to get information from BaaN. What I want to do is something s...
asked by 31.03.2016 / 16:45
2
answers

Update my DataGrid in C # without using buttons

I tell you I am trying to update my datagrid without the need to give any button. This datagrid is filled by making calls to a database. It had occurred to me to use threads for in the background to update the calls every so often as if it were...
asked by 20.03.2018 / 20:26
3
answers

Take the max out of a column according to the max of another SQL server

Good I have a query where I have to make a select that gives me the maximum of one column depending on the maximum of another, I explain myself better with the following example my table would be like this: |nrocon|ordren|ordamp| | 1 |...
asked by 11.04.2018 / 20:43
1
answer

Sql Server Pivot Dinamica

I have a problem and it is not resolved I have a table with this structure. The two fields are string. Example Articulo Año aaa 2003 bbb 2003 aaa 2004 bbb 2004 ccc 2004 aaa 2005 ccc...
asked by 17.01.2018 / 17:17
1
answer

C # Does not execute stored procedure + trigger

Friends how are you! I have a stored procedure that inserts records in a table, which I run from a WinForms application, I was making some modifications and I added a Trigger to the table to which the procedure inserts the data. But alread...
asked by 14.06.2018 / 16:22