Viewing 15 posts - 4,381 through 4,395 (of 14,953 total)
Steve Jones - SSC Editor (4/26/2011)
BTW, are notifications back to normal for everyone?
I'm still not receiving any at all.
Thought that might be related to the fact that I deliberately opt...
- 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 27, 2011 at 6:44 am
David Portas (4/26/2011)
GSquared (4/26/2011)
If the only way to avoid NULLs is to violate the very religion that is being cited as mandating that they are evil, then that's all I'm...
- 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 26, 2011 at 2:40 pm
Steven993 (4/26/2011)
I think you didn't understand what 1NF is.
Let's take data example to make it clear !!
What you are citing are the properties a 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
April 26, 2011 at 2:26 pm
Well we have a problem here.
I think you didn't understand what 1NF is.
I'm not quoting me. I'm quoting Date. If you really think he doesn't know what 1NF...
- 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 26, 2011 at 2:17 pm
Output doesn't really support full "select" syntax. But it's easy to get around that. Output into a temp table or table variable, then use that for your second...
- 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 26, 2011 at 2:04 pm
GilaMonster (4/26/2011)
Working on PASS abstracts tonight. Am strongly tempted to write one of them at least in verse. Just for fun...
Haiku would be fun.
Shakespearian iambic pentameter would be even better,...
- 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 26, 2011 at 1:41 pm
[Jim].[dba].[Murphy] (4/26/2011)
When the day comes when we meet in person, you'll know how stupid silly strange I really...
- 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 26, 2011 at 1:39 pm
Try this:
SELECT DISTINCT
txn.Terminal,
txn.ActivityDate,
DATEPART(hh, ActivityTime) AS H
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 26, 2011 at 12:01 pm
I wish this did work that way. Learned years ago it doesn't, by making that same "mistake". I think what I did was try inline sub-queries instead 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
April 26, 2011 at 7:03 am
Steven993 (4/25/2011)
What the ??What is violating 1NF, and what is your definition of 1NF ?
I give up, good luck guys 😉
Here's the definition I'm citing:
According to Date's definition of 1NF,...
- 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 26, 2011 at 6:59 am
GilaMonster (4/25/2011)
SQLRNNR (4/25/2011)
Any word on when the Email delay will be fixed?
According to a recent tweet, 'before tomorrow'. They have 37 minutes and counting before tomorrow. Better get working....
- 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 26, 2011 at 6:17 am
T-SQL doesn't allow functions in exec statements that way. You can either pre-calculate the value and store it in a variable, then use the variable in the exec statement,...
- 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 25, 2011 at 1:43 pm
[Jim].[dba].[Murphy] (4/25/2011)
GilaMonster (4/25/2011)
Yesterday I was getting notifications 10 hours late.
That's probably because since you are so far away; it takes longer for the electrons to get there. They only...
- 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 25, 2011 at 1:23 pm
Steven: You do realize that your address lines table violates 1NF, right? Rows are specifically ordered within the data (you even have a column for that), which Date says...
- 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 25, 2011 at 12:57 pm
The "order by 0" piece just puts that first, before 1 or 2. It's just a way to sort the data based on more complex rules.
The IsNull part means...
- 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 25, 2011 at 12:13 pm
Viewing 15 posts - 4,381 through 4,395 (of 14,953 total)