Forum Replies Created

Viewing 15 posts - 3,796 through 3,810 (of 8,731 total)

  • RE: Spell Check does not appear to work from Microsoft Edge

    Follow these steps to solve this issue:

    1. Open Edge

    2. In the address bar, type the following: http://chrome.google.com/

    3. Press Enter

    4. Click on Download

    5. Install

    6. Use a proper browser. 😀

    I'm sorry, I...

    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

    November 17, 2015 at 2:25 pm

    #1840490

  • RE: select string between two ',' symbols

    This is similar to the option previously posted by Anthony using the DelimitedSplit8k.

    WITH CTE AS

    (

    SELECT *, MAX(ItemNumber) OVER(PARTITION BY hid) - 1 AS thisItem

    FROM #test

    CROSS APPLY dbo.DelimitedSplit8K (hid,',')

    )

    SELECT Item

    FROM...

    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

    November 17, 2015 at 2:07 pm

    #1840482

  • RE: grouping time periods with gaps

    Just if anyone wants an example that is not as complex as the one from Drew (that problem required a more complex solution than this one).

    WITH CTE AS(

    ...

    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

    November 17, 2015 at 1:26 pm

    #1840478

  • RE: summing alpha columns

    If you were working on a 2012+ version, you could use try_parse, try_convert or try_cast.

    Otherwise, you need to do it manually.

    SELECT *

    FROM tbl

    WHERE CASE WHEN Column1 NOT LIKE...

    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

    November 17, 2015 at 1:14 pm

    #1840475

  • RE: JOIN in date range slow

    RVO (11/17/2015)

    Luis,

    So what is the solution

    for

    The estimated row counts are way off

    UPDATE STATISTICS ?

    That should correct that issue, unless is code related. You still have to work on 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

    November 17, 2015 at 12:01 pm

    #1840459

  • RE: JOIN in date range slow

    kaj (11/17/2015)

    You have a few places in your query where you apparently need trimming on join fields:

    UPPER(LTRIM(RTRIM(FIS2_Account_Shared.TD_LEGAL_ENTITY))) = UPPER(LTRIM(RTRIM(FIS2_Acct_Lgl_Ent.MNEMONIC)))

    OR UPPER(LTRIM(RTRIM(FIS2_Account_Shared.TD_LEGAL_ENTITY))) = UPPER('TD SECURITIES CANADA')

    In my limited experience...

    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

    November 17, 2015 at 11:53 am

    #1840457

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/17/2015)

    Sean Lange (11/17/2015)

    Luis Cazares (11/17/2015)

    Lynn Pettis (11/17/2015)

    OMG

    Step 1: Prepare 3 envelopes. :hehe:

    ROFL.

    I thought step 3 was to prepare 3 envelopes.

    It's too late for that. Unless someone wants 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

    November 17, 2015 at 11:47 am

    #1840455

  • RE: JOIN in date range slow

    RVO (11/17/2015)

    Luis,

    So what should I do about

    ". . . The estimated row counts are way off, but I'm not sure if they're like that from the non-equi joins.."

    If 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

    November 17, 2015 at 11:43 am

    #1840453

  • RE: JOIN in date range slow

    RVO (11/17/2015)

    Hello Luis,

    "....No, I'm just saying that if it's a cross join, you should write it as such..."

    Do you mean you would lie to see

    SELECT .....

    FROM

    a

    CROSS JOIN

    b

    style ?

    Yes, it's...

    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

    November 17, 2015 at 10:38 am

    #1840429

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/17/2015)

    OMG

    Step 1: Prepare 3 envelopes. :hehe:

    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

    November 17, 2015 at 10:23 am

    #1840412

  • RE: t-sql 2012 passing lot of values in a parameter

    SoHelpMeCodd (11/17/2015)

    Passing a delimited string certainly works. But I am currently working an issue where one sproc uses STUFF FOR XML to create a delimited string. A second sproc accepts...

    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

    November 17, 2015 at 6:58 am

    #1840312

  • RE: Are the posted questions getting worse?

    ChrisM@Work (11/17/2015)

    From some time yesterday through to the present I've been noticing something a little odd. In the workplace, on the commute home last night (the walk, the tube, the...

    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

    November 17, 2015 at 4:15 am

    #1840254

  • RE: Using Lile and OR in a WHERE clause

    Phil Parkin (11/16/2015)

    There was a problem with your final LIKE. '%%' does not mean anything more than '%', which in turn means anything or nothing.

    Anything or nothing that is not...

    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

    November 16, 2015 at 1:33 pm

    #1840126

  • RE: Shrinking Database

    Empty space in data files won't hurt performance, unless the disk is full and that prevents OS operations. Growing a file is expensive, so you must plan to leave free...

    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

    November 16, 2015 at 1:28 pm

    #1840124

  • RE: Using Lile and OR in a WHERE clause

    If I understand correctly, you want something like this:

    SELECT DISTINCT ProjectName AS Project

    FROM Timesheet

    WHERE (@ProjectType = 'P25, R&D' AND (ProjectName LIKE '2%' OR

    ...

    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

    November 16, 2015 at 1:22 pm

    #1840118

Viewing 15 posts - 3,796 through 3,810 (of 8,731 total)