Viewing 15 posts - 14,161 through 14,175 (of 14,953 total)
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 17, 2008 at 11:12 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 17, 2008 at 11:07 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 17, 2008 at 9:09 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 17, 2008 at 7:27 am
Jeff Moden (4/16/2008)Heh... you saw the definition of "users" right after my 3 rules... developers ARE users and they can be the worst///
In some cases, devs are users, in that...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 17, 2008 at 7:18 am
Matt Miller (4/16/2008)
GSquared (4/16/2008)
Matt, I think we cross-posted. See my prior cross-post to your cross-post of my first post. 🙂
yup! Looks like the issue is well in hand...It's one...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2008 at 2:32 pm
SELECT
GolferID, t2.CourseID
, t2.Hole1 - t1.Hole1
, t2.Hole2 - t1.Hole2
, t2.Hole3 - t1.Hole3
FROM
...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2008 at 2:12 pm
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).
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2008 at 2:08 pm
Matt, I think we cross-posted. See my prior cross-post to your cross-post of my first post. 🙂
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2008 at 2:04 pm
This is a duplicate post. There are answers on the other copy with details.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2008 at 1:59 pm
Please move this question to the SQL 2000 Forum. You'll probably get better results there.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2008 at 1:56 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2008 at 1:53 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2008 at 1:48 pm
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)...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2008 at 1:43 pm
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2008 at 1:31 pm
Viewing 15 posts - 14,161 through 14,175 (of 14,953 total)