Solved

Running Stored Procedures.

Posted on 2013-11-08
8
314 Views
Last Modified: 2013-11-13
I am trying to interpet a code for a store procedure and what it is asking me. I get the whole date and time thing, but it is really the start or ROOT to the end or ROOT


 
 --*
 --*  Parameters            Description
 --*  ---------------------------------------------------------------------------
 --*  @XMLDataSelection XML text block formatted as (CASE SENSITIVE)
 --*
 --*                      <Root>
 --*                        <RowId Code="^^&" Type="8" />
 --*                      </Root>
 --*
 --*                  Valid types for this procedure include (Constant group PANALXMLTYPE):
 --*                        Division = 8
 --*  DateFrom
 --*  DateTo
 --*
 --*  Modifications

Open in new window

0
Comment
Question by:Michael Franz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 2
8 Comments
 
LVL 5

Expert Comment

by:dannygonzalez09
ID: 39634951
looks like what have up there is all commented

"--" is used for commenting a single line in SQL
0
 

Author Comment

by:Michael Franz
ID: 39634952
But here is the section to compelte

 @XMLDataSelection text
    , @DateFrom datetime
    , @DateTo datetime
    , @LoggedInUser char(3)
    , @RowCount int = 0 output
0
 

Author Comment

by:Michael Franz
ID: 39634956
I think I got the following

    , @DateFrom datetime
    , @DateTo datetime
    , @LoggedInUser char(3)
    , @RowCount int = 0 output

but issues with getting the following correct...

 @XMLDataSelection text
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 5

Expert Comment

by:dannygonzalez09
ID: 39634985
ok.., makes a little sense

i guess this just an example of what you should pass to your @XMLDataSelection parameter

 --*                      <Root>
 --*                        <RowId Code="^^&" Type="8" />
 --*                      </Root>
0
 

Author Comment

by:Michael Franz
ID: 39634990
I think out Code is !!% and our type is 3, but I keep getting an error when running.


The error description is 'Invalid at the top level of the document.'.: Exception class=com.microsoft.sqlserver.jdbc.SQLServerException Exception message=The error description is 'Invalid at the top level of the document.'. Exception SQL State=S0002 Exception vendor error code=6602
0
 

Author Comment

by:Michael Franz
ID: 39634994
I fuess when I'm saying is I do not know how to set this up

@XMLDataSelection text

given to the comments about the parameter needs

If my code is = !!% and type=3
0
 

Accepted Solution

by:
Michael Franz earned 0 total points
ID: 39635055
Not more help I got it....That was the code


<Root><RowId Code="^^A" Type="8" /></Root>
0
 

Author Closing Comment

by:Michael Franz
ID: 39644093
Nice!
0

Featured Post

Monthly Recap

May was a big month for new releases from Linux Academy! Take a look at what our team built recently in our blog. You can access the newest releases from our blog.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question