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...

ggraber already answered your question. The best thing I could suggest at this time is for you to test it yourself. All you need to do is create...

rshafer (12/3/2008)

---

I appreciate everyone's responses regarding the date_time field. After talking with one of my fellow DBA's I used the BETWEEN command to select the dates. Here is...

Doug (12/2/2008)

---

The following two statements are taking 1:13 hours to run. How can I speed it up?

UPDATE dbo.CLAIMS SET admission_date =...

skjoldtc (12/2/2008)

---

I have a question for the frequent posters? Do you spend you employer's time answering questions here or are you doing it on your own time. If on your...