Posts by Lucas Tadeu Egídio Arruda • 281 points
13 posts
-
1
votes1
answer8888
viewsQ: Concatenate columns in SQL SERVER
I need to concatenate 3 columns in a row using SQL Server, when I concatenate it returns this value: Would have to stay: Moura 105ah ground floor I’ve seen some examples on the internet, but I…
-
1
votes0
answers50
viewsQ: How to check field with javascript
I have a screen where you have the service order states, when that service order is 86, it cannot be changed to 93, as follows in the image below: If it is changed to 93, when you click save button,…
javascriptasked Lucas Tadeu Egídio Arruda 281 -
1
votes1
answer57
viewsQ: Print days of the month in the table
I am trying to create a report based on some tables of my bank, in this report, I need to pass during the month, on which day the operation was executed, so I need to print out every day of the…
-
3
votes1
answer141
viewsQ: Data to string conversion in SQL SERVER
I need to perform a conversion of a query of type date to type string, but it always returns me the following error: Msg 241, Level 16, State 1, Line 2 Conversion failed when converting date and/or…
sqlasked Lucas Tadeu Egídio Arruda 281 -
1
votes1
answer83
viewsQ: How to list items per month in SQL Server
I need to be listed assets that have something scheduled for a period, in case they need to bring me by month, I’ll leave an example below: I have here a report where I bring an asset that returns…
-
1
votes0
answers127
viewsQ: How to pass the date to day, month and year in C#?
I need to pass my dates for day, month and year in Brazilian format, but I searched the code and the internet and I do not know apply the examples to my problem. It returns the results so I need to…
c#asked Lucas Tadeu Egídio Arruda 281 -
2
votes0
answers974
viewsQ: Screenshot me returns the error index was Outside-the Bounds of the array
I have a screen that saves users, and assigns value to them, but whenever I click the save button it returns me the index error was Outside-the Bounds of the array , I already searched lines and…
c#asked Lucas Tadeu Egídio Arruda 281 -
1
votes0
answers30
viewsQ: How to change the selection between two checkboxes?
I need to perform the selection of two checkbox, when I click on one the other is not selected, and when the other is selected this previous cannot be selected, and can select only one.…
javascriptasked Lucas Tadeu Egídio Arruda 281 -
2
votes0
answers41
viewsQ: How to add two result fields in a query already formed in SQL
I need to add two fields in a query already existing in SQL SERVER, but I don’t know how to add them in an existing query. I will try to detail more what I want with the images below: I have this…
-
3
votes1
answer16
viewsQ: End of file, incorrect SQL SERVER syntax
I am trying to execute a command in my sql, but always when I try it turns me an End of File error, I already looked line by line and nothing figured out, how can I solve this problem ? DECLARE…
sqlasked Lucas Tadeu Egídio Arruda 281 -
4
votes1
answer415
viewsQ: Loading before displaying content
I need to make a gif animation before I load my graphics, and after the upload is done, the animation stops appearing, I’m using Highcharts to create the graphics, but I have no idea how to do this…
-
0
votes2
answers1335
viewsQ: How to align items next to each other?
So, I’m dealing with bootstrap, html and css. I need to align two columns and have the items align to each other this way: Mine at the moment is like this: Someone can help me ? body { padding-top:…
-
6
votes1
answer62
viewsQ: Align queries and pass your results as alias for SOMA
So I’m running two queries that return me the amount X of items per month over a year. The first consultation gives me the following result The 'no column name' would be the months, so I have no…
sqlasked Lucas Tadeu Egídio Arruda 281