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...
-
We can filter an axis based on the members, or based on the measure value. Based on the members: begins with F or after Based on th...
-
Incremental Uploads: We have got a request to need a SSIS package to incremental uploads between two sql server instances which are two d...
-
Follow the below link https://blogs.msdn.microsoft.com/arvindsh/2013/04/23/cannot-resolve-the-collation-conflict-error-message-with-tem...
No comments:
Post a Comment