Forum Replies Created

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

  • RE: t-sql 2012 sort

    wendy elizabeth - Wednesday, March 15, 2017 12:29 PM

    In a t-sql 2012 view, I would like to sort the data by mailAddress....

    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

    March 15, 2017 at 12:40 pm

    #1933331

  • RE: Remove all leading zeros from a column of data in SQL?

    chef423 - Wednesday, March 15, 2017 12:29 PM

    chef423 - Wednesday, March 15, 2017 12:12 PM

    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

    March 15, 2017 at 12:38 pm

    #1933329

  • RE: Are the posted questions getting worse?

    I was looking for a reference to reply on a thread and found this article: https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.html
    It had exactly what I was looking for and the style seemed familiar....

    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

    March 15, 2017 at 12:32 pm

    #1933327

  • RE: SELECT @local_variable '=' Versus SELECT @local_variable '+='

    amirmir - Wednesday, March 15, 2017 12:10 PM

    My question is, how is it adding the += returning all the 3 values instead...

    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

    March 15, 2017 at 12:28 pm

    #1933325

  • RE: SELECT @local_variable '=' Versus SELECT @local_variable '+='

    SELECT @var += SomeExpresion FROM SomeTable;
    is a shortcut to
    SELECT @var = @var +SomeExpresion FROM SomeTable;

    This is a common shortcut in many programming languages. I learned it...

    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

    March 15, 2017 at 12:17 pm

    #1933322

  • RE: Remove all leading zeros from a column of data in SQL?

    Here's an alternative version because it seems that your numbers are not digit-only.
    UPDATE Inventory
    SET ItemNum = SUBSTRING(ItemNum, PATINDEX('%[^0]%',ItemNum), 4000)
    WHERE ItemNum like '0%'

    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

    March 15, 2017 at 12:10 pm

    #1933318

  • RE: Single quote for cross apply to use dynamic DBname

    Instead of using exec (@fullFiles), use: PRINT @fullFiles
    Then copy the code from the messages tab and find where you need to fix your quotes. You have some missing quotes...

    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

    March 15, 2017 at 6:04 am

    #1933215

  • RE: http://www.wecareskincare.com/renuglow/

    Reported as spam

    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

    March 15, 2017 at 5:55 am

    #1933212

  • RE: Logical OR comparison between two queries hangs

    mahrajmca - Tuesday, March 14, 2017 1:39 PM

    Chris Harshman - Tuesday, March 14, 2017 1:31 PM

    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

    March 14, 2017 at 1:46 pm

    #1933133

  • RE: 'Spell check' a string-valued field

    scarr030 - Tuesday, March 14, 2017 10:49 AM

    Hello all,

    We have a field in a table that's a string-valued field. In this field...

    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

    March 14, 2017 at 10:55 am

    #1933087

  • RE: Are the posted questions getting worse?

    Hugo Kornelis - Monday, March 13, 2017 6:27 PM

    Lynn Pettis - Monday, March 13, 2017 4:33 PM

    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

    March 14, 2017 at 10:49 am

    #1933082

  • RE: Are the posted questions getting worse?

    bmg002 - Tuesday, March 14, 2017 10:27 AM

    drew.allen - Tuesday, March 14, 2017 10:15 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

    March 14, 2017 at 10:44 am

    #1933077

  • RE: Are the posted questions getting worse?

    I'll be extremely happy the day that JC admits he's wrong in a forum post. Every time he's proven wrong, he just avoids the subject and posts more unrelated nonsense....

    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

    March 13, 2017 at 4:17 pm

    #1932972

  • RE: SSMS Issues with Intellisense and switching query windows

    I've seen the behavior and it's mostly a display refresh issue. I usually fix it by scrolling the query.
    Remember that even if you have a good computer, SSMS is...

    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

    March 13, 2017 at 4:11 pm

    #1932970

  • RE: Encapsulating complex logic without using a scalar UDF

    jcelko212 32090 - Monday, March 13, 2017 11:17 AM

    Jeff Moden - Saturday, March 11, 2017 8:42 PM

    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

    March 13, 2017 at 1:24 pm

    #1932949

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