SQL String Split With | Pipe

SqlServer Connection String For JDBC When Using Named Pipe
Hi!

I'm writing a java application that queries sqlserver 2005 (and 2000). In case the sql browser service is stopped I need to use the named pipe property or the port property, right?
But how could the program know at runtime what is the port and what is the pipe name? And how should a connection string to sqlserver 2005 (and 2000) that includes named pipe, look like?

Thanks!

View Replies !

---

How To Send Long String Using SqlContext.pipe.send(strString)?
Hi,

 

I have a string almost 11006 length.. when i try to send back from SQLCLR procedure

it says cannot send ..

here is Exception Text "Message length 11060 exceeds maximum length supported of 4000."

Max limit to send a string using pipe is 4000

How I can send a string which is large in size than 4000.

 

Thanks

View Replies !

---

How To Split A String Using Sql
I have 5 dynamic rows each row consisting of 5 checkboxes & 5 dropdowns.I am concatenating the values of each controls in a row using a wildcard charater "~" and each row i am concatenating using "|".The complete string is then assigned to one hidden field and passed as sql parameter to the backend.

Please help in writing the split function to get the values of each checkboxes and dropdowns from the string in order to save them in separate columns.

Thanks

View Replies !

---

Split A String
Hi
I have this string which might have a hyphen in it "-"
What I want to do is
if I get a hyphen then take all characters after hyphen
else take only all the characters starting from the 5th position of the string
How can this be achieved?

View Replies !

---

Split A String In Sql
Hi I need a stored procedure in SQL that will split a comma separated variable passed to it
select a name for each value and return a recordset. Any pointers greatfully received.
First attempt is dreadfully slow as I am opening recordsets each time

Function func_getFood()
Dim rsfoodsql
Dim foodoutput
for x=1 to ubound(masterfoodarray)-2
set rsfoodsql= objconn.execute ("select foodname from tbl"&language&"food where foodID='"& masterfoodarray(x) &"'")
if not rsfoodsql.eof then
foodoutput=rsfoodsql("foodname")
if not foodoutput="" then
response.write foodoutput&"<BR>"
end if
end if
next
End Function

Hope someone can help,
cheers

View Replies !

---

How To Split The String
I am having City, State i need to split these two string with comma separated and to search based on the city and state how to write the select query

any one know help me

Regards,
Prabu R

View Replies !

---

How To Split A Delimeted String...
 hi,
i have a simple question, i have a sql server table named "Restaurant" and a field "Cuisines",
the values in the field Cuisines contains delimeted string. (e.g. "C1,C2,C3...C10" ,maximum to 10 items or less)
now, i want to split the values from Cuisines ("C1,C2,C3...C10") and passed all of them to a SP parameter.
e.g
@item0 nvarchar = "C1",@item1 nvarchar = "C2",@item2 nvarchar = "C3",@item3 nvarchar = "C4",@item4 nvarchar = "C5",@item5 nvarchar = "C6",@item6 nvarchar = "C7",@item7 nvarchar = "C8",@item8 nvarchar = "C9",@item9 nvarchar = "C10"
 if the field "Cuisines" contains less than 10 items, the value of the remaining parameters is null.
any response will be appreciated. thanks.
 
 

View Replies !

---

Sql Charindex Split String
HelloI am quite hopeless and of course a newbe.The situation: Sql2k / queryI would like it ot break down the following string:2004 Inventory:Ex.Plant Farm1:1st Cut:Premium:0094Whereby:Year = '2004 Inventory'plant= 'Ex.Plant Farm1'cut = '1st Cut'grade = 'Premium'lot# = '0094'It is always seperate by ':', but it can be 5 fields or 4 or 3 and sooncode to create the view:CREATE VIEW dbo.TESTASSELECT FullName, LEFT(FullName, CHARINDEX(':', FullName + ':') -1) AS year, CASE WHEN LEN(FullName) - LEN(REPLACE(FullName, ':', ''))[color=blue]> 0 THEN LTRIM(SUBSTRING(FullName,[/color]CHARINDEX(':', FullName) + 1, CHARINDEX(':', FullName + ':',CHARINDEX(':', Fullname) + 1) - CHARINDEX(':',FullName) - 1)) ELSE NULL END AS Plant, CASEWHEN LEN(FullName) - LEN(REPLACE(FullName, ':', '')) > 1 THENLTRIM(SUBSTRING(FullName,CHARINDEX(':', FullName + ':', CHARINDEX(':',FullName) + 1) + 1, CHARINDEX(':', FullName + ':', CHARINDEX(':',Fullname) + 1) - CHARINDEX(':',FullName+':') - 1)) ELSE NULL END AS [Cut]FROM dbo.ItemInventoryCan anyone help me with this? I am stuck half the way and get for cutthe rest of the string: '1st Cut:Premium:0094'Thanks!

View Replies !

---

Split The String Into Columns
 

 
I have a table called products with the values like
 
ProductId  ProductName
10            A
20           D,E,F,G
30           B,C
40           H,I,J
 
I need to display each productid's with
 
ProductId  ProductName
10           A

20           D
20           E
20           F
20           G
30           B
30          C
40          H
40          I
40          J
 
I will be appreciated if you can send me the code.
 
Thanks,
Mears
 
 

View Replies !

---

Split String Using Delimiter
Hi,

I get a string whihc looks like 'Q306/Q406 Version1/Current/Q108 Version2'

I need to split the above string and get each of those values... ' / '  delimiter

Can some one please help on this.

Thanks

 

View Replies !

---

How To Split A Comma In A String
I have a string

@string = 'abc,def,ghi'

Now I have to display

abc
def
ghi

I have to separate a comma in that
Is there an function like split in sql

plz help me
Thanks in Advance

Suresh Kumar

View Replies !

---

Split Command In String
hi all, i am still a newbie in sql

i got a problem with my query

for example:
-------------------------------
DECLARE @LongString VARCHAR(10)
@LongString = "Hello-Word"
------------------------
i want to change the LongString value by removing the "-" however i i need to identify if the @longString got "-" and delete it if it found how do i do that in sql

Thanks a lot guys

arifliminto86

View Replies !

---

SPLIT A String Inside SSIS/T-SQL Code?
 

I have a RPC which gives me multiple - single record rows like
 

Robert|K|Half|TX|1123823|1423904 -- This is one such record that i get in 1 Column
 

Now I need to split the above record into 6 Fields and populate in my local DB
I know i could use any .NET Language and accomplish this. But Iam limited to using SSIS/T-SQL Proc's
 

Any ideas / directions?

View Replies !

---

How Do I Split And Insert A Comma Delimited String To A Table?
I am passing in a string of dates, delimited by a comma.

So

01/01/04, 02/01/04, 03/01/04

etc

I would like to enter each of these values into a table via an INSERT stored procedure.

Does anyone have any code for this?

View Replies !

---

No Process Is On The Other End Of The Pipe
Hello all, I have question regarding the error message that I'm getting above. I have a program written in .NET that is suppose to traverse through a database and retrieve various records and then write a summary record. The code worked without issue. The database the used to hold the data was a SQL 7.0. However, recently I moved the server over to SQL 2005. Since that time I have been getting the following error:
       
Description: [Microsoft][SQL Native Client]Named Pipes Provider: No process is on the other end of the pipe.
       
ramdomly throughout the execution of the program. It doesn't happen on record and is intermittent when it occurs.
      
Here is the code that is having issues any help would be appreciated.
       
