Viewing 15 posts - 1 through 15 (of 137 total)
Can you include the full code with the sp_xml_preparedocument statement and also indicate how you are running the script?
I took your code and included sp_xml_preparedocument in the last line and...
June 12, 2009 at 7:24 am
Question, just out of curiosity, why the dynamic sql execution required in this scenario as direct sql seems to do the job?
or am I missing some thing - see below...
June 12, 2009 at 7:10 am
In my view, redundant code
a) any unnecessary code is a performance overhead. But to what extent it affects depends on the scenario. Think of this code being called from a...
November 20, 2007 at 6:52 am
One option is to use full outer join to get details from both the tables including missed records from either of them
See whether following sample helps
Declare @tableA Table
November 20, 2007 at 6:28 am
1. Did you put the trace and find out the time taken by the queries in
side the stored procedure. I looked at the SP, see...
November 16, 2007 at 1:40 am
there is an extra opening bracket not closed....
November 15, 2007 at 11:11 am
This could be due to the date conversion happening from string to date in the where clause
AND MWAPPTS.ADATE BETWEEN CAST(Convert(varchar(100),
@StartDate, 101) as DateTime) AND CAST(Convert(varchar(100),
@EndDate, 101) as DateTime)
November 15, 2007 at 8:29 am
Some of my thoughts below - Hope it helps
1. Using profiler findout the time taken for each of the step
November 15, 2007 at 3:19 am
One option is to use the Custom Scripting option.
Not sure whether this is the best way.
Following is a sample script to put in the Code section of report
public function GetAvg(byval...
November 15, 2007 at 2:08 am
This could be due to data conversion related issues.
See following link in case you haven't done already
November 14, 2007 at 8:44 am
There is still a print statement in the code
PRINT N' sp_OAGetErrorInfo failed.';
You need to put this one also into @output variable, otherwise, if there is a error calling oageterrorinfo,...
November 12, 2007 at 11:57 pm
It is still not clear to me.
Assuming the requirement "web application need to display the dependency information of the stored procedure being executed".
This has two parts
a) executing stored...
November 12, 2007 at 10:55 am
Sorry to interrupt in middle,
I was bit concerned what you are trying to do here. Could you please post more details on your requirement?.
If you decide to use sp_depends (in...
November 12, 2007 at 9:32 am
Did you try sp_depends?
November 12, 2007 at 8:27 am
The default sp_oaDisplayErrorInfo seem to display the error using print statements. As such it does not seem to return the error back as a parameter.
You may have to customize...
November 12, 2007 at 1:33 am