Populate Dataset With Table Names From Stored Procedure

by

Your SP is not actually returning multiple tables, its returning a selection of columns and rows from your tables, therefore there is no ‘table name’, and hence why they are named table1, table2 etc. If its important, you could return an extra column for each selection, and in that column fill it with the desired name and then use it from there.

i.e. 

   select *,'MyTableName1' As [TableName] name from mytablename1
   select *,'MyTableName2' As [TableName] name from mytablename2

More Related Contents:

  1. Retrieve column definition for stored procedure result set
  2. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  3. How do I find a stored procedure containing ?
  4. Export from SQL Server to Excel
  5. How to get cumulative sum
  6. How to check if a column exists in a SQL Server table
  7. SQL Server query to find all permissions/access for all users in a database
  8. Select columns from result set of stored procedure
  9. Infinite loop CTE with OPTION (maxrecursion 0)
  10. How Can I Log and Find the Most Expensive Queries?
  11. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  12. How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
  13. INSERT INTO vs SELECT INTO
  14. How to list all dates between two dates [duplicate]
  15. Calling an API from SQL Server stored procedure
  16. How to: Create trigger for auto update modified date with SQL Server 2008
  17. Split values over multiple rows [duplicate]
  18. How to update primary key
  19. error when inserting into table having instead of trigger from entity data framework
  20. Case sensitive variables in SQL Server
  21. What happens to the primary key Id when it goes over the limit?
  22. SQL Recursive CTE: Finding objects linked by property
  23. Programmatically retrieve SQL Server stored procedure source that is identical to the source returned by the SQL Server Management Studio gui?
  24. Convert decimal time to hours and minutes
  25. Stored procedure that exports data into csv files only exports to one file
  26. Execute stored procedure with an Output parameter?
  27. SQL Server: should I use information_schema tables over sys tables?
  28. How Can I Detect and Bound Changes Between Row Values in a SQL Table?
  29. How to find the boundaries of groups of contiguous sequential numbers?
  30. How to choose the clustered index in SQL Server?

Leave a Comment