[T-SQL] Call SP foreach Column in Table (without Cursor)

---

• Call SP foreach Column in Table (without Cursor)
• query to list all the table names used in stored procedure
• How to eliminate nulls from showing in columns to the columns start at the top

Call SP foreach Column in Table (without Cursor) Posted: 16 Aug 2013 04:28 PM PDT Hi,Is there a way to call a SP for each row in a table, and to specify the value as a parameter? Like this....RegardsNicole :-D--------------------------------------------------SELECT CompanyNameFROM customers-- This Result give to SPCreate PROCEDURE [dbo].[sp_Proceed] @companyname nvarchar(500)ASBEGIN DoAnyThing WITH this Parameter....END

query to list all the table names used in stored procedure Posted: 16 Aug 2013 04:18 PM PDT hi i want to make a query to list down all the tables used in stored procedure. plz suggestfor example my stores proc has three tables it should list as below:sp_name table_nameproc1--------table1proc1---------tablle2proc1---------table3

How to eliminate nulls from showing in columns to the columns start at the top Posted: 16 Aug 2013 02:22 AM PDT have a request to create report of values from lookup tables, these are not related so can't join the various tables. I started by creating a temp table with a field for each of the lookup table values then inserted one column at a time which gave me all the data i needed in one table, but when output data i get results likecol1 col2 col3a null nullb null nullc null null d null null e null nullf null nullg null nullnull 1 nullnull 2 nullnull 3 nullnull 4 nullnull null yesnull null nonull null maybethe customer would like to see the values for the columns all start in row 1if there a way to do this any help would be greatly appreciated - Scott

You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610