Viewing 15 posts - 8,836 through 8,850 (of 14,953 total)
You're welcome.
Yeah, this site is pretty cool. Gotta agree with 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
August 5, 2009 at 1:46 pm
The RedGate one is what I'm more familiar with.
When I want to export the data, I generally just query it myself directly.
- 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
August 5, 2009 at 1:16 pm
cast(
case sum(IsNull(hmss.delivered_to_date, 0))
when 0 then 0
else
...
- 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
August 5, 2009 at 1:13 pm
Bob Hovious (8/5/2009)
I know... otherwise I would never have dared to say that 😉
LOL!!!
Gail, your intimidation skill must be out the roof!
- 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
August 5, 2009 at 1:02 pm
You can use @@Rowcount and your @value variable that way.
If you use @@Rowcount with a Where clause like you have, the code will compile and run, but it won't give...
- 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
August 5, 2009 at 1:00 pm
You'd do the same thing as with the other division issue that I posted.
Use NullIf to turn the denominator into a null if it's zero, then use IsNull to replace...
- 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
August 5, 2009 at 12:55 pm
Would "Paxton" be considered a valid "is contained by" for "Paxtonville"?
If so, then use something like:
select *
from TableA
inner join TableB
on TableA.Place like '%' + TableB.Place +...
- 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
August 5, 2009 at 12:03 pm
You're welcome.
- 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
August 5, 2009 at 11:58 am
SQAPro (8/5/2009)
GSquared (8/5/2009)
If your company loses an average of one laptop per year, and spends an extra $100k per year on...
- 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
August 5, 2009 at 11:58 am
Grant Fritchey (8/5/2009)
I'm feeling a bit stupid. I thought RPG = Role Playing Game.
Role Playing Game
Rocket Propelled Grenade
Report Program Generator
Reasonable and Probable Grounds
And more, I'm sure.
One could even say, "In...
- 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
August 5, 2009 at 11:38 am
Forums are fine for whatever, but I second the idea of submitting it as an article.
- 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
August 5, 2009 at 11:33 am
Are you saying that the field contains more than one place name per row, in that column? That's what I'm reading it as, but I'm not certain I'm understanding...
- 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
August 5, 2009 at 11:30 am
This is probably/possible where the Div 0 error comes from:
SUM(hmss.BEDDING_CLOSE)/SUM(hmss.BEDDING_OPP)
If you use NullIf on the Bedding_Opp sum, you should be able to get rid of the error. If 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
August 5, 2009 at 11:26 am
Try this, see if it'll do what you need:
create table #T (
ID int identity primary key,
Col1 char(10));
insert into #T (Col1)
select 'AC/01/2008' union all
select 'AC/02/2008' union all
select 'AC/03/2008' union all
select 'AC/04/2008'...
- 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
August 5, 2009 at 11:21 am
Is it an inline or multi-value UDF?
Multi-value UDFs are treated like table variables by the database engine, which means it estimates one row per call, regardless of how many it...
- 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
August 5, 2009 at 9:47 am
Viewing 15 posts - 8,836 through 8,850 (of 14,953 total)