Often you may require number table for various purposes (parsing csv, string manipulation,etc) If you use SQL Server 2005, then it is very easy than any other method you use in lower versions Here are two methods of generating number table with 10000...