Short answer is I edited #2 to be correct and #4 to be incorrect. I didn't change the flagging since its a slightly bigger pain in my arse and someone's...

I did swap them around. Easier than changing the answer.

grumble, grumble, html encoding junk.

Apologies, somehow my link got encoded into nonsense. I edited it and it should work now.

I'd go with Remy's first suggestion.

After rereading the question and BOL, I agree with a number of people that #2 is the correct answer. I have corrected that fact and awarded points back to those...

Add a ROUND()?

SELECT cast( round((CONVERT(varchar, CAST(SUM(val) AS money),1)),0) as int) AS [Offered]

from mytable

No way I know of.

You have a few cases that you need to handle. An OR will do it, but there may be better ways (more efficient). So you need to handle

- people...

Beta 3 is not out. There are two post Beta 2 builds, called Community Technical Previews (CTPs) that are intermediate builds. You can get them from Beta.ms.com or MSDN. There...

I like the idea of MySQL. I think PostgreSQL is a better product, more mature, but advances occur rapidly in both products, so that might not be the case. I...

what do you mean it can see the SQL Server? You can log in? If you can log in, SP2 has nothing to do with it. It would be a...

I'd use the Apex tool or another as documentation is best done by a tool.

Just insert permissions

set identity_insert mytable on

insert mytable (myidentity, myvalue) select @myid, @myval

set identity_insert off

charindex or patindex can help you find the commands and then substring can help you split them out.

I wrote a series on working with strings that might help you

http://www.sqlservercentral.com/columnists/sjones/tamestrings2.asp

http://www.sqlservercentral.com/columnists/sjones/tamestrings1.asp

nchar consumes two bytes as well. Do you mean convert to varchar instead? In SS2K, above 4 or 5 char, it doesn't make sense to use char.