Forum Replies Created

Viewing 15 posts - 1,921 through 1,935 (of 8,731 total)

  • RE: Help needed in recursive split

    Here's an option:

    Declare @UserGroup nvarchar(MAX);

    SET @UserGroup = 'UserGroup1|User1|User2|User3&UserGroup2|user4|user5|user6&Usergroup3|user7|user8|user9';

    selecT uc.UserGroup, us.Item

    FROM dbo.DelimitedSplit8K(@UserGroup,'&') gs

    CROSS APPLY (SELECT LEFT( gs.Item, CHARINDEX( '|', gs.Item + '|') - 1) AS UserGroup,

    ...

    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 4, 2016 at 11:07 am

    #1910667

  • RE: Today's Random Word!

    Ed Wagner (11/4/2016)

    djj (11/4/2016)

    Hugo Kornelis (11/4/2016)

    Stuart Davies (11/4/2016)

    Ed Wagner (11/3/2016)

    Luis Cazares (11/3/2016)

    Ed Wagner (11/3/2016)

    Manic Star (11/3/2016)

    crookj (11/3/2016)

    Ed Wagner (11/3/2016)

    djj (11/3/2016)

    Ray K (11/3/2016)

    crookj (11/3/2016)

    djj (11/3/2016)

    Ed Wagner (11/3/2016)

    djj (11/3/2016)

    Stuart Davies (11/3/2016)

    Family

    Time

    Warp

    Again

    deja vu

    repeat

    repeat

    Loop...

    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 4, 2016 at 10:44 am

    #1910656

  • RE: Importing Multiple .csv files into one database from network shared drive

    If you don't have the tables, you could use the import/export wizard. It will create the tables. Just be aware that the data types might not be the best choice.

    I'm...

    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 4, 2016 at 10:33 am

    #1910652

  • RE: sorting of a columns

    Use ORDER BY and CASE.

    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 4, 2016 at 10:24 am

    #1910647

  • RE: Recuperantion des données pour certains dimensions

    Jeff Moden (11/3/2016)

    Luis Cazares (11/3/2016)

    I believe that you understood correctly, except for the part that the OP needs to get the MDX query instead of T-SQL.

    I know it's possible but...

    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 4, 2016 at 9:55 am

    #1910644

  • RE: Query to find indexes that are larger than 900 bytes

    GilaMonster (11/4/2016)

    Luis Cazares (11/4/2016)

    It seems correct, the only issue would be with xml columns, but I'm sure those would be handled differently.

    Not a concern here, since XML columns, like 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 4, 2016 at 9:02 am

    #1910624

  • RE: Query to find indexes that are larger than 900 bytes

    It seems correct, the only issue would be with xml columns, but I'm sure those would be handled differently.

    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 4, 2016 at 7:29 am

    #1910586

  • RE: Today's Random Word!

    Ed Wagner (11/3/2016)

    Manic Star (11/3/2016)

    crookj (11/3/2016)

    Ed Wagner (11/3/2016)

    djj (11/3/2016)

    Ray K (11/3/2016)

    crookj (11/3/2016)

    djj (11/3/2016)

    Ed Wagner (11/3/2016)

    djj (11/3/2016)

    Stuart Davies (11/3/2016)

    Family

    Time

    Warp

    Again

    deja vu

    repeat

    repeat

    Loop :w00t:

    de loop...

    recursion

    Infinite

    stupidity

    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 3, 2016 at 1:58 pm

    #1910468

  • RE: Recuperantion des données pour certains dimensions

    doug.brown (11/3/2016)

    (Sorry, response in English) If I understand the Google translate correctly, you'll need to add something to your query to also include the sales from a year ago. ...

    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 3, 2016 at 1:16 pm

    #1910459

  • RE: Counting field values per day between specific date ranges

    That's because you're not taking the hours into account. The difference comes from 2 quotes that you're not including (973 & 1057). Check them and decide if they belong 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 3, 2016 at 10:30 am

    #1910403

  • RE: Server Hardware or Coffee?

    Sean Redmond (11/3/2016)

    I had never thought so much that hardware was expensive, rather more that software licences and people were expensive. Microsoft play an expensive game.

    In my experience, coding well...

    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 3, 2016 at 7:01 am

    #1910336

  • RE: Help on Hierarchy Query

    Why do you even need a derived table?

    SELECT

    meetingID,

    ProviderName,

    SubGroupName,

    SessionName,

    Attendee =...

    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 2, 2016 at 1:16 pm

    #1910217

  • RE: Are the posted questions getting worse?

    I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.

    That said, can anyone explain 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 2, 2016 at 11:29 am

    #1910187

  • RE: Today's Random Word!

    Kaye Cahs (11/2/2016)

    crookj (11/2/2016)

    Ed Wagner (11/2/2016)

    ZZartin (11/1/2016)

    Manic Star (11/1/2016)

    Luis Cazares (11/1/2016)

    jasona.work (11/1/2016)

    Ed Wagner (11/1/2016)

    Luis Cazares (11/1/2016)

    crookj (11/1/2016)

    djj (11/1/2016)

    Revenant (11/1/2016)

    Ed Wagner (11/1/2016)

    Alan.B (11/1/2016)

    djj (11/1/2016)

    Luis Cazares (11/1/2016)

    Ray K (11/1/2016)

    Resistance

    Rebellion

    Jedi

    academy

    Apprentice

    Sorcerer

    Wizard

    prestidigitator

    Magician

    Illusion

    Mysterio

    Rey

    Manta

    Bat

    Mammoth Cave

    Carlsbad Caverns

    C. Carl...

    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 2, 2016 at 8:59 am

    #1910142

  • RE: Sql query help

    KGJ-Dev (11/2/2016)

    Hi,

    yes, it doesn't match the order. is there any way to avoid the pivoting here.

    If there are only 2 values, you could use MAX and MIN with a validation...

    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 2, 2016 at 8:56 am

    #1910139

Viewing 15 posts - 1,921 through 1,935 (of 8,731 total)