In the past when neither "\r" nor "\n" has worked for me, a combination of "\r\n" has done the trick.

Thats strange. I was going to suggest that you don't have privileges, but if that were the case then you wouldn't be able to use the MP wizard. ...

There's plenty of help available in this forum. What do you want the function to do? Can the "quarter" option in the DATEPART function help at all?

Can you post an example of the output required? (heading + 1 or 2 lines)

What is "CCA_Bat"? The backup file or device? Is it overwritten or appended to? Is there enough space in the drive? Does the failure occur for...

Well, There is cheating and there is cheating.

One can either: A) answer the question based on current knowledge B) actually test out the alternatives in the question and/or...

Maybe something like...

SELECT TOP 1 *

    FROM MyTable

    WHERE ID = @ID

    ORDER BY CASE WHEN...

I'm not real big on bitmasks myself, so here's something I've hacked together. Undoubtedly someone could do better, but it's a start.

DROP TABLE MyAudit

GO

CREATE...

If you use the value of the trigger's bitmask variable (function) COLUMNS_UPDATED(), then you should be able to analyse that bitstring, joining with syscolumns or information schema views to determine...

If you use the value of the trigger's bitmask variable (function) COLUMNS_UPDATED(), then you should be able to analyse that bitstring, joining with syscolumns or information schema views to determine...

It may be that another local process is jumping in first in single user mode.

Your error message has a high hit rate in Google Groups (http://groups.google.com/). Search on...

Driver conflicts were related to ODBC. I can't remember the specifics but they eventually arose after messing around with Oracle retrieval from SQL Server and then Oracle insert/update from...

My recommendation is to separate the two. I don't like running ANYTHING alongside SQL Server on a production server, except unavoidable things like MS Search for FT indexing. ...

 UPDATE TableA

SET id = TableB.id

FROM TableA 

INNER JOIN TableB ON TableA.xCode = TableB.xCode

WHERE TableA.id IS NULL OR TableA.id = ''

I think you're going over the top by choosing a stored procedure for this task. To acheive what you're trying to do within a procedure you'll need to use...