Questions tagged as 'sql-server'

Tagged questions
0
answers

SQL query does not filter by combo

I have a query in sql that according to a combo search by families of the product, work shifts or code of a product, both the code and the work shift if I do the query but by the group or product family no. could you help me I'm a bit new to SQL...
asked by 29.06.2018 / 16:53
0
answers

Get a particular date for each SQL ID

I am trying to get the next available date from a calculation that I show acontinuacion. That's the query I'm using but it does not work. SELECT DateID = ROW_NUMBER() over (order by B.Date_Key) ,C.FundDate FROM DIM_DATE B LEFT JOIN DIM_St...
asked by 25.06.2018 / 19:12
5
answers

insert save all the records of one table in another more date parameter

I want to save all the records that contain a "table A" in another "table B" when pressing submith event "button save current period Currently, my main page already contains 2 forms and I thought that to avoid saturating my tables and edita...
asked by 16.07.2018 / 21:55
0
answers

Show the error when sending a form

I have a very strange case in sql server manager I have been ordered to work on a table that shows all the user fields in an editable form (that each data is a input ) Everything is fine but when I try to add a fifth column...
asked by 09.07.2018 / 19:36
0
answers

Subtracting a next value based on a condition in the same SQL column

I need to create a query that every time I find a value "Sent" in the Status column, then subtract it in the Events column taking into account a next value that is after Sent. Table that I am using: Catalogo Status Eventos ------...
asked by 09.07.2018 / 19:30
0
answers

Range of dates between another range of dates

I have to perform a validation using sql in which a range of dates is not between another range of dates, for example: first validation range: 06-Jul-2018/15-Jul-2018 second rank: 07-Jul-208/12-Jul-2018 third rank: 01-Jul-2018/8-Jul-2018...
asked by 20.06.2018 / 18:22
0
answers

SSIS AUTOMATION ERROR

I'm doing a project with Integration Services which consists of two scrip tasks is certainly very simple, which when executed from the VS data tools 2015 is executed correctly, but when I try to automate it within a job with sql 2017 it thunders...
asked by 23.06.2018 / 00:20
1
answer

How to operate data in pyhon and sql server

My question may be quite simple. I need to make a sum of a column from my database. The problem is that (the way I do it), it brings me the data as rows and not as int. How do I get a data from the database as it is? Example: def prueba():...
asked by 21.06.2018 / 01:54
0
answers

Is there a way to add sql data depending on the GridView row? ASPX and C # with Visual Studio

My idea is to show in a GridView information that I have of tables in my database, as I need to show two Codes of a product, I have to call two SELECT, one for each code. I want the end user to visualize a summary of some sales, in the following...
asked by 22.06.2018 / 18:59
0
answers

Join an sql server query to print a report in c #

I have this table, which the concept name field is the id of another table, but I need to make a query where instead of showing me the id show me the concept name of the other table. select IdFormulacion, NombreConcepto, precio, cant...
asked by 20.06.2018 / 22:57