Forum Replies Created

Viewing 15 posts - 1,366 through 1,380 (of 8,731 total)

  • RE: Replace string

    This might be a slower method, but it will do exactly what you asked in your first post.

    SELECT *,
      ( SELECT CASE WHEN s.Item LIKE...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 19, 2017 at 11:38 am

    #1938896

  • RE: Replace string

    Would this work for you?
    SELECT *, CAST(CAST(String AS XML) AS VARCHAR(MAX))
    FROM (VALUES('Hello all!   How Are you ?:'))x(String)

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 19, 2017 at 11:26 am

    #1938893

  • RE: Are the posted questions getting worse?

    DesNorton - Wednesday, April 19, 2017 7:45 AM

    Brandie Tarvin - Wednesday, April 19, 2017 7:40 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 19, 2017 at 7:51 am

    #1938817

  • RE: Calling a function with input parameter problem :

    Zososql - Tuesday, April 18, 2017 11:04 PM

    Thanks for your insights and help Luis.Here's what i really want to do is group...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 19, 2017 at 7:04 am

    #1938793

  • RE: SQL help - Need to know the first date of previous month and last date of previous month...

    mw112009 - Tuesday, April 18, 2017 11:42 AM

    Wrong !  The crystal report that I am developing directly connects with C# code, gets...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 18, 2017 at 12:33 pm

    #1938643

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Tuesday, April 18, 2017 10:41 AM

    drew.allen - Tuesday, April 18, 2017 10:33 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 18, 2017 at 10:53 am

    #1938618

  • RE: ERROR using CharIndex : Invalid length parameter passed to the LEFT or SUBSTRING function in sql

    It seems like everyone is checking for the existence of the comma to get the portion of the string. I'd rather make sure that there's at least a comma in...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 18, 2017 at 10:13 am

    #1938594

  • RE: SQL help - Need to know the first date of previous month and last date of previous month...

    mw112009 - Tuesday, April 18, 2017 9:19 AM

    To All ( Bran,Luis,Jeff,Phil and anyone who comments ... ) 
    You guys are a great help....

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 18, 2017 at 9:32 am

    #1938557

  • RE: Getting more involved in the SQL Community - Advice wanted

    I can relate with your problems. I started as a developer and started to work exclusively with SQL Server. PASS local chapters can be a good place to meet...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 18, 2017 at 9:20 am

    #1938551

  • RE: Are the posted questions getting worse?

    Thom A - Tuesday, April 18, 2017 7:17 AM

    Brandie Tarvin - Tuesday, April 18, 2017 7:12 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 18, 2017 at 7:40 am

    #1938515

  • RE: SQL help - Need to know the first date of previous month and last date of previous month...

    mw112009 - Tuesday, April 18, 2017 6:43 AM

    Credit to DesNorton
    Jeff: The dates are used as default values in a SSRS report.  ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 18, 2017 at 7:15 am

    #1938506

  • RE: Calling a function with input parameter problem :

    Zososql - Monday, April 17, 2017 11:06 PM

    I have a stored procedure that takes customerids inside my Orders table and it sums...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 18, 2017 at 7:04 am

    #1938498

  • RE: User must change password at next login

    Thom A - Tuesday, April 18, 2017 3:13 AM

    You do also realise that the above SQL is only going to update 1...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 18, 2017 at 6:30 am

    #1938488

  • RE: Are the posted questions getting worse?

    JustMarie - Monday, April 17, 2017 9:44 AM

    Does anyone else think GeorgeCopeland was having a bad day? Or does he really not...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 17, 2017 at 10:54 am

    #1938340

  • RE: Today's Random Word!

    SQLRNNR - Friday, April 14, 2017 10:55 AM

    Maniac

    Pyromaniac

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2017 at 11:29 am

    #1938200

Viewing 15 posts - 1,366 through 1,380 (of 8,731 total)