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.
| Author |
Topic |
|
ConradK
Posting Yak Master
140 Posts |
 Posted - 2009-12-08 : 12:15:05
|
| My codecase when pe.Book_ISBN is null and pe.Quickbooks_Item_CogsAccnt is null and pe.SalePrice is null then pe.productprice else pe.Book_ISBN is null and pe.Quickbooks_Item_CogsAccnt is null then pe.SalePrice else pe.Book_ISBN is null then pe.Quickbooks_Item_CogsAccnt*1.25 else pe.Book_ISBN end as "ItemPrice"I'm sure its simple.Its select.Thanks |
|
|
ConradK
Posting Yak Master
140 Posts |
|
|
|
|
|
Real simply SQL syntax [ignore]