it just hang out and never come back.

and i am seeing ssms(not responding).

it is working for another sp.

i am using table variable ,i know for temp its not gonna...

thanks ,

it was really helpful.

i am thinking which join is better ,i am using inner and left join.

this is the only things i can work on

thanks ,its worked for me

never mind,i solve it.

i make my x axis as secondary axis ,which always show label on top.

then i remove the label inside by making enable to false and then tick...

Ichange the y-axis "Cross at:" setting to maximum. However, now the x-axis labels are inside the chart area, and I don't see a property to move the labels...

x - axis

what about the first two,

i cant use 2 times select in my sp.

need to hv just 1,what about group by and then order by

ok,this is my table result

S&P ...

ok.its working,but now ,i just want to organize it.

like i am inserting into @temp so many times with different data,

so whatever data i insert first should come first.

i am using...

hmm,the second sp also calling 3 sp inside.

ok. is there any way,u run same sp twice with different parameter ,in 1 sp.

ok.is there any other way i can take second sp 's result into first one.

i am putting it in if condition,does that is the problem?

it snot inserting into temp7 table,

y ?

insert into @temp7

--

EXEC pPortfolioDashboard

@Portfolios = @AdjustPortfolio,

@FromDate = @FromDate,

@ToDate = @ToDate,

)

i dont find any reason.

i am doing it already.still not getting anything

but without it i am getting data into seconds ,and with it its running more than 7 minutes ,still not getting data