Rank - the common members of a corporation (such as the enlisted troopers of a military); "the strike was supported by the union rank and file"; "he rose from your ranks to be a colonel" In SQL Server, at times the SQL Queries need to be dynamic and not static, https://afrobirdsfarm.com