Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Creation of Temporary tables in T-sql

Posted on 2008-10-02
4
Medium Priority
?
505 Views
Last Modified: 2012-05-05
I would like to know whether I should create temporary tables in the main procedure or in the called procedure, and please state your reasons why.
0
Comment
Question by:countrymeister
  • 2
4 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 22628664
Please state your programming needs, as that will dicate the use or not use of temporary tables, and not whatever I believe.
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22628673
The scope of a temp table can only go down, not up.  So if you think you might need the data in the calling procedure, create it there.  It can be referenced and populated by any procedure in the procedure call stack at that point.
0
 
LVL 1

Author Comment

by:countrymeister
ID: 22628951
jimhorn

I have a main procedure which gathers data from the database and makes call to  another four procedures. In one of those four procedures I need to load data into a temporary table which is then used further down by another two procedures for calculatioion and data manipulation.

All the execs for the four procs are done from the main proc.
0
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 1000 total points
ID: 22629671
Then the main proc is where it needs to be created in order for the data to be shared.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Integration Management Part 2

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question