More SQL - how to create a view when you don't have admin rights


#1

I’ve found that in 0.28 I’m limited when I use SQL Queries as it prevents me using multiple values in a filter. My solution so far has been to just use a view.
Then I realised that the customer I’m working for is one of the few who would allow me to create views on their database, so had to come up with a new solution for future use.

Answer is to use SQL Server Express with linked servers. I can then create views of the ‘proper’ database within a new database in Expess. On top of that, I then create new views based upon those.

More details here: Multiple databases in one question without a data warehouse- YES YOU CAN!


'IN' operator taking a list of arguments
WIKI: query issues (SQL/others)