468,316 Members | 2,059 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

SQL Server Formula


I have a database with some tables in Sql Server 2005. I want to make a stored procedure/T-sql/... or smth like that, to set a formula of a certain table. For example, I have the table "Orders", with fields like: "OrderID", "Name", "Price", "Quantity", "Height". Then I select from a web form which operands to be included in the formula and I select also one operator.

For example, for the above table, I select Price and Quantity operands and the "+" operator, then I want my query to return Price + Quantity; but I want to can use that query also for other operators and other operands (and not only 2 operands, I want to can use it with 2 or more operands).

I appreciate your replies.
Thank You,
Jan 16 '09 #1
1 3128
2,878 Expert 2GB
Sounds like an assignment.

What do you have so far?

-- CK
Jan 16 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Mike | last post: by
11 posts views Thread by Brian VanPelt | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.