Posts by Bruno Souza • 151 points
14 posts
-
1
votes1
answer85
viewsA: Find duplicate values - Excel
I solved using matrix function: {=SEERRO(ÍNDICE($A$1:$C$1;;MENOR(SE((COL($A$2:$C$5)-COL($A$2)+1)*($A$2:$C$5=$F$2)=0;99;(COL($A$2:$C$5)-COL($A$2)+1)*($A$2:$C$5=$F$2));COL(B1)));"")}…
-
0
votes1
answer85
viewsQ: Find duplicate values - Excel
How to return a company based on a value, even if the Matrix has several duplicates. You can return the first found.…
-
1
votes1
answer235
viewsQ: C# - Subselect in Lambda and Linq
How to mount the query below in Lambda and/or Linq? select emp.cd_empresa AS ID, emp.nm_razao_social + ' (' + emp.nm_fantasia + ')' AS EMPRESA, (SELECT COUNT(con.cd_consulta) from…
-
3
votes1
answer128
viewsQ: How to compare two lists by property?
I have two student lists. I would like to compare them by the attribute Name, and return only the unique values of the student. In the example below, return only Aluno01.Name = "5555".…
-
0
votes0
answers40
viewsQ: Pass parameter to new MVC controller
I need to pass parameter "01" of http://localhost:5934/Gestaodeservicos/Catalogo/Cadastro/01, to another controller. namespace Intranet.Presentation.Areas.GestaoDeServicos.Controllers { public class…
-
5
votes2
answers172
viewsQ: SQL SERVER - Convert String in Days
How can I convert this string in days? Example: return "2 days and 2 hrs"? SELECT '50:00:00'
-
0
votes1
answer500
viewsQ: Clear input - ng-model - change
I own a md-select where according to the selected, I create some div’s using ng-if. These div’s created have in 02 of them equal models (ng-model). Therefore, when you change Md-select to another…
-
1
votes1
answer1776
viewsQ: C# - Remove QUOTES - Replace - Remove ASP Doubles
I have a variable (TEXT) that is a string, where its value is: "22/06/2018 00:00:00" How to make an Replace by removing its quotes?
-
0
votes1
answer91
viewsQ: C# - Asqueryable - Condition (Linq - Lambda)
In this method, I populate my 'rule' variable with all rules coming from Select, however, I would like to filter only Status = True. How to do this? public async…
-
0
votes2
answers173
viewsA: C# - Filter Include - Context
I resolved it as follows. I avoided the use of third party libraries. It was not the best way, I believe there are other more effective. I will be in search and return if I find simpler solution!…
-
0
votes2
answers173
viewsQ: C# - Filter Include - Context
In the method below, I return some records of my entity Consultintramexrules, where it has relation with the . INCLUDE ("Emails and Parameters"). Aware that EF does not allow filtering in . INCLUDE,…
-
1
votes2
answers112
viewsQ: How to run a subconsultation on LINQ C#?
How to run a subconsultation on LINQ C#? SELECT ap.ID FROM Aplicativo AP WHERE AP.Tipo IN (2,6) AND AP.ID NOT IN (SELECT filhoID FROM relacoesobjeto WHERE filhoclasse = 555)…
-
0
votes1
answer216
viewsQ: Angular - ng-Pattern - Hours
In the code below I need to make ng-Pattern receive 1 or two numbers, and the format is in hours, that is, minimum node 0 or 01 and maximum 24. <input type="text" step="any" value="" ng-model=""…
angularjsasked Bruno Souza 151 -
1
votes1
answer213
viewsQ: Angular ng-Pattern - 1 or 2 numbers
In the code below I need to make ng-Pattern receive 1 or two numbers, and the format is in media, that is, minimum node 0 or 00 and maximum 59. <input type="text" step="any" value=""…