March 9, 2004 at 3:24 am
In MS Access, I could create an expression and use its results in another expression very easily but I can't figure out how to do this when I am creating a View in SqlServer2000. For example, col1+col2+col3=subtotal1, col5+col6=subtotal2, (subtotal 1+subtotal2) * taxrate=grandtotal
Could someone please tell me the best way, Thanks
March 9, 2004 at 11:19 am
You need to spell this out.
col1+col2+col3=subtotal1, col5+col6=subtotal2, (col1+col2+col3+col5+col6) * taxrate=grandtotal
March 9, 2004 at 11:47 am
That seems so cumbersome. This means that if the formula for subtotal1 changes, then I have to change the formula for grandtotal also. Why is something that was so easy in Access, so much more complicated in SQL Server?
March 9, 2004 at 12:24 pm
Easy is not equivalent to better
After all the formulae should not change frequently, or?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy