Interesting and the explanation makes sense. Played with it a bit and found this returns the second answer and not exactly sure why. I am thinking there is an implicit...

Why not start it at max negative and use the negative side as well? Then you would have almost twice as many...

I think the key to answering my question is along the lines of Hugo's

Also, in dictionaries, if a word is the same as another word but with a suffix, the...

I'm also a bit confused why peppers is at the end. If lowercase p is before uppercase p, which I knew it would be, why was it at the end?...

I started to go for the "correct" answer then read the part about never being wrong and KNEW that wasn't the answer. So many times there have been mistakes, or...

Ok I finally resolved my issue. The problem was that the original table's varbinary column was created while "SET ANSI_PADDING" was turned OFF. This caused the value that was being...

And I have reproduced on a SQL 2008 R2 64bit server as well. Exact same issue.

I assume that your question is why you couldn't directly insert into one DB by selecting the data from another?

This is meant to...

Another tact you might try is regular expressions.

Here is link to using regular expressions in SQL

http://www.sqlservercentral.com/articles/Advanced+Querying/sql2000dbatoolkitpart2/2362/

And a link to a regular expression that converts rtf to plain text

http://regexlib.com/REDetails.aspx?regexp_id=1655

I haven't...

It is true that left outer would have returned all rows from left table except that the where statement immediately filters them out. Something like putting an "OR (B.transaction_date is...

Even though I got it correct I don't think it is completely correct.

select col1, col2, "extra" = 'X' from table1 group by col1, col2

would work even though the column "extra"...

I don't see why people even think this is a bug. There are rules for result datatypes and this appears to follow those.

Seems clear that:

INT * INT results in...

Not that it affects the answer, as it was stated that the DB exists... just wanted to point it out that it was written to do something that won't work....