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...

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...

This should help

http://www.sqlservercentral.com/articles/APPLY/69953/

***Edited***

Above mentioned method works better..

crazy4sql (7/26/2011)

---

you can run profiler using filters for the database specific and user specific(to make less entries in profiler) and then run the stored procedure using the user you mentioned...

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...

🙂 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...

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...

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...

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...

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...

Did you re index the table after inserting the records? whats the difference in the execution plan?

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...

ok... try converting it to datetime...

select convert(DATETIME,'31.12.11',4)

result ==> 2011-12-31 00:00:00.000

What do you want to do in the query?? do you want to insert values...