Viewing 15 posts - 1,546 through 1,560 (of 4,080 total)
I agree its a scope issue, but just out of curiousity, why is the procedure inserting into a table variable or #temp table at all?
All the procedure does...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 28, 2010 at 9:17 am
It's an elegant weapon....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 25, 2010 at 1:39 pm
It didn't like the 5-part columns in the cte because the table you joined wasn't part of the CTE. It may help conceptually to think of the CTE...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 18, 2010 at 7:31 am
I'm reasonably soft-spoken at most times.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 18, 2010 at 7:24 am
Testing...
Testing...
Is this Thread on?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 17, 2010 at 10:16 pm
crookj (6/17/2010)
Stan Lee!Joe
Jack "King" Kirby
(Nice pic of The Vision, by the way.)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 17, 2010 at 1:50 pm
'Nuff Said
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 17, 2010 at 12:15 pm
frivolity
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 17, 2010 at 7:29 am
Antici....
(say it)
(say it)
(say it)
.... pation
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 16, 2010 at 7:25 am
The dbms wasn't even SQL Server.
So it is relevant here how? Respectfully, you should just let this go ... you're making a really poor impression. I've tried...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 15, 2010 at 2:16 pm
Do you consider it rows to be duplicates if ANY of the columns match, or only if ALL of those columns match?
Post up a few sample rows and what you...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 15, 2010 at 10:09 am
One guess is that FFS = For F___'s Sake. Let's not speculate as to the missing f-word.
Posting answers for homework assignments does nothing to further the community, or...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 15, 2010 at 10:05 am
I thought it was round by design. Without starting up the whole "football" debate again, it must be noted that there are other games where the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 15, 2010 at 9:47 am
vuvuzela'ed
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 15, 2010 at 7:44 am
Hey John:
Speaking as one who has been "schooled" at SSC (by Jeff, but also by many others), the many mentors provided online by SSC is not to be scoffed at....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 15, 2010 at 7:41 am
Viewing 15 posts - 1,546 through 1,560 (of 4,080 total)