CREATE PROCEDURE MyProc AS BEGIN Select 'FirstTableName' AS TableName, Column1, Column2 FROM FirstTable Select 'SecondTableName' AS TableName, Column1, Column2 FROM SecondTable Select 'ThirdTableName' AS TableName, * FROM ThirdTable END In the returning DataSet first column for all DataTables will have the TableName you have specified in the SP. You can identify the specific table using these names and assign an appropriate name to your DataTables.