Viewing 15 posts - 1,216 through 1,230 (of 4,080 total)
CTE is short for "Common table expression", which is an alternative to using a subquery. The CTE is not a temporary table; it produces a result set...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 30, 2010 at 1:21 pm
(1) You must ensure that the second query (following the UNION ALL) produces the same number of columns as contained in the temp table, even if that means forcing...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 30, 2010 at 1:17 pm
Now I want a last row called Aantal which gives in 1948: 2, 1949: 3 etc., which stands for the number of competitions that year (so counting the not NULL...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 30, 2010 at 11:47 am
wilburb (12/28/2010)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 28, 2010 at 2:43 pm
Jack Corbett (12/28/2010)
Now listening to Jeff's Tally Table session on the PASS Summit DVD. Now I have a voice to put with his posts.
Jeff has a GREAT speaking voice.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 28, 2010 at 2:40 pm
I understand. You are showing wisdom by rethinking the process while you can. Best of luck to you in the new year.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 28, 2010 at 1:45 pm
No problem. Thanks for letting us know it's working now. Best of luck to 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
December 22, 2010 at 4:25 pm
I'm afraid I'm not going to be much help. I built and populated the table using your scripts and then ran the original calls to 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
December 22, 2010 at 3:43 pm
Congrats Paul and Gail and Merry Christmas everyone !
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 22, 2010 at 1:26 pm
And who deserves the credit?
And who deserves the blame?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 22, 2010 at 1:25 pm
Please post the schema of the LOGSHEET.dbo.boundary table, and a script to populate a few sample rows and I can have a look at this tomorrow.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 21, 2010 at 11:40 pm
tfifield (12/21/2010)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 21, 2010 at 4:27 pm
!!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 21, 2010 at 3:13 pm
You're welcome, Stephanie, and good luck.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 21, 2010 at 11:25 am
?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 21, 2010 at 9:31 am
Viewing 15 posts - 1,216 through 1,230 (of 4,080 total)