Forum Replies Created

Viewing 15 posts - 3,721 through 3,735 (of 9,399 total)

  • RE: TRY_CONVERT large numbers

    A nice, simple question to start the day. Thanks.

  • RE: Are the posted questions getting worse?

    Alan.B (3/1/2016)


    jasona.work (3/1/2016)


    Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...

    Hmm, using DD makes it seem so far away, lets try WEEK...

    That's a little better...

    How...

  • RE: Is it a necessity to update SQL 2012 Server?

    I'm in the same boat as Grant. We'll do security patches once a quarter after testing them, but nothing gets installed until after it's been out for a while....

  • RE: Assign permissions to view all logins

    pehlebhiayatha (3/1/2016)


    Thanks for you reply.

    I tried below but it only show sa and he's login but not all logins in SQL Server.

    create procedure uspLogins

    as

    select name

    from sys.syslogins

    order by name asc

    go

    any...

  • RE: Today's Random Word!

    SQLRNNR (3/1/2016)


    omega

    End

  • RE: How to call a function with multiple parameters in a select statement

    Stix83 (3/1/2016)


    select statement:

    select a.Owner_Id,

    b.Name as KPI,

    B.Record_Type,

    B.Resource_Id,

    C.Display_Name,

    count(A.Owner_Id) as Max

    from amgr_appointments A

    right outer join AMGR_Resources B on A.Owner_Id = b.Resource_Id

    right outer JOIN ADMN_User_Details AS C ON A.Creator_Id=C.User_Id

    where b.Resource_Id in ('R25B2864CB6', 'R2691D72523', 'R25B2868972','R25B2868EE0','R39D1B39765',...

  • RE: Today's Random Word!

    crookj (3/1/2016)


    djj (3/1/2016)


    Ed Wagner (3/1/2016)


    whereisSQL? (3/1/2016)


    Revenant (3/1/2016)


    Ed Wagner (3/1/2016)


    HappyGeek (3/1/2016)


    Ed Wagner (3/1/2016)


    ZZartin (3/1/2016)


    Ed Wagner (3/1/2016)


    Ray K (3/1/2016)


    DonlSimpson (3/1/2016)


    ThomasRushton (3/1/2016)


    Ed Wagner (3/1/2016)


    Grumpy DBA (3/1/2016)


    Ed Wagner (3/1/2016)


    Campaign

    Champagne

    Toast

    Marmite

    Marmot

    Merlot

    Shiraz

    Shazzam

    Gomer

    Homer

    Doughnuts

    Fat

    Burn

    Fire

    House

    Cabin

    Woods

  • RE: Today's Random Word!

    whereisSQL? (3/1/2016)


    Revenant (3/1/2016)


    Ed Wagner (3/1/2016)


    HappyGeek (3/1/2016)


    Ed Wagner (3/1/2016)


    ZZartin (3/1/2016)


    Ed Wagner (3/1/2016)


    Ray K (3/1/2016)


    DonlSimpson (3/1/2016)


    ThomasRushton (3/1/2016)


    Ed Wagner (3/1/2016)


    Grumpy DBA (3/1/2016)


    Ed Wagner (3/1/2016)


    Campaign

    Champagne

    Toast

    Marmite

    Marmot

    Merlot

    Shiraz

    Shazzam

    Gomer

    Homer

    Doughnuts

    Fat

    Burn

    Fire

  • RE: Today's Random Word!

    HappyGeek (3/1/2016)


    Ed Wagner (3/1/2016)


    ZZartin (3/1/2016)


    Ed Wagner (3/1/2016)


    Ray K (3/1/2016)


    DonlSimpson (3/1/2016)


    ThomasRushton (3/1/2016)


    Ed Wagner (3/1/2016)


    Grumpy DBA (3/1/2016)


    Ed Wagner (3/1/2016)


    Campaign

    Champagne

    Toast

    Marmite

    Marmot

    Merlot

    Shiraz

    Shazzam

    Gomer

    Homer

    Doughnuts

  • RE: Today's Random Word!

    ZZartin (3/1/2016)


    Ed Wagner (3/1/2016)


    Ray K (3/1/2016)


    DonlSimpson (3/1/2016)


    ThomasRushton (3/1/2016)


    Ed Wagner (3/1/2016)


    Grumpy DBA (3/1/2016)


    Ed Wagner (3/1/2016)


    Campaign

    Champagne

    Toast

    Marmite

    Marmot

    Merlot

    Shiraz

    Shazzam

    Gomer

  • RE: Today's Random Word!

    Ray K (3/1/2016)


    DonlSimpson (3/1/2016)


    ThomasRushton (3/1/2016)


    Ed Wagner (3/1/2016)


    Grumpy DBA (3/1/2016)


    Ed Wagner (3/1/2016)


    Campaign

    Champagne

    Toast

    Marmite

    Marmot

    Merlot

    Shiraz

  • RE: Today's Random Word!

    Grumpy DBA (3/1/2016)


    Ed Wagner (3/1/2016)


    Campaign

    Champagne

    Toast

  • RE: The Term Extraction Transformation

    Even though I don't see any sign of ever using SSIS, it's always nice to learn something new to start the day. Thanks.

  • RE: Today's Random Word!

    ThomasRushton (3/1/2016)


    BL0B_EATER (3/1/2016)


    ThomasRushton (3/1/2016)


    Ed Wagner (2/29/2016)


    whereisSQL? (2/29/2016)


    Hugo Kornelis (2/29/2016)


    Ed Wagner (2/29/2016)


    whereisSQL? (2/29/2016)


    Ed Wagner (2/29/2016)


    Grumpy DBA (2/29/2016)


    Ray K (2/29/2016)


    crookj (2/29/2016)


    Revenant (2/29/2016)


    Overboard

    Overhead

    Over easy

    Sunnyside up

    Egg

    Chicken

    Fry

    Laurie

    Comic

    Humor

    spelling

    contest

    election

    Campaign

  • RE: Extracting time from datetime adds a second? Why?

    jimtimber (3/1/2016)


    (Do I have to mark this topic as solved? I have marked David's post as the solution)

    Even that's not absolutely necessary, but certainly appreciated. I'm glad you got...

Viewing 15 posts - 3,721 through 3,735 (of 9,399 total)