Viewing 15 posts - 1,801 through 1,815 (of 14,953 total)
mayabee (3/27/2012)
Thank you so much for the reply.Not studies but impossible restrictions at my work place.
I've used HAVING and sub query.
Excellent. Sometimes you have to break the rules.
But 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
March 28, 2012 at 6:39 am
Gianluca Sartori (3/27/2012)
GSquared (3/27/2012)
L' Eomot Inversé (3/27/2012)
Stefan Krzywicki (3/27/2012)
GSquared (3/27/2012)
- 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 27, 2012 at 2:12 pm
Did your professor say you had to do it in one step? If not, declare a variable, calculate the average and assign that to the variable, then query 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 27, 2012 at 2:09 pm
L' Eomot Inversé (3/27/2012)
Stefan Krzywicki (3/27/2012)
GSquared (3/27/2012)
- 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 27, 2012 at 2:05 pm
By the way, the reason I call it Numbers instead of Tally is the definitions of the words:
Tally:
NOUN
tal·lies plural
1. record of items: a record or account of...
- 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 27, 2012 at 1:18 pm
MyDoggieJessie (3/27/2012)
So just a table with 1 col, values 1 - n?
Yep.
I usually start mine at 0 though, because there are uses for that. Easy enough to subtract 1...
- 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 27, 2012 at 1:11 pm
MyDoggieJessie (3/27/2012)
Thanks for the hints, I never bothered attempting CTE's for this...definitely something to try - In your example though, where is dbo.Numbers coming from?
A table of Numbers. Like...
- 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 27, 2012 at 12:37 pm
You're welcome.
It's one of those seriously non-intuitive things that can bite anyone, rookie or no.
- 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 27, 2012 at 11:51 am
Here's what I was able to come up with as a sample solution. I imported your CSV file into a table called SampleData, and queried it this way:
;
WITH ...
- 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 27, 2012 at 11:44 am
GilaMonster (3/27/2012)
Jeff Moden (3/27/2012)
GilaMonster (3/27/2012)
Feels...
- 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 27, 2012 at 11:15 am
Ah, just assign everyone a GUID and make them memorize it. Nobody could possibly be masochistic enough to try to memorize someone else's GUID.
More seriously, GUIDs would be a...
- 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 27, 2012 at 9:00 am
Stefan Krzywicki (3/27/2012)
GSquared (3/27/2012)
WayneS (3/27/2012)
- 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 27, 2012 at 8:48 am
Stefan Krzywicki (3/27/2012)
- 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 27, 2012 at 8:46 am
WayneS (3/27/2012)
- 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 27, 2012 at 8:42 am
Can't give you a BOL reference on it, because Microsoft doesn't actually define the sort orders for the Unicode character set. That's done by a standards body. So,...
- 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 27, 2012 at 8:36 am
Viewing 15 posts - 1,801 through 1,815 (of 14,953 total)