Script for dynamically creating temp tables
 I am new to SQL, Can anybody help me to create dynamic temp tables.

Stage 1: Basic Sales Information data (getting the data from multiple tables)
|
|
Stage 2: Above sales person might have sold product in different cities ( 1 or many). Need to Sales Id, sales city name, branch name etc (master info)
|
|
Stage 3 : Show the sales data for above city

At stage 2, i need to create dynamic temp tables for each city. Table variables may not be supported since it has huge data. 
December 2nd, 2014 7:17am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics