Merge values ​​outside the date range


I need the final balance of inventories in a certain period of time: 08/01/2017 to 08/31/2017, considering, also, the values ​​of the other months that had balances and did not have movements in August 2017.

I made a simpler example to facilitate understanding.

Please help me. Thank you.

alt text

sql.jpg (67.4 kB)
more ▼

asked Sep 12, 2017 at 01:51 AM in Default

avatar image

10 3

Would love to see what you've tried so far...

Sep 13, 2017 at 02:37 PM KenJ
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 12, 2017 at 01:51 AM

Seen: 48 times

Last Updated: Sep 13, 2017 at 02:37 PM

Copyright 2018 Redgate Software. Privacy Policy