Forum Replies Created

Viewing 15 posts - 4,471 through 4,485 (of 8,731 total)

  • RE: Today's Random Word!

    Revenant (8/7/2015)

    whereisSQL? (8/7/2015)

    SQLRNNR (8/7/2015)

    Bonasera

    Corleone

    Boss

    Hugo

    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

    August 7, 2015 at 12:08 pm

    #1818238

  • RE: Split column value after every 50 characrters without splitting words

    I missed a NULLIF function. If you can solve it, then you should be good to go.

    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

    August 7, 2015 at 11:40 am

    #1818228

  • RE: Split column value after every 50 characrters without splitting words

    You're welcome, just remember to fully understand the code.

    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

    August 7, 2015 at 10:17 am

    #1818200

  • RE: Split column value after every 50 characrters without splitting words

    I might have overcomplicated the query, I probably need some rest. 😀

    DECLARE @MaxLength int = 50,

    @String varchar(max) = '***DUST MASK MUST BE WORN***

    ENSURE THE PRODUCT CODE...

    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

    August 7, 2015 at 10:02 am

    #1818186

  • RE: SQL Profiler with any express edition

    S_Kumar_S (8/7/2015)

    really?? I already tried installing 2012 express from this file :ENU\x64\SQLEXPRADV_x64_ENU.exe( mine is 64 bit). This was the biggest file with 1.3 GB size. So I though it will...

    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

    August 7, 2015 at 8:46 am

    #1818146

  • RE: SQL Profiler with any express edition

    I have profiler and I only installed SQL Server 2012 Express with tools

    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

    August 7, 2015 at 8:04 am

    #1818110

  • RE: Finding the first credit balance date

    ArcticEd32 (8/6/2015)

    Thank you again for the assistance and for the information regarding the triangular join. Only took me a week to read Jeff's post, the re-post, and the discussions...

    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

    August 7, 2015 at 6:55 am

    #1818075

  • RE: Split column value after every 50 characrters without splitting words

    Why are you trying to change this when you could store the whole text without problems?

    It can be done, but it requires some validation and careful code and testing to...

    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

    August 7, 2015 at 6:45 am

    #1818069

  • RE: Issue with output parameter in stored procedure

    nadersam (8/6/2015)

    Hi Luis,

    Thanks again for your replies.

    Please find attached file containing the needed scripts.

    Best Regards

    Nader Galal

    No file attached.

    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

    August 6, 2015 at 6:29 pm

    #1818006

  • RE: Best design for OLTP tables

    Thank you for your time, have a great holiday.

    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

    August 6, 2015 at 1:51 pm

    #1817973

  • RE: retrieve column from nested query

    This is untested, but it might work. What you asked is included as a CROSS APPLY. I also changed a part of your query to prevent multiple reads to BVFindings.

    WITH...

    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

    August 6, 2015 at 1:21 pm

    #1817965

  • RE: Today's Random Word!

    Ed Wagner (8/6/2015)

    Eirikur Eiriksson (8/6/2015)

    whereisSQL? (8/6/2015)

    eccentricDBA (8/6/2015)

    Revenant (8/6/2015)

    Ed Wagner (8/6/2015)

    SQLRNNR (8/6/2015)

    undo

    Rollback

    happens

    TARDIS

    Dr Who

    sp_who2

    Whoville

    Horton

    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

    August 6, 2015 at 12:42 pm

    #1817957

  • RE: too many indexes - question

    Check this, it should cover the all.

    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

    August 6, 2015 at 12:40 pm

    #1817956

  • RE: is the "go" keyword necessary in a sproc?

    GO is not a keyword. GO is a batch separator. You can actually define a different word instead of using GO as this is a setting for SSMS (aka, the...

    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

    August 6, 2015 at 12:35 pm

    #1817953

  • RE: Replace multiple occurances of same character with a single character

    This reminded me of an article that explains the method used here. However, the discussion of the article showed a faster option. This is the article: http://www.sqlservercentral.com/articles/T-SQL/68378/

    And this is an...

    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

    August 6, 2015 at 10:00 am

    #1817917

Viewing 15 posts - 4,471 through 4,485 (of 8,731 total)