My favorite quotes are all religious and inspirational, which doesn't seem to be the theme of this thread. (For example: "Force yourself to smile and you’ll soon stop frowning....

Try:

select cast(yourcolumn as datetime)

The reason for the error is that it couldn't resolve the inline sub-query without doing the aggregate, but couldn't do the aggregate without resolving the sub-query. Mainly seems to...

I've occassionally had problems with the where clause being resolved after the attempt at the string function. This can be resolved by forcing it into two steps in the...

I just tried running it in SQL 2005 and got the oddball results. Same pattern (14, 28, etc.).

It's not even multiples of 7 (my first guess), since 42 doesn't...

Steve Jones - Editor (2/19/2008)

---

You cannot get the actual execution plan in all cases, so the statement is false. Even if you query the system views, you get the estimated...

In Management Studio, right click the database you want to script.

Select Generate Scripts

Leave "script all objects..." unchecked

Next a couple of times

Stored Procedures

select the ones you want

When you get to Output...

It can be caused by the UDF having to store an execution plan that allows for larger and smaller ranges of answers, based on the table statistics.

The hard-coded version doesn't...

Yet again, the person asking the question didn't think it through.

Yes, you can get the actual execution plan without executing the query. For example, get the execution plan from...

The only place I can see this mattering is whether or not it will fire off a DDL trigger. Is there any other significance to which part of the...

It looks to me like the No section might send an empty e-mail if the inserted CommentID is null. Check for that.

Jeff, thank you for the recommendation on using float instead of money for complex calculations. I see what you're talking about on that one. I've used money instead...

Jeff Moden (2/15/2008)

---

Ross McMicken (2/15/2008)

---

The biggest issue we've had with using money datatypes is that reports in Crystal, and other tools, put a $ sign on each foeld by default....

I'm not sure such is possible/applicable in an SQL database (regardless of which flavor of SQL we're talking about; Oracle, MS, whatever).

One of the main things is the number of...

The default instance is probably eating up too many resources. I'd disable it unless some other application needs it.