Questions tagged as 'sql'

Tagged questions
0
answers

How to run PostgreSQL on my site

I have a site that is in the server hostgator my bank and PostgreSQL and in the c panel only have mysql they said that to run PostgreSQL I need the vps server inside it under PostgreSQL and I do the integration of the bank with my site! What...
asked by 27.02.2018 / 16:44
0
answers

Error in returning a SQL query with INNER JOIN in PHP, missing elements in the array that receives Query result

I'm having a problem in receiving the result of a query in an array, when I query the database the result I want works perfectly, but at the time of saving in the array in php it returns only one line that is not any of the lines of the query, b...
asked by 26.02.2018 / 17:52
1
answer

Create HTML list with SQL query return

I need to return the SQL query in an HTML list. In the case I need to line up with "affiliate" and "name", the query below, has correctly returned the requested data, but I need now to put this data one after another in an HTML //iniciand...
asked by 03.03.2018 / 05:39
1
answer

Select case with expression and setting the result of the else

I have a problem with a select case, I need to do a select of an expression and if this expression gives a negative result, it shows me the value, if it is positive the value has to be changed to zero, but I can not get ta giving error when chan...
asked by 26.02.2018 / 16:50
1
answer

SQL code does not work wanted an explanation of why the error in the code?

I got these two tables in one exercise, but my code is not working and I wanted to know if anyone could explain it to me. I have to submit all the orders created in the last 10 days. My code: Select id-order, createdDate From Date Whe...
asked by 24.02.2018 / 23:14
2
answers

Search Dates with Difference Defined in SQL Server

How to perform a query on the Microsoft SQL SERVER that a days-ahead set returns only the dates that it encounters with that existing difference. for example In a table have the following dates: 02/01/2018 06/01/2018 08/01/2018 15/01/2018 2...
asked by 23.02.2018 / 04:12
2
answers

I can not see the error (PHP and HTML)

I wanted to show the names of the employees and the teams they are part of so that if the user enters a name, it will filter all the teams that that person is part of. It's coming in white. try{ $pdo = Conexao::getI...
asked by 02.03.2018 / 13:47
0
answers

Knapsack Problem SQL SERVER CTE RECURSIVE

Good afternoon. I am trying to develop a solution within the ERP of the company where I work, in order to identify the possibilities of added FATURES whose TOTAL is equal to or approximate to a value deposited in account. If I do the select...
asked by 06.03.2018 / 17:51
0
answers

Identify and list which users viewed a post Laravel

Good afternoon, for the purposes of studies, I'm creating a system of communications, where users register communications in a timeline, but I came across the following doubt, How would I show which users viewed this release? Announcements are s...
asked by 06.03.2018 / 17:31
1
answer

Retrieve the last value found inside a string

I need to take an average of payment terms in the database and I came across the situation where the condition column is a string and it can receive parcel values separated by slash. I need to get the last value after the last bar, percent sign...
asked by 20.02.2018 / 19:35