Viewing 15 posts - 601 through 615 (of 790 total)
In the past when neither "\r" nor "\n" has worked for me, a combination of "\r\n" has done the trick.
July 24, 2003 at 10:56 pm
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. ...
July 24, 2003 at 10:49 pm
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?
July 24, 2003 at 3:13 am
Can you post an example of the output required? (heading + 1 or 2 lines)
July 23, 2003 at 11:31 pm
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...
July 23, 2003 at 2:46 pm
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...
July 23, 2003 at 4:50 am
Maybe something like...
SELECT TOP 1 *
FROM MyTable
WHERE ID = @ID
ORDER BY CASE WHEN...
July 23, 2003 at 3:02 am
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...
July 23, 2003 at 2:52 am
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...
July 23, 2003 at 1:14 am
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...
July 23, 2003 at 1:13 am
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...
July 22, 2003 at 7:22 pm
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...
July 22, 2003 at 5:25 pm
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. ...
July 22, 2003 at 5:07 pm
UPDATE TableA
SET id = TableB.id
FROM TableA
INNER JOIN TableB ON TableA.xCode = TableB.xCode
WHERE TableA.id IS NULL OR TableA.id = ''
July 22, 2003 at 3:52 pm
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...
July 22, 2003 at 3:46 pm
Viewing 15 posts - 601 through 615 (of 790 total)