Is this the right place to demonstrate how good is greater than evil, just by using SQL?

It's hard to know if you don't give the exact error, code and/or...

One tip I could give you is to use the debugger to check you have the correct value in the sSQL variable.

The other thing I noticed is you wrote the...

This is a repeated post and was solved in here

http://www.sqlservercentral.com/Forums/Topic1329746-392-1.aspx

By the way, I made the same mistake as Stewart

To start with the suggestions, you can always use:

SELECT @@VERSION

to define the version of SQL Server you're working with.

In the other hand, bitwise operators will return an integer (the result...

IMHO the best way is to create a carriers table with the information needed and add a field column (Insert Celko's quote saying "columns are not fields":-D) for a...

How do you know if you should use @txt.att or @messaging.sprintpcs.com or something else?

You're right, I got confused with the term as I haven't used it in a long time.

I'm not sure what you're trying to do because there's no cursor in there.

You're updating a table in the worst way possible (well, there might be something worse).

To update the...

I believe that the correct answer to this question is the most popular answer in this community:

It depends.

Because it depends on the Operating System maximum.

This would make the trick. But as noted by others, formatting should be done on the front end.

DECLARE@Datedatetime

SET @Date = '20120523 18:03:12.523'

SELECT CONVERT( char(10), @Date, 101) + ' ' +...

In my experience, Smash would need a slightly different approach if he needs the total due for each contact, because Chris' query will only return the total from one sale.

UPDATE...

Have you tried a cross join on the same table?

SELECT a.product,

b.product

FROM ProductTable AS a

CROSS JOIN ProductTable AS b

WHERE a.product <> b.product

That will give...

As they say, it's not clear to see exactly what's going wrong. But I believe that there's an extra column in your GROUP BY clause (or maybe there's another reason...

I'm not sure if it was a trick question or an easy question, but I followed my instincts on the way TRUNCATE works and got it right.

It's a good way...