Forum Replies Created

Viewing 15 posts - 571 through 585 (of 1,493 total)

  • RE: Today's Random Word!

    Ed Wagner (2/24/2016)

    crookj (2/24/2016)

    Grumpy DBA (2/24/2016)

    djj (2/24/2016)

    Ed Wagner (2/24/2016)

    ThomasRushton (2/24/2016)

    Stuart Davies (2/24/2016)

    HappyGeek (2/23/2016)

    Zero

    Chance

    Card

    Poker

    Run (done on motorcycles)

    Walk

    (the) Dog

    Pet

    Cemetery

    February 24, 2016 at 7:17 am

    #1860708

  • RE: Today's Random Word!

    Ed Wagner (2/24/2016)

    ThomasRushton (2/24/2016)

    Stuart Davies (2/24/2016)

    HappyGeek (2/23/2016)

    Zero

    Chance

    Card

    Poker

    Run (done on motorcycles)

    February 24, 2016 at 6:09 am

    #1860684

  • RE: Today's Random Word!

    Revenant (2/23/2016)

    HappyGeek (2/23/2016)

    crookj (2/23/2016)

    Ray K (2/23/2016)

    Ed Wagner (2/23/2016)

    djj (2/23/2016)

    Ed Wagner (2/23/2016)

    crookj (2/23/2016)

    BWFC (2/23/2016)

    Ed Wagner (2/23/2016)

    Ed Wagner (2/22/2016)

    DonlSimpson (2/22/2016)

    ZZartin (2/22/2016)

    Grumpy DBA (2/22/2016)

    djj (2/22/2016)

    Fixes

    Neutered

    Schnauzer

    Terrier

    Bichon

    Greyhound

    Bus

    Wheels

    Brakes

    Fluid

    Transmission

    Manual

    owners

    Expense....

    Account

    Taxes

    February 23, 2016 at 12:05 pm

    #1860524

  • RE: Query Help

    Your problem is you are getting students in either not both

    Here is my try (this incorrect but might give you an idea):

    WITH cte1 AS (

    select distinct

    r.ID,...

    February 23, 2016 at 8:31 am

    #1860432

  • RE: Today's Random Word!

    Ed Wagner (2/23/2016)

    crookj (2/23/2016)

    BWFC (2/23/2016)

    Ed Wagner (2/23/2016)

    Ed Wagner (2/22/2016)

    DonlSimpson (2/22/2016)

    ZZartin (2/22/2016)

    Grumpy DBA (2/22/2016)

    djj (2/22/2016)

    Fixes

    Neutered

    Schnauzer

    Terrier

    Bichon

    Greyhound

    Bus

    Wheels

    Brakes

    Fluid

    February 23, 2016 at 7:50 am

    #1860407

  • RE: Are the posted questions getting worse?

    Jeff Moden (2/22/2016)

    Like I said, no need to pile on. Just be silently amazed that people like this feel slighted if you don't offer them a job as a...

    February 23, 2016 at 5:36 am

    #1860358

  • RE: updating dates from a mm/dd/yy to yyyy-mm-dd 00:00:00.000 format

    briancampbellmcad (2/22/2016)

    Something like this?:

    INSERT INTO [CPCE_DB].[dbo].[Orders].[OrderDateAlt]

    SELECT Cast[AdminDateID] AS Datetime

    FROM [CPCE_DB].[dbo].[Orders]

    Take a look at this:

    ALTER TABLE [CPCE_DB].[dbo].[Orders] ADD [OrderDateAlt] (DATETIME);

    UPDATE TABLE [CPCE_DB].[dbo].[Orders]

    SET [OrderDateAlt] = CAST([AdminDateID] AS Datetime);

    February 22, 2016 at 1:10 pm

    #1860187

  • RE: updating dates from a mm/dd/yy to yyyy-mm-dd 00:00:00.000 format

    briancampbellmcad (2/22/2016)

    Thanks in advance for any help here... I have some dates I've moved from Access into SQL Server and I need to update all of them from a updating...

    February 22, 2016 at 12:00 pm

    #1860175

  • RE: Today's Random Word!

    Ed Wagner (2/22/2016)

    djj (2/22/2016)

    Luis Cazares (2/22/2016)

    Ed Wagner (2/22/2016)

    Grumpy DBA (2/22/2016)

    djj (2/22/2016)

    Ed Wagner (2/21/2016)

    Orlando Colamatteo (2/20/2016)

    TomThomson (2/20/2016)

    Ed Wagner (2/19/2016)

    TomThomson (2/19/2016)

    ZZartin (2/19/2016)

    Driver

    road hog

    Harley

    Davidson

    Curry

    Spice

    Girls (sorry)

    Tellmewhatchawant (sorry)

    Requirements

    Sweet dreams

    Nightmares

    Breakdown

    Fixes

    February 22, 2016 at 11:29 am

    #1860166

  • RE: Today's Random Word!

    Luis Cazares (2/22/2016)

    Ed Wagner (2/22/2016)

    Grumpy DBA (2/22/2016)

    djj (2/22/2016)

    Ed Wagner (2/21/2016)

    Orlando Colamatteo (2/20/2016)

    TomThomson (2/20/2016)

    Ed Wagner (2/19/2016)

    TomThomson (2/19/2016)

    ZZartin (2/19/2016)

    Driver

    road hog

    Harley

    Davidson

    Curry

    Spice

    Girls (sorry)

    Tellmewhatchawant (sorry)

    Requirements

    Sweet dreams

    Nightmares

    February 22, 2016 at 10:24 am

    #1860145

  • RE: case when error in sqlserver

    David McKinney (2/22/2016)

    what about simply....

    update admin

    set [add]= 1

    where uname IN ('jain', 'baiju')

    I guess I cannot see the forest for the trees. :hehe:

    February 22, 2016 at 6:49 am

    #1860072

  • RE: case when error in sqlserver

    baiju krishnan (2/21/2016)

    Hi following is a working code

    update admin

    set [add]= CASE WHEN uname = 'jain' THEN 1 ELSE [add] END

    ,[edit] = CASE WHEN uname='baiju' THEN 1...

    February 22, 2016 at 5:22 am

    #1860049

  • RE: Are the posted questions getting worse?

    Luis Cazares (2/19/2016)

    Ed Wagner (2/19/2016)

    GilaMonster (2/19/2016)

    SQLRNNR (2/18/2016)

    I am seeing people claim to be an MCM for some of these interviews. I know full well they aren't an MCM. I have...

    February 22, 2016 at 5:09 am

    #1860045

  • RE: Today's Random Word!

    Ed Wagner (2/21/2016)

    Orlando Colamatteo (2/20/2016)

    TomThomson (2/20/2016)

    Ed Wagner (2/19/2016)

    TomThomson (2/19/2016)

    ZZartin (2/19/2016)

    Driver

    road hog

    Harley

    Davidson

    Curry

    Spice

    Girls (sorry)

    February 22, 2016 at 4:58 am

    #1860043

  • RE: Today's Random Word!

    Luis Cazares (2/19/2016)

    crookj (2/19/2016)

    Revenant (2/19/2016)

    ThomasRushton (2/19/2016)

    DonlSimpson (2/19/2016)

    ThomasRushton (2/19/2016)

    Stuart Davies (2/19/2016)

    SQLRNNR (2/19/2016)

    mussels

    COCKLES

    Wombles

    Tobermory

    Harbour

    Light

    Speed

    Force

    Mass

    February 19, 2016 at 10:55 am

    #1859900

Viewing 15 posts - 571 through 585 (of 1,493 total)