Questions tagged as 'sql'

Tagged questions
1
answer

Elinimar Data of Several SQL Tables

I'm trying to delete the records of my DB but only the first 2 tables are deleted, nothing happens in the third one. DELETE cliente, historia, descripcion FROM cliente INNER JOIN historia ON historia.idCliente = c...
asked by 17.08.2018 / 19:52
0
answers

Problems with EF in the following code

I have a method which is called in the constructor of my controller Home in the created roles when starting the application and assigned a specific role to a user, it happens that I do not create any record in the db, in addition to debug the co...
asked by 17.08.2018 / 21:53
1
answer

Generate PDF WITH SSRD

My doubt is that I have generated a group of 40 rows but the tablix still only generates 14, what I want is for the detail to be shown without repeating the header What I want to do is that the image 2 no longer appears but the detail is show...
asked by 15.08.2018 / 03:01
0
answers

Codeigniter - expression # 1 of SELECT list contains nonaggregated column

I've done everything and still keeps sending me the error $this->db->distinct(); $this->db->select('s.id, COALESCE(SUM(sd.cajas),0) as cajas, COALESCE(SUM(sd.peso),0) as peso, c.nombre'); $this->db->fr...
asked by 16.08.2018 / 02:54
2
answers

Check following record BD (Vb.Net)

I expose my doubt, I have a Vb.net application, in which a label marks a condition of 1 or 2, if it is 1, I insert a record in a field of a BD that has a busy field = 0, but if it is 2, I need you to look for two contiguous fields with the occup...
asked by 16.08.2018 / 13:11
1
answer

How to assign different functions to different types of users?

I am creating a platform for students and teachers, and each one has different functions in their profile. When they are registered, each one in my database is automatically assigned a 1 or a 2, depending on what type of user it is.    1 = T...
asked by 13.08.2018 / 20:56
1
answer

format for numbers with many SQL characters

Hi, I am working with ORACLE 11g, making a query to the table through sqlplus, then I save the result of the query in a log. The problem is that there are two fields that return an amount of sum and have many characters so they do not look like...
asked by 14.08.2018 / 19:33
0
answers

help with the run time problem in a query statement Dapper c #

That such friends I am working an application with c # using the orm dapper. in case it is that in certain occasions I keep a certain number of records in a single execution, approximately 400 records. the problem is that sometimes, I throw an e...
asked by 17.08.2018 / 03:58
2
answers

Update to several records

   I want to update all the records of a table (tbl_DepresacionesUmas) where the status is different to low but when doing that, it returns more than one value and generates an error, how can I solve that in sql? Update Tbl_DepresacionesU...
asked by 14.08.2018 / 21:49
1
answer

help with sql query for report

I have to prepare a report in crystal report, showing the key, client, client name, credit amount and loan date fields. at the moment of executing what I already have, it throws me an error in the "fill of data" I assume that the query is wrong,...
asked by 15.08.2018 / 01:47