The CREATE TABLE SQL construct or statement is not supported.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » The CREATE TABLE SQL construct or statement...

The CREATE TABLE SQL construct or statement is not supported.

Rate Topic

Display Mode

Topic Options

Author

Message

viveksvkola

Posted Friday, January 25, 2013 5:29 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 10:37 AM
Points: 145, Visits: 75

Hi All,

CREATE TABLE #Scope
(
JobID BIGINT
,ListID INT
,BatchID INT
,SendStartTime DATETIME
,SendCompleteTime DATETIME
,PRIMARY KEY CLUSTERED (JobID, ListID, BatchID, SendStartTime, SendCompleteTime)
).

I am executing this code in dataset type as text in ssrs 2008 it raise an error " The CREATE TABLE SQL construct or statement is not supported."

Hear requirement is i don't have permission to create Stored Procedure in my client mission but i want create report based on SP code by create dataset type as text.In SP you have scope tables.

Any one can give complete information to resolve the Problem.

Thanks,
Vivek

Post #1411633

David McKinney

Posted Friday, January 25, 2013 9:08 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:43 AM
Points: 582, Visits: 1,601

I think this is because your trying to execute the create table sql from Reporting Services (and not in Management Studio.) Hence the connection type is not the same, and won't support the same constructs. I don't have SSRS available but I'm guessing you can just do either a Select or a call to an Stored Proc. Perhaps you could try a CTE instead of a temp table?

Post #1411786

Gazareth

Posted Friday, January 25, 2013 9:15 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:53 AM
Points: 1,474, Visits: 2,342

Temp tables are fine in SSRS text type reports - that error just comes up in the visual query designer mode.
The SQL should execute with no problems.

Post #1411791

viveksvkola

Posted Monday, January 28, 2013 1:28 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 10:37 AM
Points: 145, Visits: 75

Thanks, i don't have permission to create and open ssms. my ssrs 2008 and my ssms 2008 r2.except select statement can we use create/insert/update/drop/delete in ssrs dataset.

Post #1412225

« Prev Topic | Next Topic »

Permissions