General discussion

Locked

Microsoft Query

By Peter.mcauley ·
I have created a sql query with table variables when I run the SQL in microsoft query it brings back the data, however when I try to return the data to excel it drops all the information & when I try to edit the query the SQL statement is blank.

1. Is my syntax incorrect for MS Query or
2. Does ms query not support table variables

Attatched below is the start and end of table variable statement

create table #SessionsByRegion
( Region varchar(20),
PractitionerType varchar(20),
Session int,
Exams int
)

Insert into #SessionsByRegion


drop table #SessionsByRegion

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums