Viewing 15 posts - 1 through 15 (of 39 total)
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...
August 24, 2009 at 7:37 am
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 ,...
August 24, 2009 at 1:47 am
kramaswamy,
Thanks for your suggestion, but i need to stick to TSQL . will try to work around that query
Regards,
Ravi
August 19, 2009 at 12:08 pm
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...
August 19, 2009 at 12:05 pm
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
...
August 19, 2009 at 9:50 am
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...
August 19, 2009 at 9:44 am
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
August 19, 2009 at 9:27 am
Thanks for the Query , ill surely try this
meanwhile if any one has any other solution ,please provide
Regards,
Ravi
August 18, 2009 at 7:22 am
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 =...
August 18, 2009 at 6:06 am
I have attached the create statment and statment to insert data.
Please let me know if anything else is required
Regards,
Ravi
August 17, 2009 at 9:08 pm
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...
August 17, 2009 at 7:58 pm
Viewing 15 posts - 1 through 15 (of 39 total)