Forum Replies Created

Viewing 15 posts - 451 through 465 (of 8,731 total)

  • RE: Odd results from WHERE in SQL

    jdasilva - Wednesday, June 27, 2018 7:37 AM


    Thanks for fighting with this with me.  I have learned a few better habits...

    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 7:57 am

    #1995450

  • RE: Optimization of sql server big query

    I agree on what has been said, but there might be something else that can be done. You have 3 updates. Formatting the first, it would look like this:

    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 7:32 am

    #1995444

  • RE: Are the posted questions getting worse?

    jasona.work - Wednesday, June 27, 2018 6:14 AM

    Jeff Moden - Tuesday, June 26, 2018 6:58 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 7:19 am

    #1995436

  • RE: SUM of 2 columns in 2 tables THIS IS REALLY SIMPLE

    maher_guida - Tuesday, June 26, 2018 12:25 PM

    how ican make 3 sum function in same select query from 3tables
    and there is  relation...

    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 26, 2018 at 12:50 pm

    #1995354

  • RE: HELP ME WITH THE WHERE CLAUSE ( Select records based on a variable value )

    Lynn Pettis - Tuesday, June 26, 2018 12:12 PM

    A simple catch all query will work

    SELECT *
    FROM @TAB AS [t]
    WHERE ([t].[INCLUDE_ME]...

    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 26, 2018 at 12:28 pm

    #1995348

  • RE: HELP ME WITH THE WHERE CLAUSE ( Select records based on a variable value )

    mw_sql_developer - Tuesday, June 26, 2018 11:54 AM

    mw_sql_developer - Tuesday, June 26, 2018 11:47 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 26, 2018 at 11:59 am

    #1995342

  • RE: HELP ME WITH THE WHERE CLAUSE ( Select records based on a variable value )

    Try building a table of truth with the possible options. Once you have it, the statement should be fairly easy to write.

    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 26, 2018 at 11:58 am

    #1995340

  • RE: Odd results from WHERE in SQL

    jdasilva - Tuesday, June 26, 2018 7:33 AM

    This script is built in VBA for use in access 2016.

    honestly, SQL is not 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

    June 26, 2018 at 8:43 am

    #1995304

  • RE: Odd results from WHERE in SQL

    jdasilva - Tuesday, June 26, 2018 6:53 AM

    So I have a bit of VBA put together to manage...

    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 26, 2018 at 7:23 am

    #1995282

  • RE: Find the difference between 2 values

    Lynn Pettis - Friday, June 22, 2018 4:14 PM

    jonathan.crawford - Friday, June 22, 2018 3:52 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 25, 2018 at 11:26 am

    #1995190

  • RE: The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error.

    gregory.davis2 - Monday, June 25, 2018 10:23 AM

    Select *
    From TableWithOffendingData
    Where Try Cast(yourDateTimeField as smalldatetime) is null

    Most likely you have a date this...

    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 25, 2018 at 10:29 am

    #1995181

  • RE: get required output in sql server

    srinudw88 - Friday, June 22, 2018 9:50 AM

    Hi ,I have one doubt in sql server .
    how to get required output based on...

    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 22, 2018 at 11:03 am

    #1994993

  • RE: Arithmetic

    Budd - Friday, June 22, 2018 6:58 AM

    So why is it that with all the Implicit conversions that SQL can do, something, that...

    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 22, 2018 at 8:58 am

    #1994982

  • RE: Transpose a particular row to columns

    ralu_k_17 - Friday, June 22, 2018 1:40 AM

    Luis Cazares - Thursday, June 21, 2018 7: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

    June 22, 2018 at 7:49 am

    #1994972

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Thursday, June 21, 2018 12:46 PM

    Luis Cazares - Thursday, June 21, 2018 12:43 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 21, 2018 at 1:14 pm

    #1994904

Viewing 15 posts - 451 through 465 (of 8,731 total)