Posts by Renan Bessa • 631 points
67 posts
-
5
votes1
answer1044
viewsQ: How to bring only a certain part of a text in a field
How do I bring only a piece of text into a field in sql server? I have the query below that in the Description column, it returns a text with a lot of information as for example. Nome Cliente Data…
-
0
votes2
answers762
viewsQ: How to put ISNULL in Subselect with case?
How do I return instead Null return as Não. I’m having second thoughts about using the ISNULL within the Subselect along with the case. Upshot: Projeto teste Null Projeto OK Sim. Instead of Null I…
-
1
votes1
answer222
viewsQ: Query SQL returns records only after 2 days prior to today
Guys, as I am new to SQL, I need a help. I need to bring only the records that have not been moving for more than two days. The query below is bringing everyone without this condition. I even ran a…
-
0
votes1
answer60
viewsQ: Not bringing the records - Query SQL
Good afternoon! Guys, below is the query that is to bring the amount of active clients in one column and the amount of locked clients in another column, however, when running the query, comes null…
-
0
votes1
answer494
viewsQ: Doubt - Query (Do not bring a particular record)
Good afternoon Galera! Next, below is a query where it was to bring all the calls that has the description ''Block Client - Delinquent' and with id = 572 (blocked clients), however, this query has…
-
1
votes1
answer706
viewsQ: Split date ranges into weeks
Would have some simple way to extract the weeks given a range of dates, for example: Start date: 01/07/2017 end date: 30/07/2017 Given the above dates how could you automate the extraction of the…
-
0
votes1
answer100
viewsQ: SQL query is not grouping
I’m new in SQL and I’m trying to group the data as query below, however, is not grouping. The correct one was to leave, for example select left(P.ProjDesc,6), COUNT(P.ProjID) from Projetos P where…
-
0
votes1
answer3060
viewsQ: Error - Query: The sub-query returned more than 1 value
I am new to SQL and I have the following error in my query: "The sub-query returned more than 1 value. This is not allowed when the subconsulta follows a =, != , <, <= , >, >= or when it…
-
2
votes2
answers3352
viewsQ: How to fix accentuation query sql server data
Good morning! Guys, how do I correct the accents of the data coming from a select in sql server. For some records that were to come as Sergio, is coming SÃ rgio.
-
3
votes2
answers505
viewsQ: how to specify values to sort sql server
Good afternoon! Guys, I have the following query below, however, I want to order by specifying some records. Attached for example, is the query generated and I want the column Value to look like…
-
0
votes1
answer65
viewsQ: Layout Site Wordpress
Good morning! Guys, I need to develop a site with the layout below in Wordpress. Which theme do you think similar that I should use?…
-
2
votes2
answers1037
viewsQ: Move only part of a text to another column
I have a spreadsheet as an attachment that in the street column is the address and the number, however, I want to separate, ie remove the number of the addresses that are in the street column and…
-
0
votes1
answer1114
viewsQ: How to decrypt records from an SQL column - Query
Good morning! Guys, how to decrypt records from a column in an SQL query. The field I want to decrypt is the coluna MAX(A.Descricao) [Descrição da Última Providência]. SELECT…
-
2
votes3
answers2459
viewsQ: Doubt SQL Working Days Query
Good night! Guys, I need to know a following result. I want to bring the working days grouped by month and year from April to June of this year 2017. Example: Ano Mês Dias Uteis 2017 Abril 19 2017…
-
0
votes3
answers378
viewsQ: Doubt SQL query d
I am wanting to perform the calculation in sql query where the result is the number of open calls divided by the number of working days chosen period. Ex: They were opened 200 calls in the month and…
-
2
votes1
answer1412
viewsQ: Responsive bootstrap menu does not close when clicking
I would like to know why the bootstrap menu on mobile devices does not close when clicking on the menu. It opens normally, but if the user wants to close, it does not close. Access link:…
-
2
votes1
answer1712
viewsQ: Top corner responsive image - Bootstrap
Guys, ask me a question. How to insert a responsive image in the top corner of a section using bootstrap. Ex: this is the site that I am developing renpa.esy.es, however, in the fourth section that…