Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 stored procedure

Author  Topic 

vijayanto
Starting Member

16 Posts

Posted - 2009-06-02 : 01:30:06
hi friends,
i got the problem in the stored procedure
i have fields like date and quantity
for the current date it has quantity
but at the same time i want to display the quantity in the previous year,and also the query should check the quantity of the previous year
please give me the solution

regards,
vijay

nishita_s
Yak Posting Veteran

61 Posts

Posted - 2009-06-02 : 01:35:58
give related table names with table structure
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-06-02 : 01:56:38
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=126864

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -