Viewing 15 posts - 9,466 through 9,480 (of 14,953 total)
In order to digest, start with my two examples, then read the bit in Books Online on "Create View". You'll see the elements from that in the examples.
Once you...
- 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
May 22, 2009 at 9:33 am
Sorry I didn't give an example, glad you worked it out. I've seen that kind of error lots of times, and it's almost always caused by dividing integers by...
- 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
May 22, 2009 at 9:32 am
Memorial Day in particular is about remembering those who have fought and even died for our freedom. My grandparents were WW II vets, my great grandparents were POWs in...
- 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
May 22, 2009 at 9:06 am
Steve Jones - Editor (5/21/2009)
Sinanju, haven't read that in a long, long time.
I used to have the first 100 or so books. Definitely entertaining.
I can easily see:
"I am created...
- 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
May 21, 2009 at 2:43 pm
Bob Hovious (5/21/2009)
You never know... she might be of those Zen archers. Walks out into her yard... tests...
- 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
May 21, 2009 at 2:03 pm
Here's another example. In this one, I set the ID column of one of the tables to be negative 1 with an increment of minus 1, so I can...
- 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
May 21, 2009 at 1:20 pm
A view with Union All in it can allow for edits to the underlying table data, IF there is a key in the two tables that indicates precisely which table...
- 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
May 21, 2009 at 1:18 pm
Are the numbers integers? If so, cast/convert to float as part of the calculation.
- 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
May 21, 2009 at 12:19 pm
GilaMonster (5/21/2009)
Oh yay. 🙁Another email accusing me of personal attacks and damaging someone's public image by 'misleading' people about his statements.
Sometimes I wonder why I bother.....
For the entertainment value, obviously.
- 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
May 21, 2009 at 8:41 am
Roy Ernest (5/20/2009)
All of you need a vacation... You have all gone crazy.... 😛
I've always maintained I'd have to drive a long ways in reverse to get back to crazy.
- 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
May 21, 2009 at 7:10 am
GSquared (5/19/2009)
Greg Snidow (5/19/2009)
GSquared (5/19/2009)
Get rid of the semicolons, the function will still run, it's just less "clean".
I often see code with semicolons here, but usually without. I 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
May 19, 2009 at 11:46 am
Greg Snidow (5/19/2009)
GSquared (5/19/2009)
Get rid of the semicolons, the function will still run, it's just less "clean".
I often see code with semicolons here, but usually without. I have queried...
- 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
May 19, 2009 at 11:43 am
Linked tables may be the way to go now. What I was doing was Access 2000, then 2003, on SQL 2000, then 2005. I haven't worked with later...
- 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
May 19, 2009 at 11:40 am
That's very similar to the situation I had when I started out. Access as the front-end to SQL as the database works quite a lot better than just plain...
- 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
May 19, 2009 at 9:43 am
Having an "OR" in the Where clause often eliminates the ability for SQL Server to do an index seek. Instead, it ends up being forced to do index scans....
- 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
May 19, 2009 at 9:23 am
Viewing 15 posts - 9,466 through 9,480 (of 14,953 total)