Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Running Stored Procedures.

Posted on 2013-11-08
8
Medium Priority
?
316 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

618 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