x

Merge values ​​outside the date range

Hello,

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 at 01:51 AM in Default

avatar image

Gelain
10 2

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

Sep 13 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x33

asked: Sep 12 at 01:51 AM

Seen: 44 times

Last Updated: Sep 13 at 02:37 PM

Copyright 2017 Redgate Software. Privacy Policy