0

I'm trying to pivot some data in SQL Server 2000, but the user that runs the application only have read/write permissions. I've looked the solutions posted here, but all involving create/destroy temporary tables.

Community
  • 1
  • 1
Apocatastasis
  • 480
  • 1
  • 8
  • 21

1 Answers1

1

I think you may be a bit confused as to what temporary tables are.

You should be able to create a temp table (in memory) within your SQL statement. No extra permissions are necessary.

Neil N
  • 24,402
  • 16
  • 83
  • 143