[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Running Stored Procedures.

Posted on 2013-11-08
8
Medium Priority
?
317 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
  • 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
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

834 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