I have a sql advance query

SyntaxEditor Code Snippet

CREATE VIEW [NEWSSZone] AS
SELECT [SS_companyid] FROM {SelectionStorageZone}

follow by another sql advance query

SyntaxEditor Code Snippet

select [SS_companyid] from [NEWSSZone]

However, it threw an error "Invalid object name 'NEWSSZONE'."

I know for fact the views had been created because if I were to run the first query again it gives this error

"There is already an object named 'NEWSSZone' in the database."

So my question is how can I display the view?


Hi David,

You need to import your views through integration studio, and use it add as reference in service studio, and in advance query you need to use this views(Entity) in structure as output, and you can do the select.


Thanks,

Balasubramanian