Posted by Yas on 08/18/07 14:52

Hi, is there a way I can check if a table is empty and contains no
rows?

I have a Table1 which being dynamic can sometimes end up with now
columns what so ever. I'm using Table1 in one of my views along with 2
other tables and I would like put a condition at the...something like
AND Table1 IS NOTEMPTY

Is there a way to do this in MS SQL?

Many thanks

Yas

[Back to original message]