You need to put double quotes around the filename, like this: "C:\Information technology\Dral\Dral_ENC.zip"

Just so you know, this is a MS SQL Server site. There may not be many people here who will be able to help you with PL/SQL. Most...

Here is some code you can work with. If you have a test environment, test it there first. You do need to make some adjustments to the code...

Because you are working with an...

What is your fiscal year for reporting? For instance Fiscal Year 2009 (our current fiscal year) is July 1, 2008 through June 30, 2009.

May I ask another dumb question? If you are going to update these fields using another procedure, why are you trying to set them to null, why not just...

Here is another idea. The first update will take about 49 minutes (as seen earlier), but the second should actually run faster!

declare @BatchSize int;

set @BatchSize = 10000;

while exists(select 1...

Never mind my post above, it won't work. I am having a brain dead day here at work and it is seeping over to here. You'd still need...

[font="Arial Black"]IGNORE THIS POST, but I still want people to see it.[/font]

My original code:

declare @BatchSize int;

set @BatchSize = 10000;

while exists(select 1 from dbo.Claims where admission_date is not null

begin

...

Doug (12/3/2008)

---

Thanks Lynn for your input, but it's not helping me much. I ran the script you posted and the 1st statement had 213 batches and took 49 minutes....

If your database is using the simple recovery model, t-log backups aren't needed. I put that comment in for two reasons; one, you didn't mention the recovery model the...

Or this:

declare @InputDate datetime,

@Increment int;

set @InputDate = getdate();

set @Increment = 0; -- Find EOM for current month

select dateadd(mm, datediff(mm, 0, @InputDate) +...

Here is some more code for you to review:

declare @InputDate datetime,

@Increment int;

set @InputDate = getdate();

set @Increment = 0; -- Find EOM for...

What I would suggest is using the TVF to load properly indexes temporary tables with the appropriate data, then use the temporary table in your master query for reporting.

Should not be an issue either. I would start looking a permissions, on the directories you are attempting to restore the databases, as well as that of the user...