Thanks
Mike Gisonda
       
       
       
       Dim mreleaseqty As Double
        Dim mmakeqty As Double
        Dim k As Integer
        Dim mbackorderqty As Double
        Dim mOnOrder As Double
        Dim mOnHand As Double
        Dim mMaximumqty As Double
        Dim mMinimumQty As Double
        Dim muomfactor As Double
        Dim mSafetyStockQty As Double
        Dim mQtyInTransit As Double
        Dim mQtyAllocatedWip As Double
        Dim mQtyAllocated As Double

        Dim cnLean As New ADODB.Connection
        Dim cnSyspro As New ADODB.Connection
        Dim cnLean2 As New ADODB.Connection


        Dim cmdPullItems As New ADODB.Command 'command to retrieve pull items
        Dim cmdWHTotals As New ADODB.Command 'command to get combined warehouse totals
        Dim cmdUpdatePull As New ADODB.Command
        Dim cmdBkOrd As New ADODB.Command
        Dim cmdInvMst As New ADODB.Command
        Dim cmdInitPull As New ADODB.Command 'command to clean our old pull data

        Dim prmStockCode As New ADODB.Parameter 'parameter to supply stockcode.

        Dim rsPullItems As New ADODB.Recordset 'recordset to hold pull items.
        Dim rsWHTotals As New ADODB.Recordset 'recordset to hold warehouse records
        Dim rsBkOrd As New ADODB.Recordset
        Dim rsInvMst As New ADODB.Recordset
        Dim rsSalesOrders As New ADODB.Recordset
        Dim rsWipMaster As New ADODB.Recordset



        Dim mPullSQL As String
        Dim mWHSql As String
        Dim mBackOrderStr As String
        Dim mInvSQL As String
        Dim mStockCode As String
        Dim mSalesSQL As String
        Dim aBackOrderRec As Array
        Dim mReqDate
        Dim mShipDate As Date
        Dim mcol As Integer
        Dim mNewVal As Double
        Dim mWipSql As String
        Dim mAdjAmt As Double
        Dim mStockStatus As Integer
        Dim mBackOrder As Double
        Dim mBackLate1 As Double
        Dim mBackLate2 As Double
        Dim mBackLate3 As Double
        Dim mBackLate4 As Double
        Dim mWeeklyStDev As Double
        Dim mWeeklyUsage As Double

        Dim mBackLog1 As Double
        Dim mBackLog2 As Double
        Dim mBackLog3 As Double
        Dim mBackLog4 As Double
        Dim mBackLog5 As Double
        Dim mBackLog6 As Double
        Dim mBackLog7 As Double
        Dim mBackLog8 As Double
        Dim mBackLog9 As Double
        Dim mBackLog10 As Double
        Dim mBackLog11 As Double
        Dim mBackLog12 As Double

        Dim mLEAN_BACKORDER_BFLAG As Integer
        Dim mLEAN_LATE1_BFLAG As Integer
        Dim mLEAN_LATE2_BFLAG As Integer
        Dim mLEAN_LATE3_BFLAG As Integer
        Dim mLEAN_LATE4_BFLAG As Integer
        Dim mLEAN_BACKLOG1_BFLAG As Integer
        Dim mLEAN_BACKLOG2_BFLAG As Integer
        Dim mLEAN_BACKLOG3_BFLAG As Integer
        Dim mLEAN_BACKLOG4_BFLAG As Integer
        Dim mLEAN_BACKLOG5_BFLAG As Integer
        Dim mLEAN_BACKLOG6_BFLAG As Integer
        Dim mLEAN_BACKLOG7_BFLAG As Integer
        Dim mLEAN_BACKLOG8_BFLAG As Integer
        Dim mLEAN_BACKLOG9_BFLAG As Integer
        Dim mLEAN_BACKLOG10_BFLAG As Integer
        Dim mLEAN_BACKLOG11_BFLAG As Integer
        Dim mLEAN_BACKLOG12_BFLAG As Integer

        Dim mBFlagValue As Integer
        Dim mFileNum As Integer
        Dim mTrnFileNum As Integer
        Dim mtest As String
        Dim mCountOfRecords As Long
        Dim mPullCount As String
        Dim rsPullcount As ADODB.Recordset
        Dim mCurRecordCount As Long

        Dim mWipAllSQL As String
        Dim rsWipAll As New ADODB.Recordset


        'On Error GoTo ehbtnUpdateLean_Click
        'open connection to springdesign
        With cnLean
            .ConnectionString = "DSN=SPRINGDESIGN;UID=sa;PWD="
            .Open()
        End With
        With cnLean2
            .ConnectionString = "DSN=SPRINGDESIGN;UID=sa;PWD="
            .Open()
        End With

        'open connection to syspro
        With cnSyspro
            .ConnectionString = "DSN=COMPANYM;UID=sa;pwd="
            .CommandTimeout = 300
            .Open()
        End With
        btnUpdateLean.Enabled = False
        Me.Cursor = Cursors.WaitCursor

    **
    Bunch of code to set up commands and select statements
    **
        'Initial command that will update the pull records as they are being processed.
        With cmdUpdatePull
            .let_ActiveConnection(cnLean)
            .CommandType = ADODB.CommandTypeEnum.adCmdStoredProc
            .CommandText = "sp_MX_Daily_UpdateMRPData"
            .CommandTimeout = 300
            .Parameters.Refresh()
        End With

    **
    More Code
    **

        Try
            rsPullItems.CursorLocation = ADODB.CursorLocationEnum.adUseClient
            'Get all the pull items.
            'rsPullItems = cmdPullItems.Execute
            rsPullItems.Open(mPullSQL, cnLean2)
            rsPullItems.ActiveConnection = Nothing

        Catch ex As Exception
            mtest = "Exception Message: " & ex.Message & vbCrLf & "SQLStatement: " & cmdPullItems.CommandText
            LogError("", mtest)
            rsPullItems = Nothing

        End Try

        Try
            'Initialize debugging and transaction files.
            mFileNum = FreeFile()
            FileOpen(mFileNum, "MXtestdebug.txt", OpenMode.Output, OpenAccess.Default, OpenShare.Shared)
            PrintLine(mFileNum, "Start " + Format(Now, "hh:mms"))
            mTrnFileNum = FreeFile()
            FileOpen(mTrnFileNum, "MXTrndebug.txt", OpenMode.Output, OpenAccess.Default, OpenShare.Shared)
        Catch ex As Exception
        End Try


        mCurRecordCount = 0
        'Start working.
        If IsNothing(rsPullItems) = False Then
            Do While rsPullItems.EOF = False
                mCurRecordCount += 1


                'Initialize parameter values
                cmdUpdatePull.Parameters("@stock_code").Value = mStockCode
                cmdUpdatePull.Parameters("@MINIMUM_QTY").Value = 0
                cmdUpdatePull.Parameters("@MAXIMUM_QTY").Value = 0
                cmdUpdatePull.Parameters("@SAFETYSTOCKQTY").Value = 0

                cmdUpdatePull.Parameters("@ON_HAND").Value = 0
                cmdUpdatePull.Parameters("@ON_ORDER").Value = 0
                cmdUpdatePull.Parameters("@BACKORDER_QTY").Value = 0
                cmdUpdatePull.Parameters("@MAKE_QTY").Value = 0
                cmdUpdatePull.Parameters("@RELEASE_QTY").Value = 0

                cmdUpdatePull.Parameters("@LEAN_BACKORDER").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_LATE1").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_LATE2").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_LATE3").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_LATE4").Value = 0.0

                cmdUpdatePull.Parameters("@LEAN_BACKLOG1").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG2").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG3").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG4").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG5").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG6").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG7").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG8").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG9").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG10").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG11").Value = 0.0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG12").Value = 0.0

                'Initial flags used to determine if the individual sales order dates are
                'before or after the request date.
                cmdUpdatePull.Parameters("@LEAN_BACKORDER_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_LATE1_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_LATE2_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_LATE3_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_LATE4_BFLAG").Value = 0

                cmdUpdatePull.Parameters("@LEAN_BACKLOG1_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG2_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG3_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG4_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG5_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG6_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG7_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG8_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG9_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG10_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG11_BFLAG").Value = 0
                cmdUpdatePull.Parameters("@LEAN_BACKLOG12_BFLAG").Value = 0


                cmdUpdatePull.Parameters("@LEANMFG_STOCKSTATUS").Value = 0

        **
        **
                Try
                    'Get warehouse totals
                    rsWHTotals = New ADODB.Recordset
                    rsWHTotals = cmdWHTotals.Execute
                Catch ex As Exception
                    mtest = "Exception Message: " & ex.Message & vbCrLf & "SQLStatement: " & cmdWHTotals.CommandText
                    LogError(mStockCode, mtest)
                    rsWHTotals = Nothing

                End Try

        **
        **
                If IsNothing(rsWHTotals) = False Then
                    If rsWHTotals.EOF = False Then          'If there are values in the warehouse query.
                        **
                        BUNCH MORE CODE
                        **
                        cmdUpdatePull.Parameters("@stock_code").Value = mStockCode
                        cmdUpdatePull.Parameters("@MINIMUM_QTY").Value = mMinimumQty
                        cmdUpdatePull.Parameters("@MAXIMUM_QTY").Value = mMaximumqty
                        cmdUpdatePull.Parameters("@SAFETYSTOCKQTY").Value = mSafetyStockQty

                        cmdUpdatePull.Parameters("@ON_HAND").Value = mOnHand
                        cmdUpdatePull.Parameters("@ON_ORDER").Value = mOnOrder
            **
                        cmdUpdatePull.Parameters("@BACKORDER_QTY").Value = mbackorderqty
                        mmakeqty = (mMaximumqty - mOnHand)
                        If mmakeqty > 0 Then
                            cmdUpdatePull.Parameters("@MAKE_QTY").Value = mmakeqty
                        Else
                            cmdUpdatePull.Parameters("@MAKE_QTY").Value = 0
                        End If



                        'init varables.

                        cmdUpdatePull.Parameters("@LEAN_BACKORDER").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_LATE1").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_LATE2").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_LATE3").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_LATE4").Value = 0.0

                        cmdUpdatePull.Parameters("@LEAN_BACKLOG1").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG2").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG3").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG4").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG5").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG6").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG7").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG8").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG9").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG10").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG11").Value = 0.0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG12").Value = 0.0
                        mBackOrder = 0.0
                        mBackLate1 = 0.0
                        mBackLate2 = 0.0
                        mBackLate3 = 0.0
                        mBackLate4 = 0.0
                        mBackLog1 = 0.0
                        mBackLog2 = 0.0
                        mBackLog3 = 0.0
                        mBackLog4 = 0.0
                        mBackLog5 = 0.0
                        mBackLog6 = 0.0
                        mBackLog7 = 0.0
                        mBackLog8 = 0.0
                        mBackLog9 = 0.0
                        mBackLog10 = 0.0
                        mBackLog11 = 0.0
                        mBackLog12 = 0.0

                        'Initiale Binary flags that represent if the ship date is
                        'before or after the request date.
                        cmdUpdatePull.Parameters("@LEAN_BACKORDER_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_LATE1_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_LATE2_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_LATE3_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_LATE4_BFLAG").Value = 0

                        cmdUpdatePull.Parameters("@LEAN_BACKLOG1_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG2_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG3_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG4_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG5_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG6_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG7_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG8_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG9_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG10_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG11_BFLAG").Value = 0
                        cmdUpdatePull.Parameters("@LEAN_BACKLOG12_BFLAG").Value = 0

                        mBackOrder = 0.0
                        mBackLate1 = 0.0
                        mBackLate2 = 0.0
                        mBackLate3 = 0.0
                        mBackLate4 = 0.0
                        mBackLog1 = 0.0
                        mBackLog2 = 0.0
                        mBackLog3 = 0.0
                        mBackLog4 = 0.0
                        mBackLog5 = 0.0
                        mBackLog6 = 0.0
                        mBackLog7 = 0.0
                        mBackLog8 = 0.0
                        mBackLog9 = 0.0
                        mBackLog10 = 0.0
                        mBackLog11 = 0.0
                        mBackLog12 = 0.0

                        mLEAN_BACKORDER_BFLAG = 0
                        mLEAN_LATE1_BFLAG = 0
                        mLEAN_LATE2_BFLAG = 0
                        mLEAN_LATE3_BFLAG = 0
                        mLEAN_LATE4_BFLAG = 0
                        mLEAN_BACKLOG1_BFLAG = 0
                        mLEAN_BACKLOG2_BFLAG = 0
                        mLEAN_BACKLOG3_BFLAG = 0
                        mLEAN_BACKLOG4_BFLAG = 0
                        mLEAN_BACKLOG5_BFLAG = 0
                        mLEAN_BACKLOG6_BFLAG = 0
                        mLEAN_BACKLOG7_BFLAG = 0
                        mLEAN_BACKLOG8_BFLAG = 0
                        mLEAN_BACKLOG9_BFLAG = 0
                        mLEAN_BACKLOG10_BFLAG = 0
                        mLEAN_BACKLOG11_BFLAG = 0
                        mLEAN_BACKLOG12_BFLAG = 0

                        mBFlagValue = 0


            **
            more Code
            **
                        Try
                            rsSalesOrders = New ADODB.Recordset
                            rsSalesOrders.Open(mSalesSQL, cnSyspro)
                        Catch ex As Exception
                            mtest = "Exception Message: " & ex.Message & vbCrLf & "SQLStatement: " & mSalesSQL
                            LogError(mStockCode, mtest)
                            rsSalesOrders = Nothing
                        End Try

                        
                        If IsNothing(rsSalesOrders) = False Then
                            Do While rsSalesOrders.EOF = False
                            **
                            More Code
                            **
                                    Select Case mcol
                                        Case Is <= -5
                                            cmdUpdatePull.Parameters("@LEAN_BACKORDER").Value = cmdUpdatePull.Parameters("@LEAN_BACKORDER").Value + mNewVal
                                            'Check to see if the bit is marked. If not then mark it.
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKORDER_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_BACKORDER_BFLAG").Value = cmdUpdatePull.Parameters("@LEAN_BACKORDER_BFLAG").Value + mBFlagValue
                                            End If

                                            mBackOrder = mBackOrder + mNewVal

                                        Case Is = -4
                                            cmdUpdatePull.Parameters("@LEAN_LATE4").Value = cmdUpdatePull.Parameters("@LEAN_LATE4").Value + mNewVal
                                            'Check to see if the bit is marked. If not then mark it.
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_LATE4_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_LATE4_BFLAG").Value = cmdUpdatePull.Parameters("@LEAN_LATE4_BFLAG").Value + mBFlagValue
                                            End If

                                            mBackLate4 = mBackLate4 + mNewVal

                                        Case Is = -3
                                            cmdUpdatePull.Parameters("@LEAN_LATE3").Value = cmdUpdatePull.Parameters("@LEAN_LATE3").Value + mNewVal
                                            'Check to see if the bit is marked. If not then mark it.
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_LATE3_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_LATE3_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_LATE3_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLate3 = mBackLate3 + mNewVal

                                        Case Is = -2
                                            cmdUpdatePull.Parameters("@LEAN_LATE2").Value = cmdUpdatePull.Parameters("@LEAN_LATE2").Value + mNewVal
                                            'Check to see if the bit is marked. If not then mark it.
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_LATE2_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_LATE2_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_LATE2_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLate2 = mBackLate2 + mNewVal

                                        Case -1 To 0
                                            cmdUpdatePull.Parameters("@LEAN_LATE1").Value = cmdUpdatePull.Parameters("@LEAN_LATE1").Value + mNewVal
                                            'Check to see if the bit is marked. If not then mark it.
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_LATE1_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_LATE1_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_LATE1_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLate1 = mBackLate1 + mNewVal

                                        Case Is = 1
                                            cmdUpdatePull.Parameters("@LEAN_BACKLOG1").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG1").Value + mNewVal
                                            'Check to see if the bit is marked. If not then mark it.
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG1_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_BACKLOG1_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG1_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLog1 = mBackLog1 + mNewVal
                                        Case Is = 2
                                            cmdUpdatePull.Parameters("@LEAN_BACKLOG2").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG2").Value + mNewVal
                                            'Check to see if the bit is marked. If not then mark it.
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG2_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_BACKLOG2_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG2_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLog2 = mBackLog2 + mNewVal

                                        Case Is = 3
                                            cmdUpdatePull.Parameters("@LEAN_BACKLOG3").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG3").Value + mNewVal
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG3_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_BACKLOG3_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG3_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLog3 = mBackLog3 + mNewVal

                                        Case Is = 4
                                            cmdUpdatePull.Parameters("@LEAN_BACKLOG4").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG4").Value + mNewVal
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG4_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_BACKLOG4_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG4_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLog4 = mBackLog4 + mNewVal

                                        Case Is = 5
                                            cmdUpdatePull.Parameters("@LEAN_BACKLOG5").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG5").Value + mNewVal
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG5_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_BACKLOG5_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG5_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLog5 = mBackLog5 + mNewVal

                                        Case Is = 6
                                            cmdUpdatePull.Parameters("@LEAN_BACKLOG6").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG6").Value + mNewVal
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG6_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_BACKLOG6_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG6_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLog6 = mBackLog6 + mNewVal

                                        Case Is = 7
                                            cmdUpdatePull.Parameters("@LEAN_BACKLOG7").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG7").Value + mNewVal
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG7_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_BACKLOG7_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG7_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLog7 = mBackLog7 + mNewVal

                                        Case Is = 8
                                            cmdUpdatePull.Parameters("@LEAN_BACKLOG8").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG8").Value + mNewVal
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG8_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_BACKLOG8_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG8_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLog8 = mBackLog8 + mNewVal

                                        Case Is = 9
                                            cmdUpdatePull.Parameters("@LEAN_BACKLOG9").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG9").Value + mNewVal
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG9_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_BACKLOG9_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG9_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLog9 = mBackLog9 + mNewVal

                                        Case Is = 10
                                            cmdUpdatePull.Parameters("@LEAN_BACKLOG10").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG10").Value + mNewVal
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG10_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_BACKLOG10_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG10_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLog10 = mBackLog10 + mNewVal

                                        Case Is = 11
                                            cmdUpdatePull.Parameters("@LEAN_BACKLOG11").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG11").Value + mNewVal
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG11_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_BACKLOG11_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG11_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLog11 = mBackLog11 + mNewVal

                                        Case Is = 12
                                            cmdUpdatePull.Parameters("@LEAN_BACKLOG12").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG12").Value + mNewVal
                                            If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG12_BFLAG").Value And mBFlagValue) Then
                                                cmdUpdatePull.Parameters("@LEAN_BACKLOG12_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG12_BFLAG").Value + mBFlagValue)
                                            End If

                                            mBackLog12 = mBackLog12 + mNewVal


                                    End Select
                                End If
                                rsSalesOrders.MoveNext()
                            Loop
                            rsSalesOrders.Close()
                            rsSalesOrders = Nothing
                        End If

            **
            More Code
            **




                        cmdUpdatePull.Parameters("@LEANMFG_STOCKSTATUS").Value = mStockStatus


            **
            More Code
            **

                    Else
                        cmdUpdatePull.Parameters("@stock_code").Value = mStockCode
                    End If
                    rsWHTotals.Close()
                    rsWHTotals = Nothing
                Else 'rswhtotal is nothing
                    cmdUpdatePull.Parameters("@stock_code").Value = mStockCode
                End If  'rswhtotal is nothing


                'Update the record in DesignLean
                Try
            *********
            This is where it fails
            *********
                    cmdUpdatePull.Execute()

                Catch ex As Exception
                    mtest = "ERROR executing cmdupdatepull" & vbCrLf & "Exception Message: " & ex.Message & vbCrLf
                    LogError(mStockCode, mtest)
                    PrintLine(mTrnFileNum, mtest)

                End Try

                PrintLine(mTrnFileNum, "Finished to update cmdUpdatePull")


                'Move to next record
                rsPullItems.MoveNext()
                PrintLine(mTrnFileNum, "Moving to next rsPullItems")

            Loop
            rsPullItems.Close()
            rsPullItems = Nothing
            cmdUpdatePull = Nothing
            rsSalesOrders = Nothing
            rsWipMaster = Nothing
        End If

        PrintLine(mTrnFileNum, "End of Pull Items LOOP")
        FileClose(mTrnFileNum)


        PrintLine(mFileNum, "ending" + Format(Now, "hh:mms"))
        FileClose(mFileNum)
        ProgressBar1.Value = mCountOfRecords + 100
        btnUpdateLean.Enabled = True
        Me.Cursor = Cursors.Default

        MsgBox("done", MsgBoxStyle.OKOnly, "MXLean Calculation Status")




        End

        Exit Sub

