Viewing 15 posts - 10,846 through 10,860 (of 14,953 total)
Should work just fine with user.Numbers.
I'm not sure why it's giving you an error about ID not being a valid column. Can you copy-and-paste the query into the forum?
- 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
February 23, 2009 at 7:51 am
Lynn Pettis (2/20/2009)
GSquared (2/20/2009)
Lynn Pettis (2/20/2009)
Okay, How many of you out there have gotten AARP membership invitations in the mail in the last year??
I've received one, but it wasn't 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
February 20, 2009 at 2:59 pm
Type the words "Create View" and the name of the view, at the top of it. Then add "AS" between the name of the view and the first 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
February 20, 2009 at 2:57 pm
Yes.
- 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
February 20, 2009 at 2:45 pm
Lynn Pettis (2/20/2009)
Okay, How many of you out there have gotten AARP membership invitations in the mail in the last year??
I've received one, but it wasn't in the last year,...
- 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
February 20, 2009 at 2:39 pm
Honestly, I don't know why the query needs to have the totals in it. Usually, that's something that you do in the web page or other application, not 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
February 20, 2009 at 2:37 pm
I've been playing various flavors of D&D and it's imitators since the mid-70s.
As a DM, I've been accused of having the best "wicked grin of doom" by several players.
- 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
February 20, 2009 at 2:31 pm
Lynn Pettis (2/20/2009)
Told you, my desert. Heat, can't see, where am I??
Well, it's called "Death Valley", and it's called that for a reason...
http://en.wikipedia.org/wiki/Death_Valley_National_Park
(My family made the mistake of going...
- 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
February 20, 2009 at 1:53 pm
Lynn Pettis (2/20/2009)
Grant Fritchey (2/20/2009)
Lynn Pettis (2/20/2009)
Alvin Ramard (2/20/2009)
He's gone multi-threaded!!!!Is it contagious???
I quit. He's on his own. Total failure.
Uh oh. I think you helped him with your last...
- 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
February 20, 2009 at 1:43 pm
Just did the same test in SQL 2000, and the temp tables from one connection ended with one number, while the tables from the other connection had a different number....
- 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
February 20, 2009 at 1:37 pm
Try this:
SELECT
dbo.BOCLEARED.BOCLEARED,
dbo.CTCLEARED.CTCLEARED,
dbo.MECLEARED.MECLEARED,
dbo.NHCLEARED.NHCLEARED,
dbo.RICLEARED.RICLEARED,
dbo.WOCLEARED.WOCLEARED,
dbo.VTCLEARED.VTCLEARED,
dbo.ALLCASESCLEARED.TOTALCLEARED,
dbo.ALLCASESCLEARED.CLEAREDDATE,
dbo.ALLCASESCLEARED.DDS
FROM
dbo.BOCLEARED
FULL OUTER JOIN dbo.ALLCASESCLEARED
ON dbo.BOCLEARED.BOCLEAREDDATE = dbo.ALLCASESCLEARED.CLEAREDDATE
FULL OUTER JOIN dbo.CTCLEARED
ON dbo.CTCLEARED.CTCLEAREDDATE...
- 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
February 20, 2009 at 1:27 pm
You have to run it in the database that has the tables and views in it. If that database is ROCAPData, then run it in there.
- 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
February 20, 2009 at 12:26 pm
I just have to ask: What does not knowing someone's name have to do with being new to SQL? If you look at your own posts, you'll see 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
February 20, 2009 at 12:24 pm
I've built a couple of systems like that. One was really simple. I gave the users a list of the parameters they could choose, and hard-coded those into...
- 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
February 20, 2009 at 12:22 pm
Even without the execution plan, we'd need the table definitions and some sample data to test this out with. Can you provide 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
February 20, 2009 at 12:10 pm
Viewing 15 posts - 10,846 through 10,860 (of 14,953 total)