Forum Replies Created

Viewing 15 posts - 466 through 480 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    jasona.work - Thursday, June 21, 2018 12:34 PM

    Lynn Pettis - Thursday, June 21, 2018 12:10 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 12:43 pm

    #1994898

  • RE: SUM(CASE(CASE(SUM()))) ?

    Why would you have a dbo.addmonths function when you have a native DATEADD function?

    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 11:35 am

    #1994886

  • RE: calculate dates

    komal145 - Thursday, June 21, 2018 11:02 AM

    I need to compare dates
    example declare @date date = '6/18/2018'

    I need to compare @date...

    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 11:08 am

    #1994873

  • RE: Conversion failed when converting the nvarchar value '/' to data type int.

    Here's an example with some possible scenarios:

    SELECT  SpecialCode,
      CAST(SUBSTRING(SpecialCode, 0, ISNULL( NULLIF(CHARINDEX('/', SpecialCode), 0), 10)) AS int)  AS Expr1,
      CAST(SUBSTRING(SpecialCode, ISNULL( NULLIF(CHARINDEX('/',...

    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 9:02 am

    #1994836

  • RE: Transpose a particular row to columns

    ralu_k_17 - Thursday, June 21, 2018 1:39 AM

    Assuming you have an identity on the input table, to identify the row (row_id) you...

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

    #1994825

  • RE: Get first date and last date of the current month base on Work Week

    James Bosco - Wednesday, June 20, 2018 2:56 PM

    I am sorry.  You are correct I could just do that.  What I was...

    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 20, 2018 at 7:45 pm

    #1994757

  • RE: Get first date and last date of the current month base on Work Week

    James Bosco - Wednesday, June 20, 2018 2:31 PM

    I have a tour calendar for June and a Tour date.

    So for the first...

    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 20, 2018 at 2:47 pm

    #1994735

  • RE: Query performance - where to start tuning the server??

    I would start by changing all those SELECT TOP 1. You're reading the tables multiple times when you can read them just once.

    Your WHERE clause is not SARGable...

    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 20, 2018 at 2:39 pm

    #1994734

  • RE: Get first date and last date of the current month base on Work Week

    James Bosco - Wednesday, June 20, 2018 2:11 PM

    Hello all,

    Thanks in advance for any assistance you can give me. 

    What I am trying...

    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 20, 2018 at 2:24 pm

    #1994730

  • RE: Are the posted questions getting worse?

    Am I missing something here?
    https://www.sqlservercentral.com/Forums/1969990/Advice-help-for-this-query

    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 20, 2018 at 2:19 pm

    #1994724

  • RE: Advice / help for this query

    celsoc23 - Wednesday, June 20, 2018 2:13 PM

    Luis Cazares - Wednesday, June 20, 2018 12:41 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 20, 2018 at 2:18 pm

    #1994723

  • RE: Advice / help for this query

    celsoc23 - Wednesday, June 20, 2018 12:01 PM

    Hi dudes!
    First these are my tables with some records:

    table: INDEX (all primary keys)

    longitude   latitude   ...

    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 20, 2018 at 12:41 pm

    #1994707

  • RE: Long running query

    ozzielozdan - Tuesday, June 19, 2018 9:55 AM

    The table SYN_STG_ODS_SAP_FI_GL4_DELTA_KEY contains 85,000 records it filters the query with only required records estimated...

    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 19, 2018 at 10:04 am

    #1994474

  • RE: Long running query

    Have you seen the estimated number of rows? How long would you expect it to take to process 20TB of data?
    You should start by filtering the data that you're...

    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 19, 2018 at 9:48 am

    #1994471

  • RE: Help needed really basic not SQL admin person with INNER JOIN function

    james.wilson 80895 - Tuesday, June 19, 2018 5:02 AM

    Hi
    I'm really hoping someone can help me as I'm underexperienced and struggling

    I have 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

    June 19, 2018 at 7:43 am

    #1994453

Viewing 15 posts - 466 through 480 (of 8,731 total)