Viewing 15 posts - 4,501 through 4,515 (of 14,953 total)
jcrawf02 (3/25/2011)
Stefan Krzywicki (3/25/2011)
GSquared (3/25/2011)
jcrawf02 (3/25/2011)
GSquared (3/25/2011)
GilaMonster (3/25/2011)
I just realised I don't have an April Fools day blog post planned. 🙁
So start a completely serious post with, "I had this...
- 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 25, 2011 at 9:59 am
Stefan Krzywicki (3/25/2011)
GSquared (3/25/2011)
Stefan Krzywicki (3/25/2011)
GSquared (3/25/2011)
- 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 25, 2011 at 9:51 am
Honestly, for sequential code like this and other running totals problems, I avoid the quirky update and use CLR assemblies, or a Static or Fast Forward cursor. Those are...
- 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 25, 2011 at 9:41 am
Don't do the unions thing. It's a pain to modify/extend/maintain.
create table dbo.Combos (
Diag1 char(10) not null,
Diag2 char(10) not null,
primary key (Diag1, Diag2));
GO
insert into dbo.Combos... -- put the valid Diag...
- 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 25, 2011 at 9:38 am
GilaMonster (3/25/2011)
GSquared (3/25/2011)
GilaMonster (3/25/2011)
GSquared (3/25/2011)
- 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 25, 2011 at 9:33 am
GilaMonster (3/25/2011)
GSquared (3/25/2011)
I'm a DM. Have been since the mid-70s when D&D first came out. I'm essentially infinitely evil. 🙂 Have to be, for the entertainment value.RBDM!
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
March 25, 2011 at 9:17 am
Stefan Krzywicki (3/25/2011)
GSquared (3/25/2011)
- 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 25, 2011 at 9:14 am
Put the combos in a table, join the table to itself via that, you'll have a solid, extensible solution that can easily accommodate more combos if/when business rules change, without...
- 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 25, 2011 at 8:49 am
jcrawf02 (3/25/2011)
GSquared (3/25/2011)
GilaMonster (3/25/2011)
I just realised I don't have an April Fools day blog post planned. 🙁
So start a completely serious post with, "I had this idea for an April...
- 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 25, 2011 at 8:45 am
It's a relatively simple mathematical pattern, but more rules are needed to have a complete solution.
For example, what would you do with a group that has more entries than 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
March 25, 2011 at 8:43 am
The CTE version will work. My first instinct was a simple Inner Join between two iterations of the 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
March 25, 2011 at 7:24 am
ananda.murugesan (3/25/2011)
Thanks for reply--Group by function - need to specify for all select column..
Why? For this query, it's not doing anything useful that I can see.
- 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 25, 2011 at 7:16 am
Sounds like the sa password got changed. Change it back, or reset it and rework your application or whatever is using it.
You shouldn't have an application using sa anyway,...
- 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 25, 2011 at 7:14 am
Gianluca Sartori (3/25/2011)
Fal (3/25/2011)
- 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 25, 2011 at 7:11 am
Why are you grouping at all? Group By is for controlling data break-down on aggregate functions.
- 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 25, 2011 at 7:07 am
Viewing 15 posts - 4,501 through 4,515 (of 14,953 total)