This is not a lost idea in the "Power BI Ideas" forum. We are trying, vote here!

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9677517-source-control

Up Vote this idea!

Everything about stackexchange/stackoverflow!

To Lee's point, use the following CTE that filters on the current database_id so that you aren't counting hits from object_ids from other databases:

select ISNULL(deps.database_id,-1) database_id,p.object_id,p.name

,ISNULL(deps.type,'P') type,ISNULL(deps.type_desc,'SQL_STORED_PROCEDURE') type_desc

,ISNULL(deps.last_execution_time,'1900-01-01') last_execution_time,ISNULL(deps.execution_count,-1) execution_count

,p.create_date,p.modify_date...

Thanks. a Quick google pointed me here:

https://azure.microsoft.com/en-us/documentation/articles/app-service-web-app-azure-portal/

"The new portal makes it easy to build applications end-to-end with components from multiple services. The new Azure Portal is organized as...

In your article you use the term "Blade" to describe what looks to be features, plugins or modules of the portal. Why use the term "Blade", can you define it...

That was it ! ";"

I was getting an error:

Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking...

I've used INSERT INTO...SELECT many times but as "SSCoach" answered above on Nov 22 the query solution to my problem is complex. This is the SQL Query I need to...

BaseTable is not what needs to be inserted... The query joins BaseTable to JoinTable, it's the result of this query that needs to be inserted.

One more question, new dataset - similar problem... it is possible to extend this solution and now INSERT this query into another table?

Take the query (simplifed):

With BaseTable AS (Select A,...

Sweet! Thanks works great!:-D