COUNT(*) in DYNAMIC SQL

Hi all,

I am sorry if this question has been already answered earlier. I am trying to do a 'SELECT COUNT(*) ' from a table, whose name is generated dynamically'. How do I do this ?

Thanks

Jagdeep
jagdeeps_at_hotmail.com

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet