Posts by Rafael • 85 points
5 posts
-
2
votes2
answers142
viewsQ: How to bring date without Sql server 2008 record
I have an SQL query adding up values of each day, returning only the days that have values. But I would also like to present the days that had no records. Consultation: SELECT DATA, SUM(VALOR) FROM…
sql-serverasked Rafael 85 -
1
votes5
answers7513
viewsQ: Reduce Log File Size
I’m in a saga with my database, today I have an 11GB mdf file and a 77GB log. I have already searched in several forums, applied some reduction procedures via Management (Shrink) and via command…
-
2
votes1
answer380
viewsQ: How to bring null query Sql server value
I have an sql query where brings the total of a value inserted in a date, but I want to demonstrate in the result the dates that generated zero, even not containing information in the database,…
-
0
votes1
answer76
viewsQ: Journey Boundary - SQL Server 2008
Good afternoon, would like to make an SQL to control the limit of the last beat of the point of the employees with the first of the other day, filtering the amount of times the calculation gave less…
sql-serverasked Rafael 85 -
2
votes1
answer894
viewsQ: How to counter "blocks" in Sql Server
I would like to know how an accountant would look in an SQL query for the following situation: I have the columns matricula, date and time worked where I would like to create another column with the…
sql-serverasked Rafael 85