Viewing 15 posts - 1,861 through 1,875 (of 14,953 total)
KWymore (3/21/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 21, 2012 at 8:19 am
halifaxdal (3/20/2012)
In MANY records showing "Table 1 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
March 21, 2012 at 4:56 am
I think there's a lot to this subject. It's not a simple situation.
For example, we don't graduate people from school with the skills of problem solving, interpersonal dynamics, technical...
- 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 20, 2012 at 9:48 am
If you mean a column in a table, you can add a default value to one, like this:
alter table dbo.MyTable
add default(0) for MyColumn ;
You'll need to use real table and...
- 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 20, 2012 at 8:03 am
Is the "most recent date" the most recent ConnectedDate? If so, this will already do that. The Max() function in the sub-query does 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
March 20, 2012 at 6:42 am
Lynn Pettis (3/16/2012)
GSquared (3/16/2012)
Lynn Pettis (3/16/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 16, 2012 at 11:13 am
SSAS is definitely worth looking in to for this.
As far as references on where to go and how, I'd check the Microsoft Press books on the subject, and then dig...
- 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 16, 2012 at 10:18 am
Lynn Pettis (3/16/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 16, 2012 at 10:14 am
Do a "Full Outer Join" between the two, on Name and Code, with whatever rules you need for other columns.
Something like:
SELECT *,
...
- 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 16, 2012 at 9:15 am
Koen Verbeeck (3/16/2012)
Back on-topic:http://www.sqlservercentral.com/Forums/Topic1268199-391-1.aspx
Or am I working with SQL too long to realize this is an ordinary beginner's question? Am I asking too much?
Could just be that the guy asking...
- 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 16, 2012 at 8:09 am
I don't think Year is SARGable. Better bet is "DateModified < '1/1/2012'".
SARGability may not matter much in this case, since it's liable to pull a range of data 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 16, 2012 at 8:08 am
I can't test this, since I don't have table definitions, et al, but it should do what you need:
IF (@Type = 'GP')
BEGIN
...
- 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 16, 2012 at 7:22 am
GilaMonster (3/15/2012)
Koen Verbeeck (3/15/2012)
It can be no coincidence that this topic is full of elite DBA's!Damn, they're everywhere. How are honest developers supposed to get anything done I ask you.
You're...
- 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 16, 2012 at 7:12 am
Koen Verbeeck (3/15/2012)
GSquared (3/15/2012)
... world conquest through a secrect society of elite DBAs.
*gasp*
It can be no coincidence that this topic is full of elite DBA's!
(for some strange reason I first...
- 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 16, 2012 at 7:11 am
Jeff Moden (3/15/2012)
GSquared (3/15/2012)
Jeff Moden (3/14/2012)
anthony.green (3/14/2012)
Jeff Moden (3/13/2012)
anthony.green (3/12/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 16, 2012 at 6:57 am
Viewing 15 posts - 1,861 through 1,875 (of 14,953 total)