Solved

Running Stored Procedures.

Posted on 2013-11-08
8
301 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:Newbi22
  • 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:Newbi22
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:Newbi22
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
 
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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

Author Comment

by:Newbi22
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:Newbi22
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:
Newbi22 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:Newbi22
ID: 39644093
Nice!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql query help 4 44
Sql Server 2008 R2 Stored Procedure doesn't work with CTE and parameters 4 31
Implementing SQL Server Data Files in Azure 1 35
Sql query 107 24
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.

912 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now