Forum Replies Created

Viewing 15 posts - 901 through 915 (of 8,731 total)

  • RE: Help in finding events in two-week period

    dhanekulakalyan - Tuesday, October 17, 2017 10:04 AM

    Hello everyone,

    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

    October 17, 2017 at 11:28 am

    #1964076

  • RE: Delete syntax not working

    komal145 - Monday, October 16, 2017 11:34 AM

    Luis Cazares - Monday, October 16, 2017 10:56 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

    October 16, 2017 at 11:37 am

    #1963904

  • RE: Using a case statement to determine join

    If the column division is not nullable, the following code might be what you need. If it's nullable, you would want to add a third condition in the parenthesis.

    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

    October 16, 2017 at 11:19 am

    #1963899

  • RE: Delete syntax not working

    komal145 - Monday, October 16, 2017 10:11 AM

    hi,
    Here is the delete syntax but it is not working even though all the conditions...

    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

    October 16, 2017 at 10:56 am

    #1963887

  • RE: Are the posted questions getting worse?

    Thom A - Monday, October 16, 2017 8:58 AM

    Sky is a really odd colour here. The hurricane over Ireland and The North...

    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

    October 16, 2017 at 10:00 am

    #1963870

  • RE: Are the posted questions getting worse?

    I'm all set to start my birthday weekend in New Orleans. Any recommendations for things I shouldn't miss? Taking into account that I'm with my wife, mother-in-law and probably my...

    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

    October 13, 2017 at 1:57 pm

    #1963643

  • RE: Can't zero pad a variable

    Avi1 - Friday, October 13, 2017 12:40 PM

    I tested the scripts in one of dev box in SQL2016. the results are below....

    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

    October 13, 2017 at 1:53 pm

    #1963641

  • RE: TSQL help on strings

    Actually, I think that the solution is something as the one presented here:
    http://www.sqlservercentral.com/articles/T-SQL/68378/

    Be sure to follow the links for the optimal solutions.

    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

    October 13, 2017 at 1:49 pm

    #1963640

  • RE: Syntax error near else expression

    river1 - Friday, October 13, 2017 2:52 AM

    Hello,

    Can you please help me understand...

    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

    October 13, 2017 at 9:08 am

    #1963574

  • RE: Scalar function syntax error

    saintor1 - Thursday, October 12, 2017 1:07 PM

    I guess that I did something that should be a no-no... lol!    I remember...

    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

    October 12, 2017 at 1:29 pm

    #1963464

  • RE: Scalar function syntax error

    saintor1 - Thursday, October 12, 2017 9:01 AM

    Thom A - Thursday, October 12, 2017 8:43 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

    October 12, 2017 at 9:15 am

    #1963400

  • RE: Scalar function syntax error

    I see what the error is, but I'm not sure what you want to do. Both functions seem unrelated, so having the same structure is illogical.
    Also, check the following...

    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

    October 12, 2017 at 8:41 am

    #1963382

  • RE: Can't zero pad a variable

    Jeff Moden - Wednesday, October 11, 2017 8:10 PM

    Phil Parkin - Wednesday, October 11, 2017 2:25 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

    October 12, 2017 at 8:11 am

    #1963371

  • RE: Having trouble displaying a date in a certain format...

    chef423 - Wednesday, October 11, 2017 1:50 PM

    Phil Parkin - Wednesday, October 11, 2017 1:25 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

    October 11, 2017 at 2:08 pm

    #1963261

  • RE: Order of Indexed columns - does it matter

    GBeezy - Wednesday, October 11, 2017 11:08 AM

    Thanks Luis!

    All three of the queries I provided Perform an Index Seek on the non...

    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

    October 11, 2017 at 11:39 am

    #1963237

Viewing 15 posts - 901 through 915 (of 8,731 total)