Declare @tableRowCount Table
(
TableName Varchar(300),
RowCnt INT
)
Insert into @tableRowCount
EXEC sp_msforeachtable 'select parsename(''?'',1), count(*) from ?'
select * from @tableRowCount
where RowCnt! = 0 ---(rowcnt=0 is not having any records)
order by RowCnt
Subscribe to:
Post Comments (Atom)
Search This Blog
DAX - Grouping on multiple columns and the count
Please go thorugh the below URL for entire soultion. http://community.powerbi.com/t5/Desktop/DAX-Grouping-on-multiple-columns-and-the-cou...
-
Synchronous vs Asynchronous The SSIS dataflow contain three types of transformations. They can be non-blocking, semi-blocking or full...
-
---Fibonacci numbers declare @fib table(fib_id bigint,fib_val bigint) declare @current_val bigint,@previous_val bigint,@new_val bigint in...
-
--Scenario1: SELECT t.NAME AS TableName, --i.name as indexName, p.[Rows], sum(a.total_pages) as TotalPages, sum(a...
No comments:
Post a Comment