Posts by tssantana • 43 points
6 posts
-
0
votes1
answer41
viewsQ: Validate parameter to disregard left Join
I’m setting up a select, but depending on the value of a come parameter (store = 00000 - all stores), I’d like to skip the "AND p.store = e.store " section on the left Join so that it disregards the…
-
-3
votes3
answers507
viewsQ: How to merge two Pdfs into Base64 in one
I have the following scenario: I receive two files encoded as Base64, each representing a pdf. I need to read those files and turn them into a single encoded file like Base64. Input example: PDF1 =…
-
0
votes2
answers41
viewsQ: Change the value of a field when a condition is true
Good evening, everyone, Can you help me? I need to create a view with the data below, however I need to create a condition where when the value of MC.SITUACAO is equal to 'A', the fields…
-
1
votes1
answer101
viewsQ: Birth date validation with LINQ
I am doubtful to conduct a consultation. I need to list in this query only the offers that are within the age group listed in view in the fields IDADEMINIMA and IDADEMAXIMA passing only the…
-
1
votes2
answers2067
viewsQ: Merge two lists c#
I have 2 lists and would like to join them in a single list to be listed. I created two lists because both present different conditions of the query and I could not relate them in a single list.…
-
1
votes1
answer49
viewsQ: Doubt syntax: How to find the minimum and maximum value of a field in Line with Where
I need to create a function in linq return me the minimum and maximum values of a field in a list. I was able to perform an SQL query in this way, but I need this in the syntax in linq. SELECT…