Viewing 15 posts - 6,916 through 6,930 (of 14,953 total)
As an additional note, on the point of ending up with words or approximations of words (think words made from H8 (hate), or with 2 (to or too) in them,...
- 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
March 15, 2010 at 3:28 pm
Are you using the full alphabet for this? If so, are you prepared to deal with "IDs" that are obscenities, racial slurs, sexual, blasphemous, etc?
If so, here's sample code...
- 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
March 15, 2010 at 3:17 pm
Alvin Ramard (3/15/2010)
GilaMonster (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?DECLARE @selectDate = getdate()-365
Leap years are vastly overrated.
We should roll back the clocks (and calendars) by 24 hours...
- 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
March 15, 2010 at 2:38 pm
Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?DECLARE @selectDate = getdate()-365
Yes, in SQL Server 2008 it is missing the data type. Should...
- 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
March 15, 2010 at 12:04 pm
Roy Ernest (3/15/2010)
Happy B'Day Grant...And Gus Belated B'day wishes for you.
Thanks. 🙂
- 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
March 15, 2010 at 10:21 am
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm curious as to what the actual age difference is.) If you'd...
- 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
March 15, 2010 at 9:29 am
How are you defining "first row"? There's nothing in the table that indicates the sequence.
If you want to update only one row, and don't care which one, or have...
- 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
March 15, 2010 at 9:27 am
I'm not sure what you mean by "how many states in server". Can you clarify that part of the question?
- 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
March 15, 2010 at 8:14 am
jcrawf02 (3/15/2010)
Alvin Ramard (3/12/2010)
Ok, it's Friday and I'm getting tired.Just got an email from Apple saying "iPad is coming ...."
I clicked <Reply> SO? <Send>
😎
Ok, so painting a flame target on...
- 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
March 15, 2010 at 8:12 am
Steve Jones - Editor (3/15/2010)
- 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
March 15, 2010 at 8:00 am
I'm currently doing the same. No problem setting it up, running it, etc. Just update before you start the service.
- 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
March 15, 2010 at 7:41 am
jcrawf02 (3/15/2010)
- 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
March 15, 2010 at 7:39 am
It sounds like you have a pretty standard "upsert" situation there. (That's short for "update or insert".)
Most of those can be handled very simply by doing an update on...
- 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
March 15, 2010 at 7:33 am
Try a couple of solutions.
The SQL 2008 "Merge" command might do exactly what you need. Try that.
Truncate and reload works, but gets slower and slower as you get more...
- 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
March 15, 2010 at 7:25 am
Okay. Now that I've read the article, I have to say I like some of the ideas in it.
It's nothing particularly original, but it's a good expression of 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
March 15, 2010 at 7:22 am
Viewing 15 posts - 6,916 through 6,930 (of 14,953 total)