Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 1,493 total)

  • RE: Today's Random Word!

    Ed Wagner (3/31/2015)

    crookj (3/31/2015)

    Ed Wagner (3/31/2015)

    TomThomson (3/31/2015)

    Eirikur Eiriksson (3/30/2015)

    SQLRNNR (3/30/2015)

    lingus

    Port

    Wine

    Cheese

    Mouse

    Cat

    Lion

    March 31, 2015 at 7:57 am

    #1787729

  • RE: Float value converting before concatenate gets rounded in SQL 2008

    umeshlade87 (3/30/2015)

    For

    Declare @a float=29123455612589.23610

    SELECT CONVERT(varchar(max), convert(decimal(25,5) , @a))

    Result :29123455612589.23400 which is rounded again.

    Did you notice it is not rounded but a different number? If rounded the last number...

    March 30, 2015 at 7:29 am

    #1787335

  • RE: Adding Minutes(varchar) to a datetime field

    Jeff Moden (3/29/2015)

    I'd have been quite happy if they had extended the "direct" math functionality to be more like EXCEL where you can add "times" (durations) in excess of 24...

    March 30, 2015 at 6:50 am

    #1787318

  • RE: Today's Random Word!

    Ed Wagner (3/30/2015)

    Revenant (3/28/2015)

    Eirikur Eiriksson (3/28/2015)

    SQLRNNR (3/27/2015)

    fruition

    Realize

    Awakening

    Growth

    Spring

    March 30, 2015 at 6:33 am

    #1787311

  • RE: Today's Random Word!

    Revenant (3/27/2015)

    Ed Wagner (3/27/2015)

    Eirikur Eiriksson (3/27/2015)

    djj (3/27/2015)

    whereisSQL? (3/27/2015)

    SQLRNNR (3/27/2015)

    retriever

    golden

    Doodle

    Dandy

    Handy

    Man

    Woman

    March 27, 2015 at 11:27 am

    #1787002

  • RE: Are the posted questions getting worse?

    jasona.work (3/27/2015)

    I hate Fridays around this place...

    Unless you've got some project going on that can be worked on when 50+% of the staff is off, you spend a good chunk...

    March 27, 2015 at 8:57 am

    #1786933

  • RE: Today's Random Word!

    whereisSQL? (3/27/2015)

    SQLRNNR (3/27/2015)

    retriever

    golden

    Doodle

    March 27, 2015 at 8:56 am

    #1786932

  • RE: Adding Minutes(varchar) to a datetime field

    I like Eirikur Eiriksson's solution.

    A little more information can be found, http://stackoverflow.com/questions/7289753/combining-date-and-time-fields-to-datetime-sql-server-2008

    March 27, 2015 at 6:06 am

    #1786827

  • RE: Flash drive encryption

    Thank you Eirikur Eiriksson, I was looking for a third party solution as I already own a drive. However your solution would be the simplest, so I will look...

    March 27, 2015 at 4:17 am

    #1786790

  • RE: Today's Random Word!

    Ed Wagner (3/26/2015)

    SQLRNNR (3/26/2015)

    djj (3/26/2015)

    SQLRNNR (3/26/2015)

    pursuit

    Hot

    blooded

    Anger

    Management

    March 26, 2015 at 11:47 am

    #1786655

  • RE: Today's Random Word!

    SQLRNNR (3/26/2015)

    pursuit

    Hot

    March 26, 2015 at 9:42 am

    #1786598

  • RE: Today's Random Word!

    Ed Wagner (3/25/2015)

    djj (3/25/2015)

    Eirikur Eiriksson (3/25/2015)

    Ed Wagner (3/25/2015)

    eccentricDBA (3/25/2015)

    crookj (3/25/2015)

    Ed Wagner (3/25/2015)

    Eirikur Eiriksson (3/24/2015)

    TomThomson (3/24/2015)

    Eirikur Eiriksson (3/24/2015)

    djj (3/24/2015)

    Eirikur Eiriksson (3/24/2015)

    Ed Wagner (3/24/2015)

    Revenant (3/24/2015)

    whereisSQL? (3/24/2015)

    Eirikur Eiriksson (3/24/2015)

    Ed Wagner (3/24/2015)

    djj (3/24/2015)

    Ed Wagner...

    March 26, 2015 at 5:38 am

    #1786507

  • RE: Today's Random Word!

    Eirikur Eiriksson (3/25/2015)

    Ed Wagner (3/25/2015)

    eccentricDBA (3/25/2015)

    crookj (3/25/2015)

    Ed Wagner (3/25/2015)

    Eirikur Eiriksson (3/24/2015)

    TomThomson (3/24/2015)

    Eirikur Eiriksson (3/24/2015)

    djj (3/24/2015)

    Eirikur Eiriksson (3/24/2015)

    Ed Wagner (3/24/2015)

    Revenant (3/24/2015)

    whereisSQL? (3/24/2015)

    Eirikur Eiriksson (3/24/2015)

    Ed Wagner (3/24/2015)

    djj (3/24/2015)

    Ed Wagner (3/24/2015)

    djj (3/24/2015)

    Cat

    Caterpillar

    Butterfly

    Effect

    Hurricane

    storm

    teapot

    Boil

    Steam

    Ship

    Deadline

    Lifeline

    Backup

    Restore

    Refurbish

    Reinvent

    Tune

    Sharp

    Point

    March 25, 2015 at 1:46 pm

    #1786413

  • RE: Get data changes from history table

    only_you (3/25/2015)

    Here is quary I'm looking for

    SELECT ProductID

    FROM Table

    GROUP BY ProductID

    HAVING COUNT(DISTINCT SalesPerson) > 1

    Are there another ways?

    SELECT *

    FROM Table

    WHERE IsLast = 1;

    March 25, 2015 at 7:08 am

    #1786282

  • RE: Get data changes from history table

    only_you (3/25/2015)

    Hi,

    how to get products on which SalesPerson changed. Here is table with data.

    Normally I would ask what have you tried...

    Try a select that looks for IsLast as true.

    March 25, 2015 at 7:00 am

    #1786272

Viewing 15 posts - 1,006 through 1,020 (of 1,493 total)