The whole reason to use a variable is if you are planning on doing this over and over and over again, each time with a potentially different value, as part...

declare @Today datetime

--select @today = '4/14/08'

select @today = getdate()

declare @MonthBack datetime, @FirstPeriod datetime, @SecondPeriod datetime

select @MonthBack = convert(varchar(20), dateadd(month, -1, @Today), 1)

select

@FirstPeriod =

case

when datepart(day, @Today) > 15 then...

What we'd really need would be to know what the most common selects are for the table, and to see some execution plans for them. With that, and the...

If I'm not mistaken, the way to do what you're trying to do, is back up the log file, then restore the old database backup with "norecovery", then restore the...

In some cases, devs are users, in that...

Matt Miller (4/16/2008)

yup! Looks like the issue is well in hand...It's one...

SELECT

GolferID, t2.CourseID

, t2.Hole1 - t1.Hole1

, t2.Hole2 - t1.Hole2

, t2.Hole3 - t1.Hole3

FROM

...

You'll need a log parsing program for that. Something like RedGate's SQL Log Rescue, or ApexSQL Log, or Lumigent's product (don't remember the name at the moment).

Matt, I think we cross-posted. See my prior cross-post to your cross-post of my first post. 🙂

This is a duplicate post. There are answers on the other copy with details.

Please move this question to the SQL 2000 Forum. You'll probably get better results there.

Since I haven't done a migration from 2000 to 2005 that included full-text indexes, all I can say is that your best bet it to go to MSDN and/or Books...

Yep, Matt's right (as usual). There's an implicit conversion because of the "else" statement.

I tried this, to see what SQL would do:

select

case

when len(datepart(mm, getdate())) = 1

then cast(0...

Interesting. I tried using:

select right(char(48) + datepart(mm, getdate()), 2)

and got "4", instead of "04". Would have thought that would do it, but was wrong.

On the other hand:

select right(char(48)...

Have you tried using varbinary(max), instead of image, for the data type? For SQL 2005, that's recommended, and might help with what you're doing.