[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] T-SQL DDL statements within SQR Begin-SQL...End-SQLconstruct
- Subject: [sqr-users] T-SQL DDL statements within SQR Begin-SQL...End-SQLconstruct
- From: "ruscs ___" <ruscols@hotmail.com>
- Date: Sat, 17 Apr 2004 19:12:12 +0000
- Bcc:
- Delivery-date: Sat, 17 Apr 2004 14:13:20 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Is it possible to create a local or global temporary table (within MSSQL
server database) in Begin-SQL...End-SQL construct?
The following creates a perm. table:
Begin-SQL On-Error=Warn
!.....
create table test_tbl (emplid char(11), name char(11) )
!.....
End-SQL
Replacing test_tbl with #test_tbl or ##test_tbl will produce an error...
Thank you
_________________________________________________________________
MSN Toolbar provides one-click access to Hotmail from any Web page – FREE
download! http://toolbar.msn.com/go/onm00200413ave/direct/01/
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users