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 2008 Forums
 Transact-SQL (2008)
 simple * in select

Author  Topic 

mike13
Posting Yak Master

219 Posts

Posted - 2012-12-06 : 18:50:03
Hi All,

trying to make a view, but statement is not accepted
select (Cost * 2)*1.21 as salesPriceTax from T_sales


thanks a lot

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2012-12-06 : 19:32:23
What error are you getting? There's nothing wrong with what you've written.

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page

mike13
Posting Yak Master

219 Posts

Posted - 2012-12-06 : 20:00:23
nothing SQL 2008 just removes the 1.28
Go to Top of Page

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2012-12-06 : 20:26:10
Could you post the whole query? What do you mean by "SQL 2008 just removes the 1.28"

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page

mike13
Posting Yak Master

219 Posts

Posted - 2012-12-07 : 04:19:40
sorry, got to work must have been sleeping
Go to Top of Page
   

- Advertisement -