If your SQL server is hosted on a VM, u are likely to get a wrong Server Name using @@ServerName.. Use OBJECTPROPERTY() function instead..

All you need is to do unpivot.. here is how u do that.. this produces 2 column, with the column name as the second column.. remove "star" from the query...

Put the result of your SP into a temp table like this:

INSERT INTO TABLE EXEC SP1

Then use column values into variables and the execute SP2..

sorry dint read your entire post.. this is possible.. take a look the following great article from MVP Jeff Moden :

Cross Tabs and Pivots, Part 1 – Converting...

Only 4 columns are possible? i mean, for a given ID, will there be only 4 columns ?

Execute the Stored procedure for each ID present in the output of the other SP?

Wow, thats excellent...

Books Online - THe free help that comes along with SQL Server 2005 installation is better than Google search..

CTE = Common Table Expression

These...

Keyun, that's a lot of work, buddy! first get the today's date, then the first day of the month, then loop through each day to pull data from the DB...

Hi there, have this :

declare @table table

(

c1 int, c2 int , c3 int, c4 int, c5 int

)

insert into @table

...

Hi there, cursors are really pain-givers.. without your original "..Some Processing" code, we cant give an alternative..

but within the cursors u can use like this

create table #table ( your...

I will be...

Try this:

SELECT p1.DESIGNATIONS,

STUFF( ( SELECT ',' + NAME

FROM TableNAME p2

...

Hi there, try this:

declare @datatable table

(

CompanyID int,

ReportID int,

ReportDate smalldatetime

)

insert into @datatable (CompanyID ,ReportID, ReportDate)

select 10 ,123 ,'2007-09-19'

union all select 10 ,234 ,'2005-07-28'

union all select 10 ,345 ,'2004-10-08'

union...

No issues, welcome saravanan!