View Replies !

---

No Processes On The End Of PIPE
I had to move my developed software onto another computer in order to demo this.  The new computer has IIS installed as well as VS2005 and SQL Server 2005.  When I try to execute I get this error.

 

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

I have worked on this problem for two days now and have to demo it first thing Monday.  Any help would be appreciated. 

 

View Replies !

---

Pipe Delimiter Problem
Can somebody help me with a delimiter problem I have.I have several PIPE (|) delimted text files which I need to import toSQL.With one of the files I keep encountering the following error;"Error at Source for Row 27753. Errors encountered so far in this task:1. Column Delimter not found."I suspect the problem is that one record (and possibly more) has a PIPE(|) within a field, because some of the fields contain free text.Getting an export of the file again using a different delimter like tabor comma will not work as these characters occur throughout the file.I'm open to suggestions as to how to resolve this and really need toget a solution soon.One solution I was thinking of, but do not know how to execute is tocount the number of PIPEs on each record and then manually change therecords which have count which is inconsistent with the rest of thefile.I've also tried importing to Access first and then SQL, as this hasworked for me in the past, but it did not work.Regards,Ciarán

View Replies !

---

Size Of Pipe To Network
My group has recently begun ramping up #of users from 5-10 to 50 concurrent. I'm currently using a 10Mb/s Ethernet but am not sure if there is a fiber
or multiplexing solution that I could use to increase output. Basically, we're looking at up to 50 heavy duty data pulls (50MB+) at any one time.

Thanx,

Joe

View Replies !

---

Error: 0 - No Process Is On The Other End Of The Pipe
I can use SQL Server Management Studio Express to connect to my local database SQL 2005 database on bknjisqlexpress.

I am also able to connect to the database from Visual Studio, and this is where I copied the following connection string to be used in my C# code

string myConnectString = "Data Source=BKFNJI\SQLEXPRESS;" +

 "Initial Catalog=cmiCompatibilityDataBase" +

"Integrated Security=True;Pooling=False";

// specify SQL Server Specific Connection string

SqlConnection cmiDBCompConnection = new SqlConnection(myConnectString);

cmiDBCompConnection.Open();

 

when I attempt to run the apps, I get the

"System.Data.SqlClient.SqlException was unhandled
  Message="A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)".....


any idea what I am doing wrong, given that the connection string works using other means?  I am using Windows authentication.

To add, the error in my log shows:

2007-03-17 21:10:55.82 Logon       Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>]

Thanks,

Klaus

View Replies !

---

Using Pipe Like Symbols To Add Parentheses??
Hi all,

I was told recently that doing the following:

SELECT ProductName ||' , '|| Category FROM PRODUCTS

would add parentheses around the ProductName field data. However, after trying it out for myself I found it did no such thing.

Does this look familiar to anyone? Is it syntax I have wrong or something?

Butterfly82

View Replies !

---

Exporting To Pipe-delimited
Has any one managed to get Report Manager to have the option to export to pipe delimited? There are documents out there how to do it on SSRS; I need it on Report Manager. Any Suggestions?

DGraham
vbwrangler@yahoo.com

View Replies !

---

Error 41 Broken Pipe - Any Ideas
Hi guys,

Running a clustered webserver, windows 2000, IIS v5, and a sql server, v2000. Using OLE Db as connection, running stored procedures, no sql created on the fly. The website handles about 5000 transaction a day.

Every now and again, we get a problem whereby an error 41 - Broken Pipe is reported. I can't find any info on this error on Technet, MSDN, etc. Google returns info, but only really affecting solaris, unix, linux, etc.

Anyone ever come across this error before? or know what might cause it? and possible resolutions?

View Replies !

---

Connecting To An SQL Named Pipe Alias
 

Hi All , I have been racking my head on this for the last two days and really it should be a no brainier. Anyways I can only assume that I€™m missing something here but...

 

In a nut shell I am attempting to connect to a new SQL Alias that i have created by simply adding the following in the client network utility

Current SQL server name DASQL

Default instance

 

Alias Name: TASQL

Server Name:  DASQL

Pipe Name: \DASQLpipesqlquery

 

I can connect the new alias via the local (server consol) yet when i attempt to connect remotely it times out as if it can't find the server.

 

Any Thought?

Thanks
 

View Replies !

---

Linked Server With Named Pipe
 

Linked server is created as (from SQL 2005 to SQL 2000)


EXEC sp_addlinkedserver @server = @SPKServerName,

@srvproduct = '',

@provider = 'SQLOLEDB',

@datasrc = @SPKdatasrc        //np:remoteservername
 

exec sp_serveroption @server = @SPKServerName

, @optname = 'rpc'

, @optvalue = 'on'

exec sp_serveroption @server = @SPKServerName

, @optname = 'rpc out'

, @optvalue = 'on'

exec sp_serveroption @server = @SPKServerName

, @optname = 'data access'

, @optvalue = 'on'

 
when asp.net applicaiton  hits the Stored Procedure, it uses Linked server to get data from remote server. It fails with exception message
 
OLE DB provider "SQLNCLI" for linked server "ServerName" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "ServerName" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
Msg 5, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [5].

 
Any idea how to solve this?
 
Regards,

View Replies !

---

Tokenizing Column Data Using Pipe Symbol
Hey everyone,

 I'm working of a project that has each row of column data stored in this format: AAChieve Initiative - Business Development Consultant|Marketing|4F|210710
 Is there a way I can break this rows apart with TSQL based of the | symbol? Thanks in advance!
 

View Replies !

---

Shared Memory No Process Other End Of Pipe Error
There appear to be a number of users who have encountered the "SQL Native Client Shared Memory Provider No Process at the Other End of the Pipe" error. We encountered a problem in which the error was consistantly cleared only with a clean install of the operating system and SQL Server. Removing SQL Server, cleaning the registry and a variety of other procedures did not resolve the problem.

KB309398 describes a Certificate problem that can cause the Pipe error.
See: http://support.microsoft.com/kb/309398

The kb article describes the problem as follows:

Quote
SQL Server 2000 introduces Secure Sockets Layer (SSL) encryption through the use of certificates. If SQL Server finds certificates on the local computer, SQL Server attempts to use the certificates. If the certificate is not issued to the fully qualified domain name of the computer, SQL Server considers the certificate invalid. If there are multiple certificates on the computer, there is no way to pick which certificate SQL Server must use.

You must identify the source of the certificates on the computer before you proceed. For the SQL Server 2000 installation to be successful, you must use the Microsoft Management Console (MMC) snap-in to view the certificates on your computer.
End Quote

I was astonished to find out that a Certificate that is unrelated to SQL Server can cause a Server connection failure. We temporarily removed all of the Personal Certificates and the Pipe Error was gone. This fix may not work for everyone, but it did solve our problem.

View Replies !

---

Help!!!Cannot Connect To Remote Sql Server By Named Pipe
Hi, all,

 

I installed sql server 2005 express on a server with window server 2003 SP1 and tried to connect it from a remote computer with vista installed. 

I have already enabled named pipe and tcp/ip protocol for instance SQLEXPRESS on the server, and started sql server browser as well. Of course, I also enabled local and remote connection using tcp/ip and named pipe by sql server surface area configuration tool.

In this senario, I can connect to server locally or remotely by tcp/ip and connect to server locally by named pipe(c>sqlcmd -S \192.168.1.100pipeMSSQL$SQLEXPRESSsqlquery -U * -P *), but I can not connect to server  remotely using same command line.

According to some article from MSDN, it might be caused by firewall, but I already disabled my firewall. Moreover, I used tools like makepipe.exe and readpipe.exe, they didn't work too. Why the 2 computers can't create connection using named pipe protocol.

 

Thanks.

 

Johonson Chan

 

 

View Replies !

---

How Can I Create A Pipe-Delimited Export Option?
i've read that it's possible and this is what i entered in my rsreportserver.config file.

<Extension Name="PIPE" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
                <OVerrideNames>
                    <Name Language="en-US">PIPE Delimited CSV</Name>
                </OverrideNames>
                <Configuration>
                    <DeviceInfo>
                        <FieldDelimiter>"%7C"</FieldDelimiter>
                    </DeviceInfo>
                </COnfiguration>
            </Extension>

I'm following the directions of the guide and it seems to crash my report server. can you help out? thanks in advance.

View Replies !

---

Why Can I Nolonger Backup My Database To A Named Pipe?
Why can I no longer backup a database to a named pipe in SQL Server 2005? Named pipes are much easier to work with than VDI (and VDI is covered in obscurities). I really want the ability to dump a database to a named pipe reimplementation if it€™s been removed. I hate to think of the cost of redesigning our backup applications. Can I force a PIPE dump device into the sysdevices table? Any suggestions? (and DO NOT tell me to use VDI, as it is absurdly cumbersome and loaded with unnecessary dependencies)
 
BACKUP DATABASE <name> TO PIPE=\.pipeMyPipeName

View Replies !

---

SqlContext.Pipe.Send Flush To Display
I have a very long running sqlclr sp (fuzzy matching thousands of addresses) and I just spent 45 min adding onprogress delegates to the classes (had to back up after trying to use eventing, synchronization is not allowed in safe), so I could see the progress output in the sql ide. To get that warm and fuzzy "it's actually working, and I can leave tonight" feeling.

But... of course my slick onprogress messages are not even displayed until the process completes. Or is canceled. I've noticed that in some cases (nothing that I've written), progress information is shown while actually in progress, and in other cases it dumps it all out at completion.

Is this behavior controllable? Is there a way to flush or prevent the buffering in the first place?

View Replies !

---

Can't Connect To SQL Server 2005 With Pet Shop 4.0 : No Process At Other End Of Pipe?!
I downloaded MS Pet Shop 4.0 recently for best-practice training purposes. The installation went smoothly with a SQL Server 2005 backend. At first I had a problem authenticating the mspetshop4 user in the database, but that was solved by fixing some settings with the password policy. Now the mspetshop4 user is authenticated properly, but I came across this error instead:Server Error in '/Web' Application.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
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: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

Source Error:

Line 216:
Line 217: if (conn.State != ConnectionState.Open)
Line 218: conn.Open();
Line 219:
Line 220: cmd.Connection = conn;


Source File: C:Program FilesMicrosoft.NET Pet Shop 4.0DBUtilitySQLHelper.cs Line: 218

Stack Trace:

[SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +117
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346
System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) +619
System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) +224
System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) +113
System.Data.SqlClient.TdsParserStateObject.ReadBuffer() +59
System.Data.SqlClient.TdsParserStateObject.ReadByte() +36
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +181
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +56
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +1083
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +272
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +688
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +82
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +558
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +126
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +651
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +160
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +122
System.Data.SqlClient.SqlConnection.Open() +229
PetShop.DBUtility.SqlHelper.PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, String cmdText, SqlParameter[] cmdParms) in C:Program FilesMicrosoft.NET Pet Shop 4.0DBUtilitySQLHelper.cs:218
PetShop.DBUtility.SqlHelper.ExecuteReader(String connectionString, CommandType cmdType, String cmdText, SqlParameter[] commandParameters) in C:Program FilesMicrosoft.NET Pet Shop 4.0DBUtilitySQLHelper.cs:127
PetShop.SQLServerDAL.Category.GetCategories() in C:Program FilesMicrosoft.NET Pet Shop 4.0SQLServerCategory.cs:27
PetShop.BLL.Category.GetCategories() in C:Program FilesMicrosoft.NET Pet Shop 4.0BLLCategory.cs:20
PetShop.Web.NavigationControl.BindCategories() in c:Program FilesMicrosoft.NET Pet Shop 4.0WebControlsNavigationControl.ascx.cs:53
PetShop.Web.NavigationControl.Page_Load(Object sender, EventArgs e) in c:Program FilesMicrosoft.NET Pet Shop 4.0WebControlsNavigationControl.ascx.cs:27
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +31
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +68
System.Web.UI.Control.OnLoad(EventArgs e) +88
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Control.LoadRecursive() +158
System.Web.UI.BasePartialCachingControl.LoadRecursive() +61
System.Web.UI.Control.LoadRecursive() +158
System.Web.UI.Control.LoadRecursive() +158
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3035


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42Now I'm clueless. What does No process at the other end of the pipe mean? 

View Replies !

---

Automatic Backup Of The Pubs And Msdb Database...pipe
While checking the SQL server error logs, I notice that the pubs and msdb database are automatically being backed up, even though no job is set up to do so....in addition, its backing up to a directory that I cannot find on our network.....does anybody have an idea of whats going on ?

the path its backingup to is:
(FILE=1, TYPE=PIPE: {'.pipedbasql70dbagent0s0'}).

Thank you in advance

View Replies !

---

SQL Limit Of Demilted Pipe Characters Passed As Parameter To Sql Query
I am not sure about the architecture of the Issue Tracker and hence not sure if it applies here. But I will post in any case and wait for users on this forums comments as well.



===========Earlier post==================
This question is regarding the architecture of TimeEntry.
In some programs it builds an arrayList for Master-detail type of relationship and when user is ready to save it by clicking 'submit' it build a variable with pipe delimited fields.
This is then passed to a sql query.

This to me does not seem to be an efficient manner. Because the max character is 1500 chars as parameter to SQL query.


I was wondering if instead I could store it as an XML and then use the XML to import in to SQL.


Any ideas is greatly appreciated, I am running in to problems where my variable construct does increase to more than 1500 chars. Any thoughts are much appreciated in this regards.

Regards,
MillenniumIte.

View Replies !

---

Named Pipe Provider/Linked Server Connection Error
Hello, everyone!

I'm currently having an issue with a linked server. Here's the surrounding information:
 
A) I have a clustered SQL Server 2005 Instance (A) and a SQL Server 2000 instance (B).
B) There is a linked server on A to B. When I set it up, I did run the fix to ensure A could talk to B (There was an issue with communication between 2005 and 2000 servers). It has been there since I installed A, and has worked fine.. Until last week.
C) This linked server uses static credentials to connect to B.
D) Named Pipes are enabled on both servers to listen to both connections on both A and B in cliconfg. So A has a named pipe listening for B, and B has a named pipe listening for A.
E) A has a view  that looks at a table on B - It's a table view, very simple, just pulls in all the data from the table on B.
 
 
So, I go to do a select statement from the view, connected as a user other then 'sa'.  I then get the error:
 
Named Pipes Provider: Could not open a connection to SQL Server Linked Server
Error Source: ncli Client (Paraphrasing, didn't copy that down, but it was the ODBC connector)
 
Well, that's odd. It's been working fine for months now..

I then go and connect as sa on A to query B. It works! Mind you, absolutely NO QUERY from A to B will run again until I run SOME kind of query has been run as sa on A.
 
Mind you, this is not a credential issue. Every user who connects to the linked server to B uses a stored credential that is DBO to the database on B. The same User Name and Password exists on both A and B.
 
Also of note, I check the activity monitor. There's a process that is "dormant" every time I run a query against the view. The details of this connection are:

sp_reset_connection;1
 
My question is, why is it resetting the connection on B when being queried from A? Why is it "all of a sudden" a problem? Are there any changes that coudl ahve been made that would cause this?

Any help with this confusing issue would be appreciated.

Thanks!
 
 

View Replies !

---

Install Problem: Shared Memory Provider: No Process Is On The Other End Of The Pipe.
When I try to install MsSQL Server 2005 Develop Edition do I get the error:

[Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.

I have trying to look at other posts on this forum and elsewhere, but cant find any solution that works for me - mainly cuz all solutions is after the installing.

Before trying to install MsSQL Server 2005 Dev did I install VS.Net 2005 Pro. First did the Native Client make troubles, but got it to work with reinstalling it, but now does the SQL setup stop on every try with the error above.

I have tried looking if the MSSQLServer is running when it tries to connect during install, and everything says it is running (Services, Net start, Taskman.).

I dont run any special setup on my system - it is a normal Windows XP Pro SP2 with all updates. I just need the SQL server installed so I can develop locally without access to out main SQL server.

I have been using MsSQL 2000 before and never had any problems, but the 2005 keep on bugging me.

The only solution I havent tried is to reinstall Windows itself, but I will pref. not to do so.

 

And to be honest, then have I no idea what a "pipe" is - I am used to develop webapplications and not so much on server maintaince/troubleshooting.

 

Need some more information? Then just ask.

 

 

 

View Replies !

---

JDBC Sample Code Using Named Pipe And SQLServer 2005 Driver?
Hi,

Does anybody have a working Java code sample that connects to an SQLServer 2005 database on a remote host, via the default named pipe, from a client using the SQLServer 2005 JDBC driver?  Could you post it, or a pointer to it?

I've gotten java.sql DriverManager.getConnection() to work fine with TCP/IP connections before.  But I'm a newbie with named pipes, and unclear on how the connection string/properties are different.  I've tried to piece it together from multiple docs and threads, but haven't found sample code that quite fits my situation.  I think a simple working example would best clarify the syntax.

The server is not using SQL Express.  Most SQLServer configuration options are defaults; the named pipes protocol is enabled. 

Thanks 

 

View Replies !

---

Provider: Named Pipe Provider, Error: 40 - Could Not Open Connection To SQL Server
After I installed the various service packs via Windows Update, my WindowsForms application can no longer connect to the server.

 

The error message is:

 

provider: Named Pipe Provider, error: 40 - Could not open connection to SQL server.

 

However, the Reporting Services work just fine.

 

Please help.

View Replies !

---

(provider: Shared Memory Provider, Error: 0 - No Process Is On The Other End Of The Pipe.)
 I am getting the following error when i try to connect to the my web site using froma different server.  A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)  i am using sql express and i attach the database through the connection string in the web config. Any ideas

View Replies !

---

When Trying To Connect I Get The Following Error: &&"No Process Is On The Other End Of The Pipe&&"
I had to un-install and re-install SQL Server 2005 for a different problem which has been resolved.
 
But now when I try to make a connection to the database I get the following error:
 
"...No process is on the other end of the pipe"
 
I have verified that the server allows named pipeing which seems to be the common answer I found after searching.  I have also verified that the account I use is setup and has all the proper permissions.
 
Can someone help me in resolving this issue noting what I have verified above???
 
Thanks...

View Replies !

---

Info: &"No Process Is On The Other End Of The Pipe&"
I just spent an hour finding out that one possible diagnosis of this problem is that there is no database with the name you are looking for attached to the database server you have specified in your machine.config.  Just hoping to save someone else time here.   

View Replies !

---

Employing XML Formatted String Data Rather Than Normal String(char(), Nchar() Or Varchar() Values
Hello,
Is there a way of passing in an xml formatted string or text to the report through a data set and have the textbox or table in which it displays keep the formatting specified in the xml string rather than in the textbox properties?
 
Thanks.

View Replies !

---

String Or Binary Data Would Be Truncated. (only For 1700 Character String?)
I am trying to insert a row into a table of Microsoft SQL Server 2000.

There are various columns.















[SNO] [numeric](3, 0) NOT NULL ,
[DATT] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
,
[DATTA] [char] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
,
[CODECS] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
,

The [DATTA] column is causing a problem. Even if I am trying to put only 1700 character string into [DATTA], the java code throws the following exception:-



StaleConnecti A CONM7007I: Mapping the following
SQLException, with ErrorCode 0 and SQLState 08S01, to a
StaleConnectionException: java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC]Connection reset

      at
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)


Why is it throwing an exception even though the sum-total of this row doesn't exceed 8000 characters?

Can anyone please tell me what's wrong?

View Replies !

---

Name Split
Quick question.

I've got a CHAR (70) field called NAME that has a first and last name separated by a space. I want to split it into two fields FIRST and LAST -- with all the characters to the left of the space a first name and all the characters to the right of the space as last name. I couldn't find a string function that would let me do this simply (it may be right in front of me and I missed it).

Thanks in advance.

Ray

View Replies !

---

Name Split
I need to split a column of Full Names into First name and Last name columns. Has someone come across this before and if so can you give me an idea of how to overcome it?

View Replies !

---

Split Value In Sql
Hi to all

I have one problem regarding sp and pass value in sp
I am gating a value like Abc,Def,Ghi,

Now I want to split the whole pass value by “,�
And fire one for loop to store value in database
This things is done in asp.net web form but I want to do all process in sp
So please guide me how I am write sp .
The purpose is pass value one time so connection time is decrees and give fast perforce

View Replies !

---

To Split Or Not To Split
I have a database with a "large" table containing date based information Basically they're reservations. I've thought about creating a new table and adding any records from past years to this table. For the most part only current reservation need to be searchable, but in some circumstances it would be useful to be able to search through the archive too. so, my questions!!!

Is 8,000 or so rows of data "large" and unwieldly in SQL terms?

Would splitting this data into 2 tables - one small table for current and future reservations and one larger archive table then using a UNION SELECT query to make archive information seachable be a significant improvment on server resources/load or am I making the whole thing more complicated than it need be as 8,000 rows of data is nothing to worry about.............

What did they say about a little bit of knowledge being a dangerous thing?

Thanks in advance of any guidance to a neophyte!!?

View Replies !

---

SPLIT() UDF
SQL UDF split()

The objective of this article is to help the SQL developers with an UDF that can be used within a stored procedures or Function to split a string (based on given delimiter) and extract the required portion of the string.

Scripting languages like VB script and Java script have in-built split() functions but there is no such function available in SQL server. In my experience this function is really handy when you’re working on an ASP application with SQL server as backend, whereby you’ll need to pass the ASP page submitted values to the SQL stored procedure.

To give a simple example, in a typical Monthly reporting ASP page – the users would select a range of months and extract the information pertaining to this date range. Classic implementation of this model is to have an ASP page to accept the input parameters and pass the values to the SQL stored procedure (SP). The SP would return a result set which is then formatted in the ASP page as results.

If the date range is continuous ie. JAN07 to MAR07 then the SP can typically accept a ‘From’ and ‘To’ range variables. But I’ve encountered situations whereby the users select 3 months from the current year and 2 months from previous year (non-continuous date ranges). In such scenario the SP cannot have a date range as input parameters.

Typically an ASP programmer would do is by having a single date input parameter in the SP and call the SP within a loop in the ASP page. This is an inefficient way of programming as contacting the database server within an ASP loop could cause performance overhead especially if the table being queried is an online transaction processing table.

Here is how I handled the above situation.

1.Declared one string input parameter of type varchar(8000) (if you’re using SQL 2005 then it is advisable to use Varchar(Max))
2.Pass the ASP submitted values as string, in this case the months selected by user would be supplied to the SP as a string
3.Within the Stored Procedure I’ll call the split() function to extract each month from the string and query the corresponding data

The basic structure of the stored procedure is as pasted below:-

CREATE PROCEDURE FETCH_SALES_DETAIL (
@MONTH VARCHAR(MAX)
)
AS
BEGIN
DECLARE @MONTH_CNT INT,@MTH DATETIME
SET @MONTH_CNT=1
WHILE DBO.SPLIT(@MONTH,',',@MONTH_CNT) <> ''
BEGIN
SET @MTH = CAST(DBO.SPLIT(@MONTH,',',@MONTH_CNT) AS DATETIME)
--<<Application specific T-SQLs>>-- (BEGIN)
SELECT [SALES_MONTH],[SALES_QTY],[PRODUCT_ID],[TRANSACTION_DATE]
FROM SALES (NLOCK)
WHERE [SALES_MONTH]= @MTH
--<<Application specific T-SQLs>>--(END)

SET @MONTH_CNT=@MONTH_CNT+1
END
END

Dbo.SPLIT() function takes 3 parameters
1)The main string with the values to be split
2)The delimiter
3)The Nth occurrence of the string to be returned

The functionality of the UDF is as explained STEP by STEP:

1.Function Declaration
CREATE FUNCTION [dbo].[SPLIT]
(
@nstring VARCHAR(MAX),
@deliminator nvarchar(10),
@index int
)

RETURNS VARCHAR(MAX)

