Viewing 15 posts - 16 through 30 (of 59 total)
the easiest option would be to use the debug feature available in SSMS or you can print/select the variable values before the nested SP is called. Also I believe it...
July 26, 2011 at 11:09 pm
As mentioned by GSquared, if u want to introduce newline in the place of the delimiter you can go for replace function else it would be advisable to look into...
July 26, 2011 at 9:53 pm
crazy4sql (7/26/2011)
July 26, 2011 at 4:53 am
I see that you need to capture the parameter that is passed to a stored proc which is nested... the question is where do you want to capture it or...
July 26, 2011 at 3:59 am
🙂 thanks... and as a side note... the Script component starts throwing timeout errors for long running queries and setting the timeout in the properties of the connection manager doesnt...
July 15, 2011 at 3:44 am
I would certainly try to avoid the RBAR. It is notoriously slow. As long as your dataset isn't that big that it chokes the tempdb with the temp table, I...
July 15, 2011 at 3:22 am
I followed a similar approach to resolve this... Just that instead of using a TVF I inserted the values directly into a temp table and referenced it [the temp...
July 15, 2011 at 3:15 am
Thanks Koen, Iam sorry missed out that info in my initial post... I tried with SET FMTONLY ON and no count is available in the procs by default..
I still dont...
July 15, 2011 at 1:12 am
Ideally Addition of 750000 records shouldn cause much problems.... Did you check the execution plan?
If you want any of us to analyze further into the issue i suggest you...
June 24, 2011 at 1:45 am
Did you re index the table after inserting the records? whats the difference in the execution plan?
June 24, 2011 at 12:04 am
u can try cube/roll up.. or here is something without that..
Assuming this would be the table structure..
create table #test (pid int,t_name varchar(10),amount float)
/*
Insert the test data....
*/
SELECT * FROM #TEST
UNION...
June 22, 2011 at 11:03 pm
ok... try converting it to datetime...
select convert(DATETIME,'31.12.11',4)
result ==> 2011-12-31 00:00:00.000
June 22, 2011 at 7:22 am
skynet_si (6/22/2011)
So how do I use it in this query ?USE MYDATABASE
INSERT INTO MY_TABLE (TYPE,START_DATE,END_DATE,RATE)
VALUES
('DBLMS','2011.03.01','2011.04.16','104');
????
What do you want to do in the query?? do you want to insert values...
June 22, 2011 at 6:17 am
Viewing 15 posts - 16 through 30 (of 59 total)