Viewing 15 posts - 12,361 through 12,375 (of 26,486 total)
riya_dave (4/27/2012)
ok.is there any other way i can take second sp 's result into first one.
Yes, but since we can't see what you see not much chance of that happening...
April 27, 2012 at 2:21 pm
Sean Lange (4/27/2012)
April 27, 2012 at 2:06 pm
L' Eomot Inversé (4/27/2012)
GilaMonster (4/27/2012)
Lynn Pettis (4/27/2012)
Gail, without really digging into this, isn't this just an expensive NOP?Yup.
On the plus side, SQL's smart enough not to log the update.
Or maybe...
April 27, 2012 at 1:45 pm
riya_dave (4/27/2012)
i am doing it already.still not getting anything
Well then, nothing more we can do here as you refuse to provide that which we need to really help you. ...
April 27, 2012 at 1:37 pm
opc.three (4/27/2012)
...on second thought...comment removed...
Dang, had three minutes to see what you said and I missed it. 😛
April 27, 2012 at 1:31 pm
riya_dave (4/27/2012)
but without it i am getting data into seconds ,and with it its running more than 7 minutes ,still not getting data
You really don't want to hear my next...
April 27, 2012 at 1:30 pm
riya_dave (4/27/2012)
i am not getting any error msg,the query is executing indefinite time,if i put insert into @temp7
without it i am getting data
How do you know that the data isn't...
April 27, 2012 at 1:14 pm
ColdCoffee (4/27/2012)
Lynn Pettis (4/27/2012)
Just remember, he isn't showing us actual code.He? the names sounds like a SHE :-D. Whats your take ?
{Lets, for fun, hijack this thread :-P}
I use the...
April 27, 2012 at 1:10 pm
riya_dave (4/27/2012)
i mean @temp7 ,its not getting into @temp7
Then, as Gail asked, define "not working." Are you getting an error message? If so, how about showing us the...
April 27, 2012 at 1:07 pm
riya_dave (4/27/2012)
i am calling another sp.
but its not getting into @temp table.
insert into @temp7
EXEC pPortfolioDashboard
@Portfolios = @AdjustPortfolio,
@FromDate = @FromDate,
@ToDate = @ToDate,
whats wrong,how...
April 27, 2012 at 1:04 pm
GilaMonster (4/27/2012)
Evil Kraig F (4/27/2012)
If you use 10,000 monkeys,...
April 27, 2012 at 1:01 pm
opc.three (4/27/2012)
Lynn Pettis (4/27/2012)
ColdCoffee (4/27/2012)
Riya_dave, it depends on...
April 27, 2012 at 12:57 pm
Evil Kraig F (4/27/2012)
1) Who's heading to SQL Saturday in Phoenix? I know Steve's going and I'm looking forward to meeting him, any other threadizens? Oh,...
April 27, 2012 at 12:54 pm
ColdCoffee (4/27/2012)
Riya_dave, it depends on this setting of...
April 27, 2012 at 12:50 pm
You need to use IS NULL or IS NOT NULL when checking for a null value. You need to remember the null = null is NOT true. Also null...
April 27, 2012 at 12:46 pm
Viewing 15 posts - 12,361 through 12,375 (of 26,486 total)