make Average order value - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

make Average order value

Author

Topic

tryharder
Starting Member

17 Posts

Posted - 2014-12-01 : 05:22:17

Hi,

I have a column called demand and one called orders. I want to divide the demand column figure by the order column figure and put the new values in a column called AOV.

demand is varchar(255)
order is Varchaar(255)

thanks

SP

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2014-12-01 : 08:56:29

http://technet.microsoft.com/en-us/library/ms191250(v=SQL.105).aspx

How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

sz1
Aged Yak Warrior

555 Posts

Posted - 2014-12-01 : 09:29:33

select
[demand],
[orders],
[demand]/[orders] 'AOV'

From MyTable

We are the creators of our own reality!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources