OPEN XML

May 19, 2006

I have to insert one table by using the concept OPENXML



But i want to insert a table lot of fields i require, in the open XML few fields fields are there , so i want to selet some fields from other table





can u guide me for this scenario to INSERT some fields from one table and some in OPENXML as a single insert statement



Awaiting for Reply PLease





Thanx



View 1 Replies


ADVERTISEMENT

Cannot Open User Default Database. Login Failed. (only When IDE Is Open)

Sep 7, 2007

I get the below error only when my IDE open. It connects well when it is found closed.
[SqlException (0x80131904): Cannot open user default database. Login failed.Login failed for user 'JPASPNET'.]
I could solve this by giving the logged in windows user to impersonate under IIS window > WEBSITE > ASP.NET tab > EDIT CONFIG > APPLICATION tab
But I wish someone could give me the proper solution.
I almost tried all from giving ASPNET user as a administrator to configuring the same in Express management tool.
Environment: XP pro, VWD and SQL Express

View 3 Replies View Related

Leave The Connection Open Or Always Open And Close Immediately?

Jun 7, 2006

Hi there,
 
I got an approach like that:
1) Read something from DB - check the value, if true stop if false go on2) Read the second Value (another SQL Statement) - check the value etc.
Now I could open the connection at 1) and if I have to go to 2) I leave the connection open and use the same connection at 2). Is it ok to do that?
The other scenario would be opening a connection at 1), immediately close it after I read the value and open a new connection at 2).
Thanks for the input!

View 4 Replies View Related

Unable To Open New Query Window Or Open Any Table

Nov 3, 2014

Post installation of SQL Server 2014 Express edition, I am able to connect to the Database Instance.

But while opening a new query window in SSMS or opening a table getting the error:

Package 'RadLangSvc.Package, RadLangSvc, Version 12.0.0.0, Culture=Neutral, Public Token=89845dcd8080cc91' failed to load

Object reference not set to an instance of an object. (mscorlib)..Have already tried installing the componentsDACProjectSystemSetup_enu.msi, TSql LanguageService_enu.msi, DACFramework_enu.msi from path VS 2010 WCU DAC.

View 5 Replies View Related

Open Report In New Window: Window.open Method Gives Error

Jun 26, 2006



Hi,

I am using SSRS Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00. I want to open linked report in new window.

I tried whats mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=240172&SiteID=1 but i get an error on Window.Open method.

How do I solve the problem?

Thanks

View 1 Replies View Related

Keep A Few Connections Open All The Time Or Open/close Connections On The Fly?

Jul 20, 2005

Just a quick question about connection management. My application willnever need more than 1 or 2 connections about at any given time. Also, I donot expect many users to be connected at any given time. For efficiency, Iwould like to keep connections alive throughout the lifetime of the objectsrequiring them, rather than opening a new connection, executing code andthen closing it again. What is the most efficient way of doing this?Should I perform the open/close or just one open when I create the objectand a close when I dispose of it?

View 1 Replies View Related

I Cant Open Sql??

Jun 9, 2008

 hi alli cant open sql server.i try  window authentication and sql server authentication butit doesnt open. how can i do ? Thanks 

View 4 Replies View Related

How To Open XML Example

Jun 19, 2007

Hello Im trying to open an example RDL file I downloaded..the file type is XML ..when i open it up it contains all XML



How can i view this in GUI format from Visual Studio? It is an example off how to use default 'select all' in multivalued parameters so i assume I can see it working as a project ? Not sure how to use this XML file?



anybody please help



thanks







View 2 Replies View Related

Cannot Open Db

Dec 31, 2007



hi , can any one pls help

what are all the minimum required permissions to do ddl , dml statements on database.
we have so many logins .which and every having sysadmin, i removed sysadmin permission and assign db_owner permission to 7 users and only 3 users having error

cannot open database ' db_nam' requested by login. the login failed. Login failed for user 'ohmvarun1'


pls help me on this isssue some urgent

regards

View 6 Replies View Related

Open A Web Page Through SQL SQL Job

Sep 11, 2006

Hi all, now, i create a job to open a page on timely basis. The job's Vb script is like that:Dim WshShellSet WshShell =CreateObject("WScript.Shell")WshShell.Run ("http://www.google.com")Set WsShell = Nothing when i run that job, i got that error:The job succeeded.  The Job was invoked by User hostusername.  The last step to run was step 1 (Step 1). how can i solve it? i still don't know whether that script will open a webpage or not 

View 6 Replies View Related

How Should I Open A .DBF File...

Oct 24, 2007

