Viewing 15 posts - 721 through 735 (of 1,319 total)
Jason Shadonix (3/26/2009)
RBarryYoung (3/26/2009)
ganeshi (3/26/2009)
This works on both SQL 2000 and 2005 and produces answer (c). Please amend the question to be more specific about SQL versions.Ganesh
I have tested it...
-- You can't be late until you show up.
March 26, 2009 at 8:55 am
Just a hunch based on what your expected output is but category ID is 11, 12 and 13 not 1, Maybe where left(categoryId, 1) = 1 is what you're trying...
-- You can't be late until you show up.
March 24, 2009 at 12:59 pm
Should be getdate() not [date]
Select case when (leavedate is null)
then datediff (day,enterdate,getdate())
else datediff (day,enterdate,leavedate)
end as 'totaldays'
from reservations
-- You can't be late until you show up.
March 23, 2009 at 2:32 pm
You'll need to make the obvious database/mdf/ldf/path name changes. Look up restore database in BOL for more options.
RESTORE DATABASE [LIVE1]
FROM DISK = 'C:\Backup\LIVE.bak'
WITH...
-- You can't be late until you show up.
March 23, 2009 at 2:24 pm
see your other post:
http://www.sqlservercentral.com/Forums/Topic681196-5-1.aspx
-- You can't be late until you show up.
March 23, 2009 at 12:25 pm
There are a few "demo" alerts that come with SQL server 2000, these being two of them. Mine are enabled so they will fire if a threshold has been reached,...
-- You can't be late until you show up.
March 23, 2009 at 12:23 pm
One thing I would suggest - email on failure only. You'd be surprised how de-sensitized you will become to the influx of emails, especially if 99.9% are successes. If the...
-- You can't be late until you show up.
March 23, 2009 at 7:53 am
SUBRAHMANYA HEDGE (3/23/2009)
But I think one can use Truncate_only with proper planning...
There is no proper planning for this type of task. It should be used on rare occasions where a...
-- You can't be late until you show up.
March 23, 2009 at 7:45 am
On the SQL server machine, right-click on my computer and select "Manage". Expand shared folders and click on "Open Files". Search for your file name to determine who has a...
-- You can't be late until you show up.
March 23, 2009 at 7:38 am
Please don't tell us you haven't had a backup in nearly 6 months???? And is so, what took so long to find a resolution?
-- You can't be late until you show up.
March 20, 2009 at 3:16 pm
Can you locate the script that's generating the backups? You cannot do a differential via a maintenance plan so there has to be a script somewhere. One of the backup...
-- You can't be late until you show up.
March 20, 2009 at 3:08 pm
And, obviously, be sure you have a full, clean backup before starting. It should be a pretty straight forward process but you never know.
-- You can't be late until you show up.
March 20, 2009 at 6:53 am
dmoldovan (3/19/2009)
As I can see from the sample data, the quote seems rather the "text qualifier"...Halifaxdal, can you tell which separator was used when creating the text file?
I realized that...
-- You can't be late until you show up.
March 19, 2009 at 7:58 am
Based on your sample data, wouldn't you use quote separated or am I missing something? Using the import wizard, I believe it's the first or second screen after you select...
-- You can't be late until you show up.
March 19, 2009 at 7:49 am
Viewing 15 posts - 721 through 735 (of 1,319 total)