troubleshooting Question

ms sql temporary tables. Create and access via asp

Avatar of robrodp
robrodpFlag for Mexico asked on
Microsoft SQL ServerASPSQL
6 Comments3 Solutions220 ViewsLast Modified:
I create a temporary table (asp query):
select top 0 * into #payuvars from payuvars
No Problems

I cans ee it in the the temopb database
the I try to insert (asp query)
insert into #payuvars(payuvar,payuval) values('val1','val2')

I get:

Invalid object name '#payuvars'.

What am I doing wrong?
Big Monty
Web Ninja at large

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros