Forum Replies Created

Viewing 15 posts - 1,726 through 1,740 (of 6,395 total)

  • RE: select string between two ',' symbols

    Number of ways to do it

    create table #test(HID varchar (50))

    insert into #test values

    ('12,3,16'),

    ('16,10,256'),

    ('2,150,110,200'),

    ('5,70,4'),

    ('2,100,110,150,200,123,159602,1568')

    select

    hid,

    charindex(',',reverse(hid)) AS RightMostCommaPosition,

    left(hid,len(hid)-charindex(',',reverse(hid))) AS NewHID,

    charindex(',',reverse(left(hid,len(hid)-charindex(',',reverse(hid))))) AS NowRightMostCommaPosition,

    right(left(hid,len(hid)-charindex(',',reverse(hid))),charindex(',',reverse(left(hid,len(hid)-charindex(',',reverse(hid)))))-1) AS Result

    from #test

    ;with cte as

    (

    select * from #test

    cross...

    November 17, 2015 at 4:40 am

    #1840259

  • RE: select string between two ',' symbols

    Just in relation to this value

    '2,150,110,200'

    Why 110 and not 150,110?

    If you had '2,100,110,150,200,123,159602,1568'

    What would the correct answer be?

    November 17, 2015 at 4:14 am

    #1840253

  • RE: Sync Tables

    Sounds like merge replication may be the best option

    November 17, 2015 at 3:42 am

    #1840250

  • RE: Sync Tables

    How often does the tables need to be merged?

    November 17, 2015 at 3:23 am

    #1840245

  • RE: Services failed start in cluster

    Has the SSL certificate expired?

    Are you even using SSL to encrypt the connections to the server? If not remove it from Config Manager

    November 17, 2015 at 2:35 am

    #1840234

  • RE: Today's Random Word!

    Ed Wagner (11/16/2015)

    eccentricDBA (11/16/2015)

    crookj (11/16/2015)

    Ed Wagner (11/16/2015)

    ZZartin (11/16/2015)

    Luis Cazares (11/16/2015)

    DonlSimpson (11/16/2015)

    Ed Wagner (11/16/2015)

    anthony.green (11/16/2015)

    djj (11/16/2015)

    anthony.green (11/16/2015)

    Ed Wagner (11/16/2015)

    Sith

    Dark

    Chocolate

    Bean

    Coffee

    Java

    Jabba

    Slave

    Drive

    Zip

    tar

    Compression

    algorithm

    November 17, 2015 at 2:06 am

    #1840224

  • RE: How does SQL Server host communicate with Client - what ports on both machines?

    The client uses the RPC port range, so anything between TCP 1024 and 65535 to communicate to SQL on, its random as it depends what ports are already in use...

    November 17, 2015 at 2:00 am

    #1840221

  • RE: Today's Random Word!

    djj (11/16/2015)

    anthony.green (11/16/2015)

    Ed Wagner (11/16/2015)

    Sith

    Dark

    Chocolate

    Bean

    November 16, 2015 at 8:46 am

    #1839982

  • RE: Today's Random Word!

    Ed Wagner (11/16/2015)

    Sith

    Dark

    November 16, 2015 at 8:08 am

    #1839968

  • RE: Today's Random Word!

    Ed Wagner (11/16/2015)

    anthony.green (11/16/2015)

    Ed Wagner (11/16/2015)

    anthony.green (11/16/2015)

    crookj (11/13/2015)

    Ed Wagner (11/13/2015)

    anthony.green (11/13/2015)

    DonlSimpson (11/13/2015)

    anthony.green (11/13/2015)

    Ed Wagner (11/12/2015)

    DonlSimpson (11/12/2015)

    anthony.green (11/12/2015)

    Ed Wagner (11/12/2015)

    Bill

    Overbeck

    Sadler

    Sandler

    Pixels

    Pixies

    Debaser

    Acidity

    Tartness

    Pungency

    Strong

    The Force

    Jedi

    Light

    November 16, 2015 at 6:34 am

    #1839938

  • RE: Today's Random Word!

    Ed Wagner (11/16/2015)

    anthony.green (11/16/2015)

    crookj (11/13/2015)

    Ed Wagner (11/13/2015)

    anthony.green (11/13/2015)

    DonlSimpson (11/13/2015)

    anthony.green (11/13/2015)

    Ed Wagner (11/12/2015)

    DonlSimpson (11/12/2015)

    anthony.green (11/12/2015)

    Ed Wagner (11/12/2015)

    Bill

    Overbeck

    Sadler

    Sandler

    Pixels

    Pixies

    Debaser

    Acidity

    Tartness

    Pungency

    Strong

    The Force

    November 16, 2015 at 5:39 am

    #1839921

  • RE: Today's Random Word!

    crookj (11/13/2015)

    Ed Wagner (11/13/2015)

    anthony.green (11/13/2015)

    DonlSimpson (11/13/2015)

    anthony.green (11/13/2015)

    Ed Wagner (11/12/2015)

    DonlSimpson (11/12/2015)

    anthony.green (11/12/2015)

    Ed Wagner (11/12/2015)

    Bill

    Overbeck

    Sadler

    Sandler

    Pixels

    Pixies

    Debaser

    Acidity

    Tartness

    Pungency

    November 16, 2015 at 1:59 am

    #1839887

  • RE: Pasing 70-461

    Just practice practice practice with the T-SQL language.

    I would recommend the 70-461 official training guide

    Measure up test exams

    The following stairways

    http://www.sqlservercentral.com/stairway/119892/

    http://www.sqlservercentral.com/stairway/75773/

    http://www.sqlservercentral.com/stairway/104497/

    November 16, 2015 at 1:38 am

    #1839883

  • RE: SQL JOB Status history is showing failed

    Check the exit commands of the job steps.

    Is the last one's on success action, quit job reporting failure by any chance?

    November 16, 2015 at 1:29 am

    #1839882

  • RE: Today's Random Word!

    DonlSimpson (11/13/2015)

    anthony.green (11/13/2015)

    Ed Wagner (11/12/2015)

    DonlSimpson (11/12/2015)

    anthony.green (11/12/2015)

    Ed Wagner (11/12/2015)

    Bill

    Overbeck

    Sadler

    Sandler

    Pixels

    Pixies

    Debaser

    November 13, 2015 at 8:49 am

    #1839632

Viewing 15 posts - 1,726 through 1,740 (of 6,395 total)