Function is declared with 3 input parameters:-
@nstring of type VARCHAR(MAX) will hold the main string to be split
@deliminator of type NVARCHAR(10) will hold the delimiter
@index of type INT will hold the index of the string to be returned
2.Variable Declaration
DECLARE @position int
DECLARE @ustr VARCHAR(MAX)
DECLARE @pcnt int

Three variables are needed within the function. @position is an integer variable that will be used to traverse along the main string. @ustr will store the string to be returned and the @pcnt integer variable to check the index of the delimiter.
3.Variable initialization
SET @position = 1
SET @pcnt = 1
SELECT @ustr = ''
Initialize the variables
4.Main functionality
WHILE @position <= DATALENGTH(@nstring) and @pcnt <= @index
BEGIN
IF SUBSTRING(@nstring, @position, 1) <> @deliminator BEGIN
IF @pcnt = @index BEGIN
SET @ustr = @ustr + CAST(SUBSTRING(@nstring, @position, 1) AS nvarchar)
END
SET @position = @position + 1
END
ELSE BEGIN
SET @position = @position + 1
SET @pcnt = @pcnt + 1
END
END

4.1The main while loop is used to traverse through the main string until the word index is less than or equal to the index passed as input parameter.
4.2Within the while loop each character within the string is verified against the delimiter and if it does not match then local word count variable is checked against the input index parameter
4.3If the values are same ie., the input variable index and the word being processed in the while loop are the same then the word is stored in the @ustr variable. If the values does not match then the @position variable is incremented.
4.4If the character matches with the delimiter then the word count variable @pcnt is incremented along with the @position variable

5.Return the value
RETURN @ustr

I hope this article would benefit those who are looking for a handy function to deal with Strings.

Feel free to send your feedback at dearhari@gmail.com

View Replies !

---

A Connection Was Successfully Established With The Server, But Then An Error Occurred During The Login Process. (provider: Shared Memory Provider, Error: 0 - No Process Is On The Other End Of The Pipe.)
i'm going nuts with SQL server notification thing. I have gone throigh this artical which tells how to set user http://www.codeproject.com/KB/database/SqlDependencyPermissions.aspx. This article show how to create new user and setup for sql server notification.But In my case user was alredy existing in database. which is very common senario in most cases. So i did following( check the SQL script below) but then i get this error
"A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)"
this my sql script
use [master]Go
-- Ensuring that Service Broker is enabled ALTER DATABASE [DatabaseName] SET ENABLE_BROKERGO
-- Switching to our databaseuse [DatabaseName]GO
CREATE SCHEMA schemaname AUTHORIZATION usernameGO
ALTER USER username WITH DEFAULT_SCHEMA = schemaname GO
/* * Creating two new roles. We're not going to set the necessary permissions  * on the user-accounts, but we're going to set them on these two new roles. * At the end of this script, we're simply going to make our two users  * members of these roles. */EXEC sp_addrole 'sql_dependency_subscriber' EXEC sp_addrole 'sql_dependency_starter'
-- Permissions needed for [sql_dependency_starter]GRANT CREATE PROCEDURE to [sql_dependency_starter] GRANT CREATE QUEUE to [sql_dependency_starter]GRANT CREATE SERVICE to [sql_dependency_starter]GRANT REFERENCES on CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification]  to [sql_dependency_starter] GRANT VIEW DEFINITION TO [sql_dependency_starter]
-- Permissions needed for [sql_dependency_subscriber] GRANT SELECT to [sql_dependency_subscriber] GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [sql_dependency_subscriber] GRANT RECEIVE ON QueryNotificationErrorsQueue TO [sql_dependency_subscriber] GRANT REFERENCES on CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification]  to [sql_dependency_subscriber]
-- Making sure that my users are member of the correct role.EXEC sp_addrolemember 'sql_dependency_starter', 'username'EXEC sp_addrolemember 'sql_dependency_subscriber', 'username'

View Replies !

---

Adding String To Database, But Name Of String Is Added, Not Data
Hello, I am tring to add a string my database.  Info is added, but it is the name of the string, not the data contained within.  What am I doing wrong?  The text "Company" and "currentUserID" is showing up in my database, but I need the info contained within the string.  All help is appreciated!
 
 
Imports System.Data
Imports System.Data.Common
Imports System.Data.SqlClientPartial Class _DefaultInherits System.Web.UI.Page
 
Protected Sub CreateUserWizard1_CreatedUser(ByVal sender As Object, ByVal e As System.EventArgs) Handles CreateUserWizard1.CreatedUser
'Database ConnectionDim con As New SqlConnection("Data Source = .SQLExpress;integrated security=true;attachdbfilename=|DataDirectory|ASPNETDB.mdf;user instance=true")
'First Command DataDim Company As String = ((CType(CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Company"), TextBox)).Text)
Dim insertSQL1 As StringDim currentUserID As String = ((CType(CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("UserName"), TextBox)).Text)
insertSQL1 = "INSERT INTO Company (CompanyName, UserID) VALUES ('Company', 'currentUserID')"Dim cmd1 As New SqlCommand(insertSQL1, con)
'2nd Command Data
Dim selectSQL As String
selectSQL = "SELECT companyKey FROM Company WHERE UserID = 'currentUserID'"Dim cmd2 As New SqlCommand(selectSQL, con)
Dim reader As SqlDataReader
'3rd Command Data
Dim insertSQL2 As String
insertSQL2 = "INSERT INTO Company_Membership (CompanyKey, UserID) VALUES ('CompanyKey', 'currentUserID')"Dim cmd3 As New SqlCommand(insertSQL2, con)
'First CommandDim added As Integer = 0
Try
con.Open()
added = cmd1.ExecuteNonQuery()
lblResults.Text = added.ToString() & " records inserted."Catch err As Exception
lblResults.Text = "Error inserting record."
lblResults.Text &= err.Message
Finally
con.Close()
End Try
'2nd Command
Try
con.Open()
reader = cmd2.ExecuteReader()Do While reader.Read()
Dim CompanyKey = reader("CompanyKey").ToString()
Loop
reader.Close()Catch err As Exception
lbl1Results.Text = "Error selecting record."
lbl1Results.Text &= err.Message
Finally
con.Close()
End Try
'3rd Command
Try
con.Open()
added = cmd3.ExecuteNonQuery()
lbl2Results.Text = added.ToString() & " records inserted."Catch err As Exception
lbl2Results.Text = "Error inserting record."
lbl2Results.Text &= err.Message
Finally
con.Close()End Try
 
 
 End Sub
End Class

View Replies !

---

Help: About Ms Sql Query, How Can I Check If A Part String Exists In A String?
Hello to all,
I have a problem with ms sql query. I hope that somebody can help me. 
i have a table "Relationships". There are two Fields (IDMember und RelationshipIDs) in this table. IDMember is the Owner ID (type: integer) und RelationshipIDs saves all partners of this Owner ( type: varchar(1000)).  Example Datas for Table Relationships:                               IDMember     Relationships              .
                                                                                                                3387            (2345, 2388,4567,....)
                                                                                                                4567           (8990, 7865, 3387...)
i wirte a query to check if there is Relationship between two members.
Query: 
Declare @IDM int; Declare @IDO int; Set @IDM = 3387, @IDO = 4567;
select *
from Relationship where (IDMember = @IDM) and ( cast(@ID0 as char(100)) in
(select Relationship .[RelationshipIDs] from Relationship where IDMember = @IDM))
 
But I get nothing by this query.
Can Someone tell me where is the problem? Thanks
 
Best Regards
Pinsha

View Replies !

---