Will you be updating or directly inserting into c? If not use a calculated column.

I don't know how to get IP addresses from SQL Server, but the AUDIT LOGIN, AUDIT LOGOUT, and AUDIT LOGIN FAILED events in SQL Trace all include the HostName column...

You can't reference a column in a table without a select, update, or delete FROM table. You are saying:

IF table.column then

And SQL Server has no idea what table.column...

I'd try using openquery instead of querying the linked server directly from the SQL Server. OpenQuery makes it more of a pass-through type query.

Add "WHERE EMAIL IS NOT NULL or Charindex('@', Email) > 0"

I would have the UDF return a table with a list of the string values and then join on the UDF. Check out this article for splitting a delimited...

What is the data type of the column causing the problem? Could be a mapping issue so you may need to CAST it. Also have you tried using...

But what the boss doesn't understand and you need to get him or her to understand is that pure T-SQL does not actually run on the client, but on the...

If you are running this as a query in SSMS it is trying to create an execution plan and THAT is when it is failing in the database where the...

Your set statement just to to reference the column you are updating so in your example you would need:

set prokw1= prokw1 + 'oneworld'

You may want a space or comma...

I'd do a quick and dirty .NET app. Let them select the file and click an import button.

If your collation is CI_AS then there is no reason for the UPPER conversion in the joins, so I'd remove those.

The only other comments I have, that I have not...

Wouldn't it be easier to return the data to VB in a dataset and then do the XML manipulation there? Once in VB you can use xsl style sheets...

You've definitely written more...

Grant Fritchey (8/12/2008)

I'm sorry the article wasn't clear enough on these points. I was really hoping to help people who had been stuck like I was. It seems I may...