Questions tagged as 'sql'

Tagged questions
0
answers

Query does not return SQL Server result

I have a problem with the following query in an sp, before it was executed and I returned the value, now it just throws me Commands completed correctly. and not the The result of the query strong> I share the query: BEGIN --INICIO S...
asked by 11.12.2018 / 17:20
1
answer

ASP add column data

I have a table where a column shows me the different percentages obtained from the monthly assistance, but I want to obtain my annual attendance in percentage, that is to add all the percentages that I have been carrying so far <div class="...
asked by 19.12.2018 / 18:40
1
answer

Remove remaining decimals in TD

<div class="row-fluid"> <div class="span12"style="overflow-y:auto;"> <h1 class="text-center" style="margin-bottom:1em;"><strong>Porcentaje Personal Capacitado</strong></h1> <table id="lista" class="t...
asked by 19.12.2018 / 16:26
2
answers

how to include database in the C # project and use it locally?

I have a system in C # for inventories that uses Sql server is already finished, but now if I want to sell or install it on another computer I would have to install sql server Express to the client and that does not fit me, as you do if you Are...
asked by 17.12.2018 / 23:30
2
answers

Voucher count showing all months

I have a voucher count that is already done and I get bounced by date, now the problem that I want to show all the months of the year, could help me in this function that my head is flying. that friends advise me example: name | mov | January...
asked by 07.12.2018 / 15:49
0
answers

because the data sent from the query is not captured

I have this query SELECT ID_ESTRUC_PRESUP, AN_FISCAL, CO_PROY_INST, CO_ACC_INST, CO_UNIDAD, CO_PROY_OPER, CO_ACC_OPER, CO_FUENTE, CO_GASTO, CO_GENERO, CO_CONDICION, CO_CUENTA_PRESUP, CO_SNC, $co_mes FROM sialuz5db.dbo.VW_SAL...
asked by 13.12.2018 / 18:30
1
answer

Problem Regular expression

Good I need to take a number of some text string and I can not get the regular expression that I need here the example.    Hello, such # 4702665       Welcome 45454545 tal # 470815 BD. WA470815 I need only these numbers: # 470815 #...
asked by 05.12.2018 / 17:38
2
answers

display the data of a multiple SQL query

I have this code that is perfect and everything, but my question is, how would you do to show the data? I mean when I make a simple query, it's enough for me to write: **while($datosx = mysqli_fetch_array($consulta)){ echo $datosx["fila de la...
asked by 07.12.2018 / 02:46
0
answers

Problem with button Confirm Purchase of my cart

Again I ask a question that I have already asked but in a different way, to see if that is how I explain myself better. I have made a cart in constant communication with my database (When the user selects a product it is inserted in a table "ite...
asked by 03.12.2018 / 17:10
3
answers

Problem with date in SQL

My BD manager is postgres. I am simply trying to get a result based on a specific date or a range of dates. I have this table: create table detalle_ventas ( fecha_venta varchar(100) not null, codigo_barra int not null, descripcion varchar(...
asked by 03.12.2018 / 15:09