Questions tagged as 'sql-server'

Tagged questions
1
answer

insert time type data in sql server

I'm making a data set for an application, and when I insert a Time record, it gives me the following error: INSERT INTO [ope_prodqa_dev] ( staff, turn, date_prodqa, hour_dev ) VALUES ( 1, 4...
asked by 19.06.2018 / 10:21
0
answers

Unable to modify the classes.php file in the symfony cache

Hello, please, I need your help: I have installed IIS and PHP 5.4 and I have a system developed in symfony2, the iis and php work well and I even have the pdo_sqlsrv enabled for connection between php and sql server 2014 everything seems to w...
asked by 15.06.2018 / 21:03
0
answers

Model database query

I write to make a query or guidance on a MER referring to an inventory system. I have two entities: Equipo ------------------- Usuario According to my requirements, I need to generate a many-to-many relationship, which is why I am gener...
asked by 14.06.2018 / 00:10
0
answers

Union select with the same ids

I have two tables to which one in a query by selecting the "ID" and "NAME" from C #, I show it in a combobox, but some IDS are repeated, and when I select a name in the combo I select the first How can I solve this? select campo1, campo2 from...
asked by 09.06.2018 / 02:00
0
answers

Because the database engine does not allow me to add try / catch to my porceement

I need to add try/catch to the procedure and I get some errors, this is my stored procedure CREATE PROCEDURE perfilCur @opcion INT AS SET NOCOUNT ON; BEGIN TRY IF @opcion = 1 BEGIN SELECT TOP 1 (PERFIL) + 1 AS NuevoPerf...
asked by 13.06.2018 / 19:35
1
answer

help with SQL Server installation!

Hello, whenever I try to install sql server on my laptop I get the following error help please!     
asked by 04.06.2018 / 18:27
0
answers

Help with my project

I am creating a quote system with SQLSrv, I already have the part to see the quotes. link I have created the part of invoice , which is where you see the quotes made. link My Problem is this, I can not make the part to create the...
asked by 06.06.2018 / 06:16
0
answers

import query with sql pivot to excel

I have a query in sql with pivot that returns the dates in columns, I want to make that query empty in an excel sheet to be able to do operations but for some reason excel it does not matter the data can guide me and more than anything know if p...
asked by 08.06.2018 / 03:31
1
answer

Place the value of one column in another column of different rows

I need to create a select where it is placed in value of one column in another column which belong to different rows, using the criteria of the type column. In other words, place the value of column_one in column_dos when type is = 'B'. Type...
asked by 01.06.2018 / 01:35
2
answers

Make a Max a subquery

I have a problem, since I have a table which has the fields of VAT, price, productname, date, what I want is to obtain the maximum, as of a date, and I do it, but now I need that After obtaining the maximum price, check if the VAT is 0 or 1, if...
asked by 30.05.2018 / 20:33