413
Views
1
Comments
Advance Query SQL Views
Question

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?


2017-03-03 12-48-17
Balasubramanian Prakasam

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

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.