Forum Replies Created

Viewing 15 posts - 2,896 through 2,910 (of 8,731 total)

  • RE: Split single column into multiple sql

    Nallya (5/5/2016)

    Hello,

    i have one column having data like

    777777777777777777 0 ...

    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

    May 5, 2016 at 6:29 am

    #1876805

  • RE: Why STUFF

    Raghavendra Mudugal (5/4/2016)

    (EP)Z!!!

    No need of STUFF. (very old code)

    No need for cursors, or several statements.

    WITH CTE AS(

    select distinct personid from @t

    )

    SELECT PersonID,

    phone...

    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

    May 4, 2016 at 1:01 pm

    #1876708

  • RE: Why STUFF

    edwardwill (5/4/2016)

    I'd no more ask this person to administer my database than I'd ask Donald Trump to run my country.

    What about asking Donald Trump to administer your database? https://twitter.com/trumpdba

    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

    May 4, 2016 at 9:51 am

    #1876651

  • RE: Any experiences with AirBnB?

    I forgot to include the http in the link address, I've corrected it now.

    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

    May 4, 2016 at 8:45 am

    #1876618

  • RE: Any experiences with AirBnB?

    I had a good experience using AirBnB when I had to look a place before finding an apartment.

    My mom rents a bedroom and she recently traveled through Europe using AirBnB.

    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

    May 4, 2016 at 8:31 am

    #1876607

  • RE: How to show CAPS lock status in Management Studio status bar?

    You could ask directly to Ken Van Hyning, who is the SQL Client Tools Engineering Manager at Microsoft.

    P.S. We're everywhere and we see it all. 😀

    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

    May 4, 2016 at 7:41 am

    #1876581

  • RE: Trying to write a query which fetches total net for sales order that are having same sales order as bevergaes

    shivang.rdesai (5/3/2016)

    What syntax error?

    I ran the query and it executes !

    You have an inconsistent number of parenthesis (difference between opening and closing).

    You're using Sales instead of FactSales (or the other...

    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

    May 4, 2016 at 6:51 am

    #1876566

  • RE: Trying to write a query which fetches total net for sales order that are having same sales order as bevergaes

    And what's the problem?

    That's what you asked for.

    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

    May 3, 2016 at 6:16 pm

    #1876465

  • RE: Potential presentation idea: Knowing your limits: are you in over your head?

    Ray K (5/3/2016)

    Eirikur Eiriksson (5/3/2016)

    Alan.B (5/3/2016)

    Eirikur Eiriksson (5/3/2016)

    Alan.B (5/3/2016)

    I think this is a common problem in the data world for sure.

    It all comes down to self-awareness and communication. Knowing...

    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

    May 3, 2016 at 2:09 pm

    #1876428

  • RE: Script to calculate Fiscal Year from Date

    Like this?

    SELECT CASE WHEN RIGHT(CONVERT(char(8), GETDATE(), 112), 4) < '0901'

    THEN YEAR(GETDATE()) - 1

    ...

    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

    May 3, 2016 at 1:42 pm

    #1876419

  • RE: Today's Random Word!

    Ray K (5/3/2016)

    Revenant (5/3/2016)

    Ed Wagner (5/3/2016)

    Manic Star (5/3/2016)

    Ed Wagner (5/3/2016)

    Eric M Russell (5/3/2016)

    Ed Wagner (5/3/2016)

    Eric M Russell (5/3/2016)

    Ed Wagner (5/3/2016)

    ThomasRushton (5/3/2016)

    mjagadeeswari (5/3/2016)

    Ray K (5/2/2016)

    Ed Wagner (5/2/2016)

    DonlSimpson (5/2/2016)

    IOS

    Unix

    Linux

    OS

    Two

    Fish

    Red Fish Blue Fish

    Thing...

    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

    May 3, 2016 at 1:04 pm

    #1876407

  • RE: Index

    Here are two options, but there are more available.

    https://ola.hallengren.com/

    http://www.midnightsql.com/minion/minion-reindex/

    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

    May 3, 2016 at 12:23 pm

    #1876383

  • RE: Alternating weekly schedule

    Lowell beat me to the suggestion.

    CREATE PROCEDURE Choose_Weekly_SP

    AS

    IF( SELECT DATEDIFF(wk, date_created, GETDATE()) % 2

    FROM msdb.dbo.sysjobs

    WHERE name = 'YourJob'

    )...

    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

    May 3, 2016 at 12:21 pm

    #1876382

  • RE: Are the posted questions getting worse?

    Ed Wagner (5/3/2016)

    Lynn Pettis (5/3/2016)

    Lynn Pettis (5/3/2016)

    Some people should not be allowed any where near a database server.

    +1000

    I guess I'll agree with your agreement with yourself. 😛

    Is this about 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

    May 3, 2016 at 10:29 am

    #1876334

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/3/2016)

    Some people should not be allowed any where near a database server.

    But, but...that's my job. :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

    May 3, 2016 at 10:23 am

    #1876327

Viewing 15 posts - 2,896 through 2,910 (of 8,731 total)