Perhaps this isn't the actual SQL you're using? Your 't1' and 't2' sub-queries don't contain a 'Model' column - and neither alias is used in the rest of the...

Since you will always be rounding to two decimal places, this will work, regardless of the number of decimal positions.

SELECT ROUND(YourNumber + .005, 2, 0)

As Matt wrote in an earlier post, the COALESCE statement *is* working.

SELECT COALESCE(0, 15) will return 0. SELECT COALESCE(NULL, 15) will return 15. To return the first non-null,...

This is the output of a T-SQL statement contained within a batch of statements. A BCP format file will not help.

After re-re-re-reading the entry in BOL, I tried enclosing the character code for [Tab] in double quotes. That finally worked.

Where "PS" said "get max identity from this table", instead use SCOPE_IDENTITY. Read about it in Books Online (BOL). The problem with selecting the maximum identity from a...

Thanks, Flo. Sigh...

I can cobble the data-entry in Access, but it won't help the appearance in the SSMS TableView grid, though. The CRLF will show as...

Jeff, does that mean you're aware of a 'non-easy' method for determining whether a Stored Procedure returns a resultset? And, no, I don't see any dilema; we're interested in...

Hmmm... Simple addition will NOT work. Multiplication is also needed.

Example 1: 2009 + 1 + 2 = 2012 (January 2, 2009)

Example 2: 2009 +...

It doesn't matter how quickly it can be done WRONG. 😉

upperbognor (10/23/2008)

---

I've also seen this approach taken when looking for GUID's in a input list of GUIDs. This method looks up every value in the table in your list...

I'm sorry... I meant ROUND(YourValue, 0, 1)

I apologize for my lack of proof-reading.

or, use

ROUND(YourValue, 1)

(revised) I'm sorry... I meant ROUND(YourValue, 0, 1)

I apologize for my lack of proof-reading.

The non-zero 2nd parameter truncates the value, without changing the...

(IntegerConstant * IntegerColumn) / IntegerColumn = IntegerResult

You need to CONVERT or CAST somthing to at least Decimal(8, 2), then round. I'd suggest your IntegerConstant for this.

Would the batch-level include parsing and query plan determination / selection?