Temporary tables - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Temporary tables

Author

Topic

ricks1683
Starting Member

14 Posts

Posted - 2007-06-07 : 15:38:45

Hi again.

I'm having some problems understanding temporary tables. I've created a temporary table using the "Create Table #ASLClass" statement and have successfully inserted values into the table. That part is not the problem. In a second query, during the same session, i want to select items from my temporary table and i am getting the message
"Server: Msg 208, Level 16, State 1, Line 1
Invalid object name '#ASLClass'."

Why am i getting this message and what is the correct way to create or reference my temp table? I'll put the codes below. I would really appreciate any help.

Thanks again

Rick R.

<<Code 1 - Creating Temporary Table>> (I'm only putting the first 10 or so rows of inserted data because there are over 150 rows i have entered....)

CREATE TABLE #ASLClass (
Asl char(3),
Preil Char(3),
Descr Char(50),
Aslob Char(6))

INSERT INTO #ASLClass (Asl, Preil, Descr, Aslob) VALUES ('160', '32', 'WORKERS COMPENSATION', 'WC');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '100', 'AUTO BODILY INJURY/PROPERTY DAMAGE, CSL', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '530', 'CSL PREMISES/OPERATIONS', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '531', 'CSL PRODUCTS/COMPLETED OPERATIONS', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '546', 'PERSONAL & ADVERTISING INJURY LIABILITY', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '547', 'DAMAGE TO PREMISES RENTED TO YOU', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '548', 'MEDICAL PAYMENTS', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '714', 'COVG M - MEDICAL PAYMENTS', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '750', 'FULL TIMERS LIABILITY BI', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '751', 'FULL TIMERS BI/PD COMBINED LIABILITY', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '752', 'VACATION LIABILITY', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '729', 'PIP WORK LOSS', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '730', 'AUTO PIP', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '731', 'AUTO PIP - NAMED INSURED', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '732', 'AUTO PIP - NAMED INSURED & RELATIVE', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '733', 'AUTO PIP', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '736', 'AUTO PIP', 'PIP');
.
.
.
.

<<Code 2 - Generic select * statement to affirm that data is there>>

Select * from #ASLClass

{{Server: Msg 208, Level 16, State 1, Line 1
Invalid object name '#ASLClass'.}}

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-06-07 : 15:53:58

Are you running this code in Query Analyzer?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

ricks1683
Starting Member

14 Posts

Posted - 2007-06-07 : 16:00:31

Yes, I am.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-06-07 : 16:40:27

I dont see any reason why it would error out..Try opening a new query analyzer window and run the script again.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

ricks1683
Starting Member

14 Posts

Posted - 2007-06-07 : 16:53:16

That didn't work either. I just changed the temp table name to ##ASLClass and everything went fine. Whats the difference (in laymen's terms?)?

Thanks for the help.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-06-07 : 16:56:21

#tmp table is a "local" temporary table that gets destroyed when the session goes out of scope. ##table is a "global" temp table that can be accessed across sessions. Typically you dont want to use ## table as they have more overhead.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-06-07 : 16:59:45

ricks1683, please post the entire code that you are using so that we can test on our own machines.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

ricks1683
Starting Member

14 Posts

Posted - 2007-06-07 : 17:05:03

CREATE TABLE #ASLClass (
Asl char(3),
Preil Char(3),
Descr Char(50),
Aslob Char(6))

INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('160', '32', 'WORKERS COMPENSATION', 'WC');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '100', 'AUTO BODILY INJURY/PROPERTY DAMAGE, CSL', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '530', 'CSL PREMISES/OPERATIONS', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '531', 'CSL PRODUCTS/COMPLETED OPERATIONS', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '546', 'PERSONAL & ADVERTISING INJURY LIABILITY', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '547', 'DAMAGE TO PREMISES RENTED TO YOU', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '548', 'MEDICAL PAYMENTS', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '714', 'COVG M - MEDICAL PAYMENTS', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '750', 'FULL TIMERS LIABILITY BI', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '751', 'FULL TIMERS BI/PD COMBINED LIABILITY', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('170', '752', 'VACATION LIABILITY', 'GL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '729', 'PIP WORK LOSS', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '730', 'AUTO PIP', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '731', 'AUTO PIP - NAMED INSURED', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '732', 'AUTO PIP - NAMED INSURED & RELATIVE', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '733', 'AUTO PIP', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '736', 'AUTO PIP', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '744', 'PIP COMBINED FIRST PARTY BENEFITS', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '748', 'PIP MEDICAL EXPENSE', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('191', '799', 'Out of State PIP', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '100', 'AUTO BODILY INJURY/PROPERTY DAMAGE, CSL', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '101', 'AUTO BI, SPLIT LIMITS', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '101', 'BODILY INJURY', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '106', 'Commercial Auto Liability BIPD', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '110', 'AUTO PROPERTY DAMAGE', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '110', 'PROPERTY DAMAGE', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '114', 'AUTO MEDICAL PAYMENTS', 'MedPay');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '120', 'AUTO, UNINSURED MOTORIST, PROPERTY DAMAGE', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '701', 'COMBINED UM/UIM SINGLE-STACKED', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '702', 'COMBINED UM/UIM SINGLE-NON-STACKED', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '703', 'COMBINED UM/UIM SPLIT STACKED', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '704', 'COMBINED UM/UIM SPLIT - NON-STACKED', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '705', 'COMBINED UM/UIM PD', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '712', 'MINI-TORT', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '716', 'AUTO UNINSURED MOTORISTS, BI NON-STACKED', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '719', 'UIM BI NON-STAKED', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '720', 'FULL-TIMERS MEDICAL PAYMENTS', 'MedPay');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '750', 'FULL TIMERS LIABILITY BI', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '751', 'FULL TIMERS BI/PD COMBINED LIABILITY', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '752', 'VACATION LIABILITY', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '756', 'SCHEDULED MEDICAL BENEFITS', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '782', 'AWNING REPLACEMENT COVERAGE', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '783', 'PURCHASE PRICE GUARANTEE', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('192', '786', 'DIMINISHING DED ENHANCED BOTH', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('193', '130', 'AUTO, PERSONAL INJURY PROTECTION', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('193', '130', 'PERSONAL INJURY PROTECTION', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('193', '131', 'AUTO, ADDITIONAL PERSONAL INJURY PROTECTION', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('193', '132', 'WAGE LOSS', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('193', '818', 'MEDICAL EXPENSE', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '100', 'AUTO BODILY INJURY/PROPERTY DAMAGE, CSL', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '101', 'AUTO BI, SPLIT LIMITS', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '101', 'BODILY INJURY', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '102', 'COMBINED UM/UIM SPLIT', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '102', 'UNINSURED/UNDERINSURED MOTORIST SINGLE LIMITS', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '104', 'COMBINED UM/UIM SINGLE', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '104', 'UNINSURED/UNDERINSURED COMBINED LIMIT', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '105', 'EXCESS LIABILITY COMM. LINES', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '105', 'PERSONAL LIABILITY UMBRELLA', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '108', 'NON-TRUCKERS LIABILITY - $500,000 Limit', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '110', 'AUTO PROPERTY DAMAGE', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '110', 'PROPERTY DAMAGE', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '114', 'AUTO MEDICAL PAYMENTS', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '115', 'AUTO COMBINED BI/PD UNINSURED MOTORISTS-STACKED', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '116', 'AUTO UNINSURED MORTORIST, BODILY INJURY-STACKED', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '116', 'UNINSURED MOTORIST BODILY INJURY', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '117', 'BODILY INJURY', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '119', 'AUTO, UIM BI - STACKED', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '120', 'AUTO, UNINSURED MOTORIST, PROPERTY DAMAGE', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '121', 'AUTO, UNDERINSURED MOTORIST, PROPERTY DAMAGE', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '122', 'UNINSURED/UNDERINSURED MOTORIST BODILY INJURY SPL', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '125', 'PERSONAL PROPERTY INJURY', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '192', 'NON-TRUCKERS LIABILITY - $750,000 Limit', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '193', 'NON-TRUCKERS LIABILITY - $1,000,000 Limit', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '702', 'COMBINED UM/UIM SINGLE-NON-STACKED', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '704', 'COMBINED UM/UIM SPLIT - NON-STACKED', 'UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '799', 'Out of State PIP', 'PIP');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '806', 'DRIVE OTHER CAR BI/PD', 'DOC AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '810', 'DRIVE OTHER CAR UNINSURED MOTORIST BI', 'DOC UM/UIM');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '811', 'HIRED AUTOMOBILE BODILY INJURY', 'DOC AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '814', 'NON-OWNED AUTOMOBILE BODILY INJURY', 'NonOwn AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '820', 'TERRORISM LIABILITY', 'Terr');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '822', 'BLANKET ADDITIONAL INSURED ENDORSEMENT', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('194', '830', 'AUTO BODILY INJURY/PROPERTY DAMAGE', 'AL');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '124', 'MEXICO COVERAGE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '145', 'AUTO, COMPREHENSIVE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '145', 'COMPREHENSIVE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '146', 'AUTO, RENTAL REIMBURSEMENT', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '147', 'AUTO, TOWING & LABOR', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '170', 'AUTO, PHYSICAL DAMAGE COLLISION', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '170', 'COLLISION', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '171', 'AUTO, BROADENED COLLISION', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '172', 'AUTO, LIMITED COLLISION', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '753', 'VALUABLE PERSONAL PROPERTY', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '755', 'REPLACEMENT COST PERSONAL EFFECTS', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '757', 'DIMINISHING DEDUCTIBLE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '758', 'ADJACENT STRUCTURES', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '759', 'GOLF CART/MOPED/BOATS', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '760', 'TOTAL LOSS REPLACEMENT', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '761', 'EMERGENCY VACATION EXPENSE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '762', 'FULL TIMERS SECURED STORAGE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '764', 'EXTENDED UTILITY TRAILER', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '766', 'TOTAL LOSS REPLACEMENT', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '772', 'TOTAL LOSS REPLACEMENT NEW', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '773', 'COLLISION DEDUCTIBLE WAIVER', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '774', 'AUTO, COMPREHENSIVE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '775', 'AUTO, PHYSICAL DAMAGE COLLISION', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '776', 'AUTO, BROADENED COLLISION', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '778', 'TOTAL LOSS REPLACEMENT', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '780', 'Glass Coverage', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '781', 'CUSTOM EQUIPMENT REPLACEMENT', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '782', 'AWNING REPLACEMENT COVERAGE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '783', 'PURCHASE PRICE GUARANTEE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '784', 'DIMINISHING DED ENHANCED COLL', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '785', 'DIMINISHING DED ENHANCED COMP', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('211', '786', 'DIMINISHING DED ENHANCED BOTH', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '145', 'AUTO, COMPREHENSIVE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '145', 'COMPREHENSIVE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '146', 'AUTO, RENTAL REIMBURSEMENT', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '147', 'AUTO, TOWING & LABOR', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '155', 'FIRE,THEFT, COMBINED ADDL COV, V&MM', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '165', 'SPECIFIED PERILS, COMMERCIAL', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '170', 'AUTO, PHYSICAL DAMAGE COLLISION', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '170', 'COLLISION', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '171', 'AUTO, BROADENED COLLISION', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '755', 'REPLACEMENT COST PERSONAL EFFECTS', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '757', 'DIMINISHING DEDUCTIBLE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '760', 'TOTAL LOSS REPLACEMENT', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '761', 'EMERGENCY VACATION EXPENSE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '766', 'TOTAL LOSS REPLACEMENT', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '774', 'AUTO, COMPREHENSIVE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '775', 'AUTO, PHYSICAL DAMAGE COLLISION', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '780', 'Glass Coverage', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '782', 'AWNING REPLACEMENT COVERAGE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '783', 'PURCHASE PRICE GUARANTEE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '786', 'DIMINISHING DED ENHANCED BOTH', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '851', 'DRIVE OTHER CAR COMPREHENSIVE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '853', 'DRIVE OTHER CAR COLLISION', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '855', 'HIRED AUTOMOBILE COMPREHENSIVE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '856', 'HIRED AUTOMOBILE COLLISION', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '861', 'EXCESS PHYSICAL DAMAGE - SPECIFIED PERILS', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '862', 'TRAILER INTERCHANGE COMPREHENSIVE', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '863', 'TRAILER INCHG SP PERILS', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '864', 'TRAILER INCHG COLLISION', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '867', 'DOWNTIME', 'APD');
INSERT INTO #ASLClass ( Asl , Preil , Descr , Aslob ) VALUES ('212', '884', 'Facultative Physical Damage COLL', 'APD');

<<In new query window:>>

select * from #ASLClass

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-06-07 : 17:08:38

The script threw a couple of errors and I had to increase the column length's for last 2 columns and then it worked fine for me.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-06-07 : 17:10:23

The problem is with this: <<In new query window:>>

When you open a new query window, it is no longer in the same session. So you need to run everything in the same window.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-06-07 : 19:00:02

#ASLClass is a local temp table. It exists only in a session and visible only to local session.
##ASLClass is a global temp table. It is visible to all session.

When you open a new query window, you are creating a new session to SQL Server.

ricks1683
Starting Member

14 Posts

Posted - 2007-06-07 : 21:07:45

dinakar, tkizer & khtan,

thank you all for your help. This is extremely informative and everything has since worked. Thank you again for everything.

Rick R

PS: you all run a great forum and i always enjoy your help!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources