I don't have enough info about your situation to be sure, but this sounds
familiar. Are you doing the "Select... Into" into a temporary table, of the
#tablename variety? You sure it's not being executed? SQR will run SQL
statements on multiple connections to the server, and a temporary table is only
visible on the connection it was created on. Also, temp tables created within
stored procedures are dropped when the stored procedure terminates. Try using
the -Cn parameters on the Begin-SQL line that creates the table, and on any
Begin-Select or Begin-SQL paragraphs that reference it.
And of course, verify that the Begin-SQL paragraph is being executed within your
program flow with a display or show statement just before the Begin-SQL
paragraph.
Good luck,
Tim
Pankaj Bedekar <BedekarP@ALCONEMARKETING.COM> on 07/01/99 02:22:37 PM
Please respond to SQR-USERS@list.iex.net
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc: (bcc: Tim Green/HWRD/ASG_Louisville/NAD)
Subject: SQL-SERVER how to run stored procedures or SELECT INTO statement
in SQL paragraph
I am using MS SQL-SERVER 6.5 AND SQR 3. I need to create a table on the fly
using a SELECT statement.
I tried using SELECT INTO in BEGIN-SQL ...END-SQL block but it never
executed the statement.
I created a stored procedure which does the same but now I cannot execute
the stored procedure using EXECUTE
or using 'BEGIN-SQL...END-SQL'
anyone have done this before ? plea let me know if anyone have more info. on
this .
Thank you,
Pankaj
Title: SQL-SERVER how to run stored procedures or SELECT INTO statement in SQL paragraph
I am using MS SQL-SERVER 6.5 AND SQR 3. I need to create a table on the fly using a SELECT statement.
I tried using SELECT INTO in BEGIN-SQL ...END-SQL block but it never executed the statement.
I created a stored procedure which does the same but now I cannot execute the stored procedure using EXECUTE
or using 'BEGIN-SQL...END-SQL'
anyone have done this before ? plea let me know if anyone have more info. on this .
Thank you,
Pankaj