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 John Tel 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: Arsenal176
- Content: Threads
- Order by date
-
Rounding to nearest whole number
Hi, I'm trying to round a decimal(18,2) to the nearest whole number (<=.49 should round down, >=.50 should round up). I've tried casting as decimal(18,0) but this rounds 1.50 up and 2.50 down (odd numbers round up, even numbers round down). casting as integer just truncates the last 2...- Arsenal176
- Thread
- Replies: 3
- Forum: NCR: Teradata
-
VBA Querying in SQL
Hi I am sorry , this may be a very stupid question , but I have no VBA knowldge . I have spent the last two weeks developing an excel based application and that is it. I have to query using any unique value in the list aa2:aa58 The values in this list may not be unique . If I just search using...- Arsenal176
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
