Forum Replies Created

Viewing 15 posts - 1 through 15 (of 39 total)

  • RE: Aging Query

    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...

  • RE: Aging Query

    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 ,...

  • RE: Aging Query

    kramaswamy,

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

    Regards,

    Ravi

  • RE: Aging Query

    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...

  • RE: Aging Query

    Michelle ,

    Thanks for your suggestion

    Regards,

    Ravi

  • RE: Aging Query

    Sorry sir , i didnt mean that

  • RE: Aging Query

    Any idea how we can achive this ...

    Regards,

    Ravi

  • RE: Aging Query

    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

    ...

  • RE: Aging Query

    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...

  • RE: Aging Query

    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

  • RE: Aging Query

    Thanks for the Query , ill surely try this

    meanwhile if any one has any other solution ,please provide

    Regards,

    Ravi

  • RE: Aging Query

    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 =...

  • RE: Aging Query

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

  • RE: Aging Query

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

    Please let me know if anything else is required

    Regards,

    Ravi

  • RE: Aging Query

    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...

Viewing 15 posts - 1 through 15 (of 39 total)