This works great Sergiy!.  Thank you so much!

I need...

for person 2 (01/01/15 -12/31/16 )  (when split by 6 months becomes)
01/01/16 - 06/30/2016
07/01/2016 - 12/31/2016

for person 3 (09/01/15  -12/31/17) (when split by 6 months becomes)
09/01/2015...

I am ordering by updatedate desc and then I am applying the filter.

I had posted everything in the original post, but here it is --

create table #test (id integer,start datetime,enddate datetime, p1 integer,p2 varchar(20), updatedate datetime)

insert into #test

values (3144187,'2015-07-01 00:00:00.000','2015-12-31 00:00:00.000',18005,'test1','2015-09-18 12:28:05.197')

insert...

I had posted in my first post, but here you go

expected output result (even if the date range on update date is 07/01-07/30)

ID ...

I use 2014. I thought about that but it gives it on the same row. But, I need the data it in separate rows.

Cadavre,

Your solution works great. Thanks a lot and I really appreciate it.

Thanks

Kris

Thanks for putting it together.

Is there a way to use bulk update as this table will have huge volume.

Thanks

Kris

Thanks Craig. I will try to work on the indexes and see.

Hi Craig,

I have corrected the script below.

This is related to process called true-up, where we need to identify last valid transaction date that affected the quantity on hand...

I like to get this record basically I care only about the transaction date which is 2012-01-06

5|S|S2|2012-01-06|-50|-50

Thanks

Sure Craig.

At this point I do not need to relate Sale and Order. I just need to exclude the orders(both submitted and received that has same order id) that...

[INTR_ProdID],-- Product ID

[INTR_QuantityOnHand],-- Actual Quantity on Hand

[INTR_QuantityAvailable], -- Quantity available (tracks/accounts for the ordered qty where products are not received yet)

[INTR_TranType_Lookup_ID], -- Trantype tells if it is...

Thanks guys. Currently, I do not have access to my machine right now to provide the details but I will put them soon.

The tables I have provided are just...

rctype value is only a sample I gave. it can be 2 or 3 anything but i will know it before hand.

max(a.rcType)= MIN(a.rcType) seems to work

thanks kramaswamy