I'm using SQL 2008 to query using inner join:
SELECT t2.intencion_id,t2.numpago,t3.orden,t2.importe
,SUM([importeaplicado]) AS importeaplicado
,t3.intfinanciamiento_interes
,t1.[estatus] FROM [APLICACIONES] as t1
inner join movcargos as...
Hi, I am currently doing a query but I think that the number of working hours has blocked me.
I try to show the id of a joint user with his first and last name, and to all this he shows how many prospects (clients) he has assigned.
My user...
I am trying to connect with java 7 to sql server 2014 and I get the following error:
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete...
I want to put a horizontal line to separate data when viewing in a DGV in php, I use an 'echo' along with a '' to create the table, but I want to separate it by lines the records within the echo when creating the table, attach the code so far...
I have a stored procedure in which I add a query to a variable (by topic of dynamic tables). The problem is that when you enter a date and the table does not exist, the PRC falls. That's why I need to handle mistakes and I can not do it and I wa...
How can I make a sql query where I select the maximum value of the folio column plus one, taking into account that the table may be empty the first time it is used, I have the following query but I think it is missing more.
the query to get t...
I have created a sql statement that traverses a string and generates columns with data.
CODE:
select p.FK_workitem,
p.numero_sd,
p.PARRAFO,
LTRIM(substring(p.PARRAFO, 0, CHARINDEX(':', p.PARRAFO))) Tipo,...
On a SQL server 2012 I have to do a massive update (record by record) of a column A in table X based on the value that same column has in table Y. The key is a serial number, How can I do this?
I have a query in SQL server:
SELECT [nIdLogTG]
,[nUsuario]
,[nConsDetalle]
,[nConsDoOrigen]
,(case when a.cCodigoComplementarioDo IS NULL THEN b.cCodigoComplementarioDo
ELSE a.cCodigoComplementarioDo END) AS Cod...
I have a column of a table located on a Linked Server (from Oracle) that exceeds the varchar (Max) of a column in a SQl Server table. I need to cut the values to the Max of the column in order to pass the data through a SQL Server Job. This is t...