Viewing 15 posts - 4,366 through 4,380 (of 7,429 total)
This would work too, looks a little odd thou
SELECT
CASE WHEN Base.AGE IS NULL THEN AgeCtrl.Age ELSE Base.Age END Age,
CASE WHEN Base.AGE IS NULL THEN 0 ELSE Base.Number END Number
FROM
(
SELECT AGE,...
November 8, 2002 at 6:05 am
Maybe make a permanent control table with all the age values 1 - 120 (I doubt anyone over 120), especially if this query will run more than once.
My query is...
November 8, 2002 at 5:52 am
To look at what is in the Transaction Log you can use a tool like LogExplorer which is very easy to understand, just a bit pricey. Or as posted in...
November 8, 2002 at 5:38 am
quote:
I don't believe it!!! Microsoft lied!The killdatabase method does NOT drop a database regardless of connections, activity or state as it...
November 8, 2002 at 5:21 am
I looked around and found no mention of this. Have you tested the 54 limit on another box? If you get the same problem I would ask MS still, I...
November 8, 2002 at 5:14 am
Depends on several things, one of course is traffic. Another is the database recovery model if you have SQL 2000, if you do bulk inserts and have the database set...
November 8, 2002 at 4:34 am
quote:
Given that TempDB is recreated every time SQL Server is restarted do you think there is any merit in moving it off...
November 8, 2002 at 4:24 am
Let us know if anything changes.
November 7, 2002 at 5:25 pm
I'll look at tomorrow when I am at a machine with a server.
November 7, 2002 at 5:25 pm
Try using the RIGHT JOIN and ON syntax, it occurrs before the WHERE clause is done, like this (notes in query)
SELECT A.case_number, A.case_log_opnd_date, B.updated_timestamp
FROM Table_A A
RIGHT JOIN Table_B B
ON
B.case_number...
November 7, 2002 at 5:20 pm
quote:
Hardware failure that lost the C: drive. Are those oprhaned data & log files on E: still usable? If so, how?Reinstall SQL...
November 7, 2002 at 5:15 pm
Yeah, you obviously have an unstable table or db going on there. I would make sure you have a copy of the data and be prepared to have to drop...
November 7, 2002 at 5:07 pm
Maybe the databse and not the tabl;e, try DBCC CHECKDB as well.
November 7, 2002 at 4:37 pm
Actally it is a bit easier to use CONVERT(char,GETDATE(),101) as will output as mm/dd/yyyy. See BOL for more detail on CONVERT and other options available.
November 7, 2002 at 4:35 pm
SELECT * FROM [case] WHERE
CASE
WHEN closed_date > ra_date THEN closed_date
ELSE ra_date
END > @input
November 7, 2002 at 4:08 pm
Viewing 15 posts - 4,366 through 4,380 (of 7,429 total)