Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: RichardTisdall
- Content: Threads
- Order by date
-
SQL - how to shift decimal point
I am trying to compare product prices in two separate tables. The price in one table is data type real, 4 and in the other is smallmoney ,4. My prices are displayed like this. (Real) (Smallmoney) PriceSupp CPDPrice 930300.0 93.0300 Can anyone suggest how I can do some...- RichardTisdall
- Thread
- Replies: 21
- Forum: Microsoft SQL Server: Programming
-
Problems with select(max).... query, please help
Need a little help here! I have a table 'AllCostPriceData' that contains product codes and prices. From time to time prices change. Rather than delete obsolete prices they are retained in the table for historical purposes so there is a further column in my table 'effective_date' It looks...- RichardTisdall
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
