Fast way to create temp table from existing table definition

Question

Post reply

Fast way to create temp table from existing table definition

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 1

Ohhh... Sorry KG... my comments weren't directed at you personally...

I've even seen some of the big dogs in SQL perpetuate such myths and that was my point to everyone. Don't do the 5 monkeys thing... just because someone (even Microsoft) says something , it's good to either do your own test or run some test code that someone else made to verify the findings. If you have the opportunity to help someone else out with the same problem, also forward the test code whether you make it or borrowed it... keeps myths and SQL Clones from happening.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

KingGorilla Old Hand Points: 367 More actions · Answer 2

That's cool , no offence was taken... it was my slightly dry sense of humour 😀

I don't mind being corrected or proved wrong at any time, its the only way to continue to learn. If i went around with blinkers on i'd miss most of the good stuff.

Altho saying that, i'm going to do some tests locally just to prove it to myself 😛

KG

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 3

Let us know how the tests work out... even if it's just confirmation but especially if you find something new or different. 🙂

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions