Post reply

The CREATE TABLE SQL construct or statement is not supported.

  • January 25, 2013 at 5:29 am

    #273239

    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

  • January 25, 2013 at 9:08 am

    #1581093

    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?

  • January 25, 2013 at 9:15 am

    #1581097

    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.

  • January 28, 2013 at 1:28 am

    #1581443

    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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply