Questions tagged as 'sql'

Tagged questions
0
answers

Images saved in the DB and in the project root folder do not appear on the site

I'm working on a website, using php language in netBeans and easyphp p bank. the site registers companies and services and it is also possible to search by name the same. (this is in the process of development) clicking the image looks like t...
asked by 06.04.2017 / 10:47
0
answers

database vendor code: 521

I am not able to run these queries in sql 2008 I took the test in 2014 and it worked could someone help me? I'm too close to the bridge to find a solution. Follow the query: SELECT D1_COD, D1_FORNECE, A2_NOME, --1ª COMPRAS-- MIN(COMPRAS.D1_...
asked by 18.04.2017 / 19:57
1
answer

Adding decimal values mysql

I made a query that adds a decimal field, but I'm having a problem, because when I put the group by t1.id_sell clause it lists the sales but no longer adds correctly and without the correct sum clause but only returns one line. query:...
asked by 30.03.2017 / 18:09
2
answers

SQL Query VBA Excel

Good afternoon! I have a problem with an Access query via form. The form is from the Excel vba, which connects to the database. The full code is below. This is the button code. Clicking it validates which of the two buttons is marked...
asked by 28.03.2017 / 16:58
1
answer

Media Calculation between SQL Selects

Good afternoon. Please help me    Syntax error   Msg 102, Level 15, State 1, Line 2087   Incorrect syntax near 'TAB'. --TARIFAS --Calcular Média Tarifada BEGIN TRY DROP TABLE #TARIFASINDMETRO END TRY BEGIN CATCH END CATCH SELECT...
asked by 27.03.2017 / 21:56
0
answers

Query Return on Sql Server

I need to build a proc that performs two selects. The first one will return 1 or more information from one column (chassis number for example) and with this result I need to make another query reporting one chassis at a time. For example,...
asked by 27.03.2017 / 21:52
1
answer

Left join returning only certain fields [duplicate]

I have the following tables: tb_agenda date tb_patient patient_id patient_name tb_medico Medical_id Medical_name tb_agendamento
asked by 27.03.2017 / 23:44
1
answer

Dynamic Combobox Information Filter

I would like to know how to do a dynamic data filter, so only the data related to the selected one appears, for example: I have in my bank the table Empregado and Empresa , as an example I have: Employee 1 (fk_company 1), Work...
asked by 28.03.2017 / 15:12
1
answer

Join select to total results

Howtototalthestoredquantityoftheseproductstobeabletocomparewiththetotalorderquantityforresale"QTD REQUEST". How can I do to find the total stored and join the result? Select: SELECT ipv.ProdCodEstr 'CÓDIGO DO PRODUTO',...
asked by 28.03.2017 / 15:43
1
answer

Clause of SQL upty with Codigniter

Good morning guys, I need to do an update in the database but I'm not getting the codes below: I'm using codeigniter so it looks like this: Controller: function editar($ocod) { /* Aqui vamos definir o título da página de edição *...
asked by 02.05.2017 / 11:30