Hi Alex, I've not attempted this with SQL Views, but you could try: SELECT * INTO YourNewTableName FROM YourExistingViewName as this will create a table from your view. If you want, you can get SQL Server Agent to run a job to recreate this table every hour or something with a TSQL statement like:   use ...

I am trying to use a SQL Server view (not a table) to provide a denormalized (joined) dataset to an InfoPath form via a smartObject, but the SQL Service doesn't seem to see views, only tables.  Any ideas about how to get around this?    Thanks, -alex