Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Temp Table Expand / Collapse
Author
Message
Posted Tuesday, June 25, 2013 8:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
Tock (6/25/2013)
Perfect question for the morning after a night with little sleep

Cheers,

Steve


Unless you didn't read the question properly and skimmed the part about opening another query window... doh!


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1467165
Posted Tuesday, June 25, 2013 9:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 13, 2014 5:33 AM
Points: 3, Visits: 10
Easy one.
Post #1467227
Posted Tuesday, June 25, 2013 11:13 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
Interesting and easy - thanks!
Post #1467295
Posted Tuesday, June 25, 2013 10:11 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:35 AM
Points: 3,366, Visits: 2,006
I was looking for the trick in this question and was thankful that there wasn't one. Nice question on a basic function.
Post #1467438
Posted Wednesday, June 26, 2013 12:07 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:43 AM
Points: 865, Visits: 166
Fine....
Post #1467456
Posted Wednesday, June 26, 2013 6:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 6:22 AM
Points: 271, Visits: 96
Session related
Post #1467606
Posted Thursday, June 27, 2013 6:51 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 13,368, Visits: 11,148
Easy one, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1468117
Posted Friday, June 28, 2013 5:21 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:50 AM
Points: 17,854, Visits: 15,802
Good back to basics question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1468742
Posted Wednesday, July 3, 2013 4:41 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, October 10, 2014 7:07 AM
Points: 3,545, Visits: 2,654
Very easy question. Surprised to see almost 18% still choosing incorrect answer. Though it was smart to emphasize on extra column within the same temp table in order to confuse.
Post #1469980
Posted Sunday, July 7, 2013 12:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 21, 2013 12:45 AM
Points: 46, Visits: 47
Hey great it revised my concepts about the difference between local and global temp tables.
Post #1470966
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse