Friday, December 28, 2012 10:27 PM
If I want to perform 14 inserts into 7 different temp tables selecting the same data using different dates, where do I specify in my While Loop statement how to do so? Is this correct?
declare@ Loop int
WHILE@ Loop <=14
SET @Loop=@Loop + 1
Should the statement go before or after it selects the appropriate data to insert?
Friday, December 28, 2012 11:39 PMPlease post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. If you know how, follow ISO-11179 data element naming conventions and formatting rules. Temporal data should use ISO-8601 formats. Code should be in Standard SQL as much as possible and not local dialect.
This is minimal polite behavior on SQL forums.
>> If I want to perform 14 inserts into 7 different temp tables selecting the same data using different dates, where do I specify in my WHILE @local_loop_counter statement how to do so? <<
This is a crazy way to write SQL. Temp tables are how non-SQL programmers fake hanging scratch tapes in T-SQL, so they can keep doing magnetic tape file processing and not RDBMS. An SQL programmer would use the date column in the original table (if you had been polite enough to post the DDL) to tell us which of the seven subsets a row belongs. If you need to keep them separate, use VIEWs.
Actually, this is not even a magnetic tape mindset! Have you ever seen a punch card sorter? That is what you are trying to write in T-SQL! Temp tables to mimic sorter pockets!
--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets / Trees and Hierarchies in SQL
Saturday, December 29, 2012 1:13 AMModerator
declare@ Loop int set Loop=1 WHILE@ Loop <=14 BEGIN /************** DYNAMIC SQL here **************/ SET @Loop=@Loop + 1 END
Look how it's done here:
Kalman Toth SQL 2008 GRAND SLAM
New Book: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012
- Unproposed As Answer by Naomi NMicrosoft Community Contributor, Moderator Tuesday, January 01, 2013 7:24 PM
Saturday, December 29, 2012 4:43 AMYes, thats correct
declare@ Loop int set Loop=1 WHILE@ Loop <=14 BEGIN --insert --INSERT STATEMENTS SET @Loop=@Loop + 1 END
Saturday, December 29, 2012 11:21 AM
Tuesday, January 01, 2013 6:29 PMA more polite tone of voice would be greatly appreciated. Thanks but no thanks for the help (also known as being just rude)!
Monday, January 07, 2013 4:53 PMModerator