SQL Server Rounding Functions - Round, Ceiling and Floor

I saw your recent tip on Calculating Mathematical Values in SQL Server and have some related issues as I try to round values in my application. My users and me have a difference of opinion on some of the calculations in our reporting applications. All of the code is in T-SQL, but I think the reporting issues are related to data types and rounding down or rounding up rules. Do you have any insight into these issues? I would like to see some examples with a variety of coding options.

Coalesce and Conversion

T-SQL

Single Quotation Marks in SQL

One of the common problems is dealing with apostrophes in T-SQL. This article examines the challenges of single quotation marks and ends with a short quiz.

Round And Numaric

TSQL 2012 #1

T-SQL Bulk Insert

T-SQL that allows you to import tab delimited text file into correct table based on file name.

Aggregates in T-SQL

UNIQUE constraint

Table variables