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 2000 Forums
 SQL Server Development (2000)
 problem in cursor

Author  Topic 

surbhi2619
Starting Member

1 Post

Posted - 2009-12-28 : 05:13:57
There are SrNo, Id, Desc , Qty, amount , formula column in grid view
in formula column if we write Q4 * Q5
it means multiplication of Quantity column of row 4&5
Ques is how to read this formula and implement in sql cursor.

multiplication ya addition of two rows on the basis of formula in formula column eg-- Q4* Q5 ( multiplication of Quantities of 4 th and 5th row

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-12-28 : 16:28:51
Is this data stored in a MS Sql Server table? If so, post executable code to CREATE TABLE and post executable code to INSERT a few sample rows of data to your table. Finally post the EXPECTED OUTPUT you want based on your sample data.

Be One with the Optimizer
TG
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-28 : 17:51:20
How would you know how to relate which rows to each other?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -