Questions tagged as 'sql-server-2012'

Tagged questions
0
answers

Impersonalization using BethesdaConsentFormWCFSvc against WindowsServer 2012

My scenario is as follows: I have a virtual machine with Windows Server 2012, I have created a Folder c: \ User1 to which only the administrator has access and User1 / us1.- This machine is in the IP 192.168.0.137 If from my computer I use...
asked by 21.03.2018 / 13:21
0
answers

SSIS error when I want to see the execution report

I get this error when I want to see the job log of an SSIS package.    "Error: failed to convert parameter value from to string to datetime -> string was not recognized as to valid datetime" I enclose the photo with the error. In the p...
asked by 06.03.2018 / 12:42
0
answers

I have the following query case and it gives error

SELECT [DBO].[TBL_CONSUMO_PLANIF].[FEC_DTO] AS FECHA, CASE WHEN [DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE] IN('CRE14QG000', 'CRE14QH000')THEN COUNT([DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE]) ELSE 0 END "CANT_MIC...
asked by 18.01.2018 / 17:25
1
answer

Delete repeated records in a sql server table

I want to delete repeated records from my database and leave only 1, any ideas?     
asked by 12.01.2018 / 22:38
1
answer

Concatenate Time and minutes in SQL server

I have the following query: CONVERT(TIME,convert(varchar,F.T2InHour)+convert(varchar,F.T2InMinute),108) What I want is the following in F.T2InHour I have the Hour and In F.T2InMinute I have the minutes, I want to join them and...
asked by 17.01.2018 / 20:57
1
answer

sql server how to assign a primary key to a table containing data

I have a table that is or is called Invoices which at the time of creation was created without a PK this table already has several records and now I want to add a column with a PK because the records I need from this table I want to make it a un...
asked by 11.01.2018 / 21:13
1
answer

Doubt of how to make multiple inserts

I have a problem when I want to add a rent I want to generate several inserts to the payment table depending on the quantity and I do not know how to do it Example insert into Alquiler values('48265014',1000,1,getdate(),'19/11/2017',300.00...
asked by 20.10.2017 / 00:56
1
answer

Import EXCEL file (xlsl) to Table

What I need is to be able to load the data of an Excel sheet to a table. I already tried with bcp. Also with Bulk Insert and finally enabled: sp_configure 'show advanced options', 1; RECONFIGURE; GO sp_configure 'Ad Hoc Distributed Queries'...
asked by 17.10.2017 / 18:19
0
answers

Access to the DB from a Web Service

I need to access the database from a web service, for which I have several projects within the solution .. the web service, by itself initiates a timer, which executes an action every X seconds. This action is inside a class library (Business) w...
asked by 23.11.2017 / 17:49
0
answers

SQL server, Values of xml

Hello I have a problem I need to make this query, the original is from oracle: SELECT EXTRACTVALUE ( xmltype (v.dsc_val), '/xmlCuentasLiquidacion/cuentasLiquidacion[id_prd="' || p_cod_producto || '"]/cuenta[m...
asked by 31.08.2017 / 16:29