Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 1,493 total)

  • RE: create trigger on update and on insert

    You can use CREATE TRIGGER and MERGE.

    Where are you having problems with the CREATE TRIGGER?

    December 16, 2014 at 12:39 pm

    #1765010

  • RE: Select bottom 25%

    You need to provide more information. Do we assume you want to use the number? Do you want by group?

    What code have you tried? What output do...

    December 16, 2014 at 12:37 pm

    #1765009

  • RE: Today's Random Word!

    SQLRNNR (12/15/2014)

    Contortion

    Pain

    December 16, 2014 at 4:43 am

    #1764889

  • RE: Today's Random Word!

    Ed Wagner (12/15/2014)

    BWFC (12/15/2014)

    Letter

    Font

    Arial

    December 15, 2014 at 1:27 pm

    #1764791

  • RE: UPDATE table

    I would left join to [InternationalParts] and then have a where for the missing matches

    December 12, 2014 at 10:50 am

    #1764526

  • RE: Today's Random Word!

    Ed Wagner (12/12/2014)

    BWFC (12/12/2014)

    Ed Wagner (12/12/2014)

    crookj (12/12/2014)

    djj (12/12/2014)

    BWFC (12/12/2014)

    Ed Wagner (12/12/2014)

    SQLRNNR (12/12/2014)

    BWFC (12/12/2014)

    Ed Wagner (12/12/2014)

    richxs (12/12/2014)

    SQLRNNR (12/11/2014)

    Stuart Davies (12/11/2014)

    Ed Wagner (12/11/2014)

    Stuart Davies (12/11/2014)

    SQLRNNR (12/11/2014)

    curmudgeon

    Scrooge

    Humbug

    Mint

    Forge

    Steel

    Panther

    Pink

    Purple

    Deep

    Smoke

    Water

    Fire

    Sky

    Planets

    Pluto

    December 12, 2014 at 10:44 am

    #1764522

  • RE: Column 'Basic_Data.School_Year' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

    Might I suggest breaking you query down to start with a few columns to get the logic then add columns you need.

    I have even added columns a few at a...

    December 12, 2014 at 7:03 am

    #1764405

  • RE: Today's Random Word!

    BWFC (12/12/2014)

    Ed Wagner (12/12/2014)

    SQLRNNR (12/12/2014)

    BWFC (12/12/2014)

    Ed Wagner (12/12/2014)

    richxs (12/12/2014)

    SQLRNNR (12/11/2014)

    Stuart Davies (12/11/2014)

    Ed Wagner (12/11/2014)

    Stuart Davies (12/11/2014)

    SQLRNNR (12/11/2014)

    curmudgeon

    Scrooge

    Humbug

    Mint

    Forge

    Steel

    Panther

    Pink

    Purple

    Deep

    Smoke

    December 12, 2014 at 6:46 am

    #1764393

  • RE: Today's Random Word!

    Ed Wagner (12/10/2014)

    crookj (12/10/2014)

    Ed Wagner (12/10/2014)

    SQLRNNR (12/10/2014)

    dill

    Weed

    Colorado

    Skiing

    Skating

    December 11, 2014 at 10:33 am

    #1764155

  • RE: Digits only

    Thanks Eirikur. just one question, what does "& 0x7FFF" do? I realize that the & is for "bitwise and", however I am not very good at that.

    December 10, 2014 at 12:51 pm

    #1763880

  • RE: Digits only

    Thanks!

    I am looking to replace our current phone scrub with something a bit faster so I will make sure no NULLS.

    December 10, 2014 at 10:17 am

    #1763853

  • RE: Daily Count every nth hour

    SQL_path (12/10/2014)

    Hello Gurus,

    I need your help in calculating count and average daily every hour starting 4:30 evening

    4:30 - 5:30 -- Count

    5:30-6:30 -- Count and so...

    December 10, 2014 at 5:00 am

    #1763740

  • RE: Today's Random Word!

    crookj (12/9/2014)

    Ed Wagner (12/9/2014)

    sing4you (12/9/2014)

    Ed Wagner (12/9/2014)

    djj (12/9/2014)

    Ed Wagner (12/9/2014)

    SQLRNNR (12/9/2014)

    djj (12/9/2014)

    Ed Wagner (12/9/2014)

    crookj (12/9/2014)

    sing4you (12/9/2014)

    djj (12/9/2014)

    Holiday

    Billie

    Don't (be a hero....)

    Bonnie (Tyler)

    Clyde

    The Glide

    Slide

    Trombone

    Brass

    tacks

    High

    Anxiety

    Brooks (Mel)

    December 10, 2014 at 4:48 am

    #1763737

  • RE: Today's Random Word!

    Ed Wagner (12/9/2014)

    SQLRNNR (12/9/2014)

    djj (12/9/2014)

    Ed Wagner (12/9/2014)

    crookj (12/9/2014)

    sing4you (12/9/2014)

    djj (12/9/2014)

    Holiday

    Billie

    Don't (be a hero....)

    Bonnie (Tyler)

    Clyde

    The Glide

    Slide

    Trombone

    December 9, 2014 at 11:12 am

    #1763615

  • RE: Today's Random Word!

    Ed Wagner (12/9/2014)

    crookj (12/9/2014)

    sing4you (12/9/2014)

    djj (12/9/2014)

    Holiday

    Billie

    Don't (be a hero....)

    Bonnie (Tyler)

    Clyde

    December 9, 2014 at 7:53 am

    #1763530

Viewing 15 posts - 1,156 through 1,170 (of 1,493 total)