Eh, nevermind, it's "Invalid character value for cast specification". That's something different. Sorry.

Are you sure your dest column is wide enough to handle all the incoming text? Not sure, but it sounds like this...

The column status returned was: "The value could...

This was a great article, but typically when I start seeing needs like this, I start wondering if maybe a better solution would be to try something completely different. Once...

Gawd, I feel awful for actually knowing the answer. :sick:

Perhaps Mr....

You forgot:

5) Access to the site will require a custom-built browser that is arcane, follows no known standards, and is difficult to install, requiring tweaking of hidden system files to...

Are you spelling the "raise error" correctly? It's "Raiserror", not "RaiseError".

Some of us learned...

Aaarrgh! Stop already! This thread is like a giant bag of potato chips -- I just can't stop reading it!

Or are we going for a record number of posts on...

I certainly don't disagree, in fact I think you're in line with the point I was trying to make. That is, prefer readability and maintainability if possible. You may not...

I think that you could argue with your "senior programmer" that "a <> b" is more readable and maintanable and is thus the preferable method. A "senior programmer" should understand...

Let's see...I think it was in Hitchiker's Guide to the Galaxy...they took a galactic census but had to toss out the results when they discovered that the average galactic citizen...

That's all well and good, but the question doesn't say "In SQL Server 2005, what...

...and, if you pass the data in as XML (or whatever other method you choose to pass in a chunk of data that you want to work on) then you...

You don't need a trigger...

[font="Courier New"]DECLARE

@userid UNIQUEIDENTIFIER,

@GroupID UNIQUEIDENTIFIER

SET @user-id = NEWID()

SET @GroupID = NEWID()

INSERT INTO User_Group_Map (UserID, GroupID) VALUES (@UserID, @GroupID)[/font]

Wrap it in a stored proc...