Viewing 15 posts - 9,151 through 9,165 (of 14,953 total)
Roy Ernest (6/30/2009)
So I assumed, and was apparently incorrect in that. (I hope this wasn't obfuscatory. I'm trying to be as precise as possible here, and am now assuming singular...
- 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
June 30, 2009 at 1:24 pm
john.arnott (6/30/2009)
3NF-Boy got me ROFL with this response:w00t:. I can't wait to see Gus's answer. 😉
No more waiting required. Let me know if...
- 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
June 30, 2009 at 1:09 pm
smsam1 (6/30/2009)
thanks.i do understand your grammer easily. 🙂
but how can u assume that english is not my first language?
Sorry about that. I'm just used to things like this:
ya.. 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
June 30, 2009 at 1:07 pm
Use Excel. Export it to text files, and use the XML file format to tell OpenRowset what the column definitions are and how many rows to skip at 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
June 30, 2009 at 12:03 pm
It'll mean that, if the data every grows beyond the size of the allocated files, you'll get errors. Not having autogrow on is what will cause that. What...
- 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
June 30, 2009 at 11:57 am
That's accurate. More grammatically correct would be, "Column 'has_passed' is transitively dependent on columns 'student_id', and 'subject_id' via column 'marks'." (I'm assuming from the posts that English is...
- 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
June 30, 2009 at 7:36 am
"Disaster" is always subjective.
- 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
June 30, 2009 at 7:33 am
Nah. If the default is overriding the character set, setting the collation for the select won't fix 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
June 30, 2009 at 7:27 am
I like the idea of an XML structure for commenting. Never thought of that myself, and haven't run into it as a practice.
Where documentation standards have been set for...
- 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
June 30, 2009 at 7:21 am
GilaMonster (6/29/2009)
GSquared (6/29/2009)
GilaMonster (6/14/2009)
$Deity's gift to ITYep!
Is it stuck above your monitor?
So far, yes. I still plan to turn it into a t-shirt.
- 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
June 29, 2009 at 3:08 pm
jcrawf02 (6/29/2009)
GSquared (6/29/2009)
- 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
June 29, 2009 at 3:06 pm
Try this:
select hmss.employee_code
from dw_historical_monthly_salesman_sales as hmss, sales_contests sc
where sc.contest_id = 11 and
hmss.commission_month between '5-1-09' and '6-30-09'
group by hmss.employee_code
having count(*) > 1
That'll at least tell you which...
- 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
June 29, 2009 at 3:02 pm
GilaMonster (6/29/2009)
jcrawf02 (6/29/2009)
GSquared (6/29/2009)
- 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
June 29, 2009 at 2:55 pm
Lynn Pettis (6/29/2009)
AARRRGGGG!!!When will people learn to read???
Reading leads to learning. Learning leads to knowledge. Knowledge leads to power. Power corrupts!
- 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
June 29, 2009 at 11:33 am
Lynn Pettis (6/29/2009)
- 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
June 29, 2009 at 10:15 am
Viewing 15 posts - 9,151 through 9,165 (of 14,953 total)