?
Solved

Running Stored Procedures.

Posted on 2013-11-08
8
Medium Priority
?
315 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
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

Not sure which OpenStack Certification to get?

So you’ve realized you might want to get certified in OpenStack, but you’re not sure what the benefits might be or even which one you should take. You know there are several certification courses you can choose from, but how do you know which one is right for you?

Question has a verified solution.

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

If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

765 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