New to SQL Server 2nd Problem - Stored Procedures

[geoffcodd]

Hi,

Hope someone can help me with my 2nd issue.

I have a View saved as TMA.qryD1300_Complete_Accounts_with_Allocation, I would like to create a temp table of it results.

As a complete noob I need to know

1) How to create a Stored Proc to create this
2) How to call this from Access (VBA)
3) And once I have finished with the table how to delete it

All help greatly appreciated

Thanks
Geoff

 

[geoffcodd]

Hi finally got it to work so really happy with, that just need to understand the best way to run the stored proc from access Thanks

 

[SQL_Hell]

Can you post your code for this?