Hi,
  I have couple of .DBF files that i need to open which software should i use to open them.... can i open it with Sqlserver
 
Regards
Karen

View 9 Replies View Related

Open Connection

Nov 1, 2007

Hello everybody I would like to know more about the number of possible connection to a sql server is it by pool ? or there is max for all the database ? all the server ? how I can get the number of connection open ? Thx in advance 

View 2 Replies View Related

Open .MDF Database

Apr 13, 2008

When I try to open a .MDF file with SQL Server Management Studio Express last version I get an error :
There is no editor available for "DATABASE.MDF"
Make sure the application for the file type (.MDF) is installed.
How can I open the MDF file.I tried to use also the database NORTHWIND.MDF provided with
MSSQL 2000  sample but the same error.
What can I do ?
I am using Microsoft SQL Server 2005 Express.
I want to open the .MDF file to create a index for Full Text Search.
Thank You !

View 5 Replies View Related

Open Datareader

May 2, 2008

"There is already an open datareader associated with this command which must be closed first." 
I have received this same error before, but I'm not sure why I'm getting it here.'Create a Connection object.
MyConnection = New SqlConnection("...............................")

'Check whether a TMPTABLE_QUERY stored procedure already exists.
MyCommand = New SqlCommand("...", MyConnection)

With MyCommand
'Set the command type that you will run.
.CommandType = CommandType.Text

'Open the connection.
.Connection.Open()

'Run the SQL statement, and then get the returned rows to the DataReader.
MyDataReader = .ExecuteReader()

'Try to create the stored procedure only if it does not exist.
If Not MyDataReader.Read() Then
.CommandText = "create procedure tmptable_query as select * from #temp_table"

MyDataReader.Close()
.ExecuteNonQuery()
Else
MyDataReader.Close()
End If

.Dispose() 'Dispose of the Command object.
MyConnection.Close() 'Close the connection.
End With
As you can see, the connection is opened and closed, and the datareader is closed.   Here's what comes next...'Create another Connection object.
ESOConnection = New SqlConnection("...")

If tx_lastname.Text <> "" Then
If (InStr(sqlwhere, "where")) Then
sqlwhere = sqlwhere & " AND lname like '" & Replace(tx_lastname.Text, "'", "''") & "%'"
Else
sqlwhere = " where lname like '" & Replace(tx_lastname.Text, "'", "''") & "%'"
End If
End If
If tx_firstname.Text <> "" Then
If (InStr(sqlwhere, "where")) Then
sqlwhere = sqlwhere & " AND fname like '" & Replace(tx_firstname.Text, "'", "''") & "%'"
Else
sqlwhere = " where fname like '" & Replace(tx_firstname.Text, "'", "''") & "%'"
End If
End If

dynamic_con = sqlwhere & " order by arr_date desc "

