Lynn thanks for your feedback, form next time i will make sure i put all the problems /req. in the first post.

i have attached the same query that u gave...

Thanks Lynn,

Query works if i have 1 negative value in that list for the Particluar Item,City, Street like

Date: 07/07/2009, Item : A City : NY , Street : ABC ,...

kramaswamy,

Thanks for your suggestion, but i need to stick to TSQL . will try to work around that query

Regards,

Ravi

Michelle,

The user requirement is basically to create an Aging report

I am able to calculate the age of the product , but say when i get negative value in particular age...

Michelle ,

Thanks for your suggestion

Regards,

Ravi

Sorry sir , i didnt mean that

Any idea how we can achive this ...

Regards,

Ravi

i added itemid=@itemID in the below part

UPDATE #temp1

SET Quantity = 0

WHERE ID = @ID

and ItemID = @ItemID

and removed the top 1 from

BEGIN

...

Sorry for not providing the details.. i have udated the excel sheet

if i am trying with the existing code ..its showing 1 for other items and the count is...

it works when we have 1 item ,but i need for multiple items and city

Item likes A,B,C

and thr is also City

Can u please help

Regards,

Ravi

Thanks for the Query , ill surely try this

meanwhile if any one has any other solution ,please provide

Regards,

Ravi

The 2nd and 3rd case are correct but some minor mistake in 1st ..let me correct it

if the input is

0-30 days = -4

31-60 days = 6

61-90 days =...

Yes this has to be FIFO , and its similar to inventory

I have attached the create statment and statment to insert data.

Please let me know if anything else is required

Regards,

Ravi

I have attached the sample data and expected output

let me try to explain what i need

say for a particular city ,street i get negative quantity for particular age...