Forum Replies Created

Viewing 15 posts - 436 through 450 (of 8,731 total)

  • RE: how to get the people i follow but they don't follow me back ???

    Have you tried using EXCEPT?

    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

    July 2, 2018 at 6:29 am

    #1995989

  • RE: How to use functions to update columns?

    Functions are meant to return values. Functions are NOT meant to make changes to a database.
    You might be trying to create a Stored Procedure. Understanding the difference between both...

    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

    July 2, 2018 at 6:27 am

    #1995987

  • RE: Phone Number Validation

    Sergiy - Saturday, June 30, 2018 6:25 AM

    There could not be a universal function for this purpose.Rules are different from country 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

    July 1, 2018 at 4:36 pm

    #1995948

  • RE: Phone Number Validation

    You could try to use the functions presented in the following article:
    http://www.sqlservercentral.com/scripts/String+Function/141686/

    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

    June 29, 2018 at 1:21 pm

    #1995877

  • RE: Azure Defaults

    Kaye Cahs - Friday, June 29, 2018 6:54 AM

    FRIDAY!
    No meetings and I answered the question right!
    Whooo!

    Show-off

    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

    June 29, 2018 at 12:10 pm

    #1995851

  • RE: Conditional join on multiple columns or huge CASE?

    Vegeta7 - Friday, June 29, 2018 10:56 AM

    Hi all,

    I'm trying to solve an exercise and can't seem to solve this without doing...

    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

    June 29, 2018 at 12:06 pm

    #1995850

  • RE: Standard Deviation in SSRS

    sheba.sql - Thursday, June 28, 2018 8:36 AM

    Hi,

    I am calculating to Standard deviation and i am using standard deviation function, i 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

    June 28, 2018 at 9:02 am

    #1995645

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, June 28, 2018 8:30 AM

    Luis Cazares - Thursday, June 28, 2018 8:09 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

    June 28, 2018 at 8:52 am

    #1995641

  • RE: Are the posted questions getting worse?

    Last night, something weird happened in my dream.
    I saw some advertisement for SQL consulting services charging $8USD per non-clustered index. I'm still trying to determine if the bad...

    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

    June 28, 2018 at 8:09 am

    #1995621

  • RE: Highlighting of changeable data using a "colour table"

    This might give you an idea on how to control the values a little bit more.

    WITH
    E(n) AS(
      SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)
    ),
    E2(n)...

    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

    June 28, 2018 at 7:29 am

    #1995616

  • RE: Optimization of sql server big query

    Phil Parkin - Wednesday, June 27, 2018 2:03 PM

    sgmunson - Wednesday, June 27, 2018 1:57 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

    June 27, 2018 at 2:13 pm

    #1995521

  • RE: How to update a value in WHERE clause for a bunch of SQL views

    What about creating a huge script with all the views' definitions and use replace functionality of the text/code editor (SSMS?) to change the values?
    This can also be done using...

    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

    June 27, 2018 at 2:07 pm

    #1995520

  • RE: How to update a value in WHERE clause for a bunch of SQL views

    What about adding a column to the table to add a flag. Then update the flag whenever needed and use that column in your views instead of the Term column.

    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

    June 27, 2018 at 1:33 pm

    #1995509

  • RE: Highlighting of changeable data using a "colour table"

    The main problem I can see is that there's no guarantee that you'll have humanly distinctive colors for each user.
    If you get #EE1010 and #EE1012, it would be really...

    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

    June 27, 2018 at 10:38 am

    #1995485

  • RE: Are the posted questions getting worse?

    Sean Lange - Wednesday, June 27, 2018 7:32 AM

    A thirsty one? LOL.

    I have never been to Twin Peaks but they serve...

    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

    June 27, 2018 at 8:00 am

    #1995451

Viewing 15 posts - 436 through 450 (of 8,731 total)