'create the temporary table on esosql.
CreateCommand = New SqlCommand("CREATE TABLE #TEMP_TABLE (".............", ESOConnection)

With CreateCommand
'Set the command type that you will run.
.CommandType = CommandType.Text

'Open the connection to betaserv.
ESOConnection.Open()

'Run the SQL statement.
.ExecuteNonQuery()

End With

'query our side
ESOCommand = New SqlCommand("SELECT * FROM [arrest_index]" & dynamic_con, ESOConnection)

'execute query
ESODataReader = ESOCommand.ExecuteReader()

'loop through recordset and populate temp table
While ESODataReader.Read()

MyInsert = New SqlCommand("INSERT INTO #TEMP_TABLE VALUES("......", ESOConnection)

'Set the command type that you will run.
MyInsert.CommandType = CommandType.Text

'Run the SQL statement.
MyInsert.ExecuteNonQuery()

End While

ESODataReader.Close()  'Create a DataAdapter, and then provide the name of the stored procedure.
MyDataAdapter = New SqlDataAdapter("TMPTABLE_QUERY", ESOConnection)

'Set the command type as StoredProcedure.
MyDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure

'Create a new DataSet to hold the records and fill it with the rows returned from stored procedure.
DS = New DataSet()
MyDataAdapter.Fill(DS, "arrindex")

'Assign the recordset to the gridview and bind it.
If DS.Tables(0).Rows.Count > 0 Then
GridView1.DataSource = DS
GridView1.DataBind()
End If

'Dispose of the DataAdapter
MyDataAdapter.Dispose()

'Close server connection
ESOConnection.Close() Again, a separate connection is open and closed.I've read you can only have 1 datareader available per connection. Isn't that what I have here? The error is returned on this line: MyInsert.ExecuteNonQuery()
Help is appreciated.
 

View 3 Replies View Related

How Do I Open And Run The .sql Files In VWD 05?

May 13, 2008

Hi Forum, I dont have a lot of experience with SQL and have a problem running .sql file.
I use VWD 2005 ex and SQL server 22005 ex
Im following some instructions to create the .mdf database I need for API.
Step one; was to create a blank .mdf, which ive done! 
Step two; 
Create the Tables and Stored Procs. Tables and stored procs are defined in two script files CreateTables.sql and
CreateStoredProcs.sql within Database folder. Run CreateTables.sql first
 
How do I open and run the .sql files in VWD 05? many thnaks Paul

View 3 Replies View Related

Can't Open Northwind

Dec 8, 2005

Can't open Northwind - asp.net - dataaccess-sqldatasource
 
I remembered doing walkthrough using Northwind.  However it wasn't an http project but a file project using the development server.  Northwind allowed me to add, edit and insert, and the web page looked fine.
I opened a simple project just to see whether I could get my sqlserver on the internet. (vs studio 2005, sqlserver 2005)
I created the project in http location http://localhost/Northwind .  I dragged a sqldatasource to the page, configuring it to display ID and ProductName.  I clicked advanced, but noticed the generate insert, edit and delete were grayed out. That told me something was wrong with my authetification.
I configured my sqlserver 2005 to have integrated security.
I built the solution and website, then pressed cntl-F5.  I got a login error. Nowhere did the page ask me for username and password.  First questions - how do I get this to open up a web page, and how to I get it to allow me to generate insert, edit and delete statements?
dennist685
Server Error in '/Northwind' Application.--------------------------------------------------------------------------------
Cannot open database "Northwind" requested by the login. The login failed.Login failed for user 'YOUR-02910F1DF1ASPNET'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database "Northwind" requested by the login. The login failed.Login failed for user 'YOUR-02910F1DF1ASPNET'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 
Stack Trace:
[SqlException (0x80131904): Cannot open database "Northwind" requested by the login. The login failed.Login failed for user 'YOUR-02910F1DF1ASPNET'.]   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735123   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838   System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105   System.Data.SqlClient.SqlConnection.Open() +111   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70   System.Web.UI.WebControls.DetailsView.DataBind() +4   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82   System.Web.UI.WebControls.DetailsView.EnsureDataBound() +181   System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69   System.Web.UI.Control.EnsureChildControls() +87   System.Web.UI.Control.PreRenderRecursiveInternal() +41   System.Web.UI.Control.PreRenderRecursiveInternal() +161   System.Web.UI.Control.PreRenderRecursiveInternal() +161   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
 

View 1 Replies View Related

Cannot Use Open Table In SEM 7.0

Jun 5, 2002

I set up SQL Server 7 desktop, sp3 on my laptop, but get
the following error each time I try to use the Open Table
item on the popup menu in Enterprise Manager:

The query cannot be executed because some files are either
missing or not registered. Run setup again to make sure
all required files are registered.

Re-running setup does nothing, and an uninstall and re-
install didn't fix the problem either.

I can't count the number of times I've set up SQL7 in the
past, and I never had this error before.

The PC is running Win2K Pro and has Office XP, and
ColdFusion 4.5a installed.

View 1 Replies View Related

Open Conections

Jul 3, 2001

Hi fellow listers:

We installed an aplication written by us in VB5 and Sql 7.0
in one of our customers site.

The customer is telling us that we left "open conections"
when our program finishes.

I want to check in our server, testing our programs, which, where and
how many conections we open and which are those we left opened.

We look with the Server Enterprice Manager in the Managment under currect activity, but we don't know how to interpret the data there, and
we don't know how to see wich are the conections we left opened.

Any help will be appretiated.

TIA
Gerardo Alvarez
www.asaven.com

View 3 Replies View Related

I Can Not Open The Table From EM

Jul 9, 2001

This morning, I got below error message when I open the table from Enterprise Manager. Anybody can tell me how can I solve this problem?

************************************************** **********
An unexpected error happened during this operation.

[Query]-Query Designer encountered a Query error. Unspecified error.

************************************************** ***********

Thanks.

View 3 Replies View Related

Can&#39;t Open SQL Server

Nov 2, 2000

I kept getting "Can't open SQL server" when I tried running Crystal report from SMS
In SQL Enterprise Manager, Edit Registration properties, Use Window NT authentication is checked.
What account should be used in SMS to generate SMS crystal report. I appreciate any advice?

View 1 Replies View Related

Open Objects Value

Jul 31, 2000

SQL server 6.5 stopped responding. The last error messages in the SQL Server Error Log / NT Event log suggested that I increase the Open Objects / Open Databases values. I rebooted the server, increase the configuration values, and rebooted the server again for the new configuration to take affect. I suspect that the front-end application does not release the objects properly when it should; therefore increasing Open Objects / Databases configuration values will only be a temporary fix until they reach the new maximum in some time. However to prove that I need to be able to determine how many open objects / databases are on the server at a point of time. Is there a procedure or a method to determine how many open objects / dtabases are on server?

Any comments or suggestions are greatly appreciated.

Thank you
Marina Somers

View 1 Replies View Related

Open Transactions

Nov 29, 1999

Hi!

I've a dude. Can I suspend (delete, stop) open transactions in Sybase SQL Server 10 x? How? (at times I can't dump transaction log). I hope you can help me.

Thanks very much, in advance.

View 1 Replies View Related

Error While Trying To Open A DTS

Sep 20, 2004

Hi,

I have MSDE SP3 and the only thing that I have changed recently is my Windows login Password. In the

Enterprise Manager the SQL server is registered using mixed authentication.

When I try to open any DTS in Design mode, I get a error dialog with the title 'DTS Design error' and

saying that
"Error occured during creation of a DTS package"

and then when I click on the OKAY button I get the 2nd error dialog saying:
"The selected package cannot be opened. The DTS designer has been closed."

Can someone please help me out here.

Thanks.

View 5 Replies View Related

How To Open A DTS File Given To Me

Feb 28, 2001

I was given a dts file to look at based on the Northwinds DB. The file was not password protected and comes from a SQL Server Configured exactly like mine. Is there a way to open this file in the DTS design window? I could not find anything in BOL or help.
Thanks

View 1 Replies View Related

Package Won't Open

Jun 13, 2004

I have just created a package to import data from excel files, and perform some simple sql statements. I saved the package, and when I try to re-open it, I get the following error:

"Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: [DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exist or access denied."

And after I hit th "OK" button, I get the next error msg:

"The selected package cannot be opened. The DTS Designer has been closed"

Is my package completely lost? Can I open it elsewhere, or by changing some properties somewhere? Also, is there something I can do to avoid this in the future?! I hope all my work isn't lost ...

Any help would be greatly appreciated!

Brian

View 4 Replies View Related

Transaction Open

Jul 6, 2004

Hi

How do we will know whether transaction is open or closed.

Nageswar

View 3 Replies View Related

Open Query

Dec 26, 2005

Kudos to y'all!!! In the syntax...


SELECT * FROM OPENQUERY (linked server name, 'SQL Syntax')

...I'm having problems with the " ' " symbol. The SQL Syntax inside the OPENQUERY has a condition in the WHERE clause that has to be enclosed in apostophes. If it's a numeric value, I think that it doesn't need to be enclosed in apostrophes. But because the values are letters, it has to be enclosed in apostrophes. is there any way to work around this problem? I'm fetching data from an Oracle linked server by the way...

View 3 Replies View Related

1900-01-01 In Open Xml

Sep 16, 2006

we have a flat text file that has blanks in some of the date columns.
when we use open xml to import data to a table, the blank date values get loaded as 1900-01-01. why does this happen? Is there any way to get these blanks loaded as NULLs to the table.

View 1 Replies View Related

Problem In Open Mdf

Mar 21, 2008

I have sql server 2000
and itry to open mdf files with xBaseViewPro
and it give me error message ([DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found)
how can i open or convert the files to mdb
in the attachment there is a picture for the problem but there is some word in arabic(i'm sorry for that)
and ther is one of files (mdf)
pleas help me
thanks

View 10 Replies View Related

How To Open A MDF File

Jul 12, 2013

I want to start by saying I know virtually nothing about SQL Server.

I work for a website and have an old database of ours. It was exported in Sql Server 2008. It has 3 files an mdf file, a secondary data file, and a transaction log file.

When I try to attach I get an error, and the error is 5173 stating "One or more files do not match the primary file or the database." I have looked at the top 20 results for this error in a Google search and have found nothing. I just want to get in and look at some of the data, run a few basic queries.

View 2 Replies View Related

DTS To Run Open File

Jan 16, 2004

Hi All

On the Sql Peformance Monitor, I have scheduled a log to give me memory and perfomance of my server and I store the results in .csv file every hour and it works perfect.

Here comes the problem when I make a DTS to take data from .csv to Sql, my problem is, I get this error "The process cannot access the file because it is being used by another process". Basically it tells me that I have to close the file before I can run my DTS.

I dont want close this file manually and run my DTS afterwards, I want my DTS to do this automatically since I won't have access to that server when I am finished as I am going off from the clients premises when I am finished

View 2 Replies View Related

Cannot Open Database

Feb 29, 2004

Hi i am currently doing my final year project. I am using MS SQL and ASP. I uncounter the error below when i am doing my login.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 's01673925'. Login fails.

this is my connection string:
Set connection = Server.CreateObject("ADODB.Connection")
connection.Open "DSN=LocalServer1;UID=s01673925;PWD=password;DATABA SE=s01673925"

Can any1 help mi by telling mi why i cant connect 2 database?

View 8 Replies View Related

Open Query Help

Jul 23, 2005

Adding numerical field to filters in openquery is as easy as typing thenumber but I am having major problems using strings.I have tried a few solutions including the usual concantenations but nosolution. Is there a simple way of including strings with the filtersfor a query below, possibly without declaring variables and using thestring directly in the code? I have included one of the solutions I wasgiven..Thankyou for any help ...DECLARE @SQL VARCHAR(8000) DECLARE @strVar VARCHAR(1000)SET @strVar = '22'SET @SQL = 'select * FROM OPENQUERY(ISERIES,"SELECT OOLINE.OBWHLO, OOLINE.OBCUNO, OCUSMA.OKCUNM, OOLINE.OBORNO,OOLINE.OBPONR, OOLINE.OBITNO, OOLINE.OBDWDZ, OOLINE.OBORQA,OOLINE.OBATV3, OOLINE.OBATV4,OOLINE.OBATV5, OOLINE.OBROUT, OOHEAD.OADLSP, OOHEAD.OADSTX,OCUSAD.OPCUNM, OCUSAD.OPCUA1, OCUSAD.OPCUA2, OCUSAD.OPCUA3,OCUSAD.OPCUA4, MHDISH.OQDLIX, OOHEAD.OAFACI, CFACIL.CFFACN,OOHEAD.OARGDT, OOHEAD.OAPRTX, mitbal.MBPUIT, mitbal.MBSUWH,OOHEAD.OARESP, OOHEAD.OARGTM, OOLINE.OBORST, mitbal.MBOPLC,(OOLINE.OBATV0) As mark_no,(OOHEAD.OACUOR) As po_no,OOLINE.OBATV6) Ascust_bund_ID,OOLINE.OBFACI,(OOLINE.OBRORN) As DO_no, MHDISH.OQDSDTFROMmvxcdtprod.OOHEAD oohead INNER JOIN mvxcdtprod.OCUSAD ocusad ONOOHEAD.OACONO = OCUSAD.OPCONOAND OOHEAD.OACUNO = OCUSAD.OPCUNOAND OOHEAD.OAADID = OCUSAD.OPADIDINNER JOIN mvxcdtprod.CFACIL cfacil ON OOHEAD.OACONO = CFACIL.CFCONOAND OOHEAD.OADIVI = CFACIL.CFDIVIAND OOHEAD.OAFACI = CFACIL.CFFACIINNER JOIN mvxcdtprod.OCUSMA ocusma ON OOHEAD.OACONO =OCUSMA.OKCONO AND OOHEAD.OACUNO = OCUSMA.OKCUNOINNER JOIN mvxcdtprod.OOLINE ooline ON OOHEAD.OACONO =OOLINE.OBCONO AND OOHEAD.OAORNO = OOLINE.OBORNOINNER JOIN mvxcdtprod.MITBAL mitbal ON OOLINE.OBCONO =MITBAL.MBCONO AND OOLINE.OBWHLO = MITBAL.MBWHLOAND OOLINE.OBITNO = MITBAL.MBITNOINNER JOIN mvxcdtprod.MITMAS mitmas ON OOLINE.OBCONO =MITMAS.MMCONO AND OOLINE.OBITNO = MITMAS.MMITNOLEFT OUTER JOIN mvxcdtprod.MHDISL mhdisl ON MHDISL.URRIDN =OOLINE.OBORNOAND MHDISL.URRIDL/100 = OOLINE.OBPONRAND MHDISL.URCONO = OOLINE.OBCONOLEFT OUTER JOIN mvxcdtprod.mhdish mhdish ON OOLINE.OBCONO =MHDISH.OQCONOAND MHDISL.URDLIX = MHDISH.OQDLIXWHERE mitbal.MBOPLC = 3 and OOLINE.OBORST = (''''' + @strVar +''''')'') 'EXEC(@SQL)

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved