Posts by Flavio Ss • 97 points
8 posts
-
2
votes3
answers454
viewsQ: Replace Sql in the middle of the text
SQL Server Database , Column is a Varchar(9) . And I need to fix this data because I need to filter only by people over 50 years old and that way I’m not getting , more in case someone knows a…
-
0
votes1
answer387
viewsQ: Bank Consuming all memory
Good day I am with a problem , users of a given system are having problems when consulting a name in the system "a simple search" I joined the bank and noticed that in sql there are several banks…
-
0
votes1
answer69
viewsA: Communication between spreadsheets
I believe that it will not be possible to do this without you sending it back to your client after each change, because you send a copy of the Excel file in question. then it would be impossible to…
-
-2
votes4
answers33862
viewsA: How to search for values in column A that do not exist in column B?
Try it like this: Code Snippet Sub excluirvalores() x = 1 'O loop While corre de celula em celula até a ultima celula preenchida While Cells(x, 1).Value <> "" y = x + 1 While Cells(y, 1).Value…
-
2
votes3
answers133
viewsA: Create a means not to repeat my code
You could create a function gerar_usuario() and within this function put the code to create users and then just call the function where you need.
-
1
votes1
answer31
viewsQ: Add year to my sql search clause
I set up a trial that does a search for the amount of hours pointed out per month of each employee of the company. The trial works well, but I noticed that she ends up looking for years past and I…
-
0
votes0
answers73
viewsQ: My select is not generating result
I’m doing a select , this same select tested in the database returns me the information I need , more in my code . net gives an error saying that it is not generating result what is it that I am…
-
0
votes1
answer721
viewsQ: Store data set values in ASP.NET variables
I’m having trouble storing the return of a select in variables , I’m using a data set to create a table with the result of select , this select will return me some records and the form I’m making so…