Forum Replies Created

Viewing 15 posts - 5,086 through 5,100 (of 8,753 total)

  • RE: Today's Random Word!

    Ed Wagner (6/8/2015)

    crookj (6/8/2015)

    Ed Wagner (6/8/2015)

    Revenant (6/8/2015)

    DonlSimpson (6/8/2015)

    Ed Wagner (6/8/2015)

    djj (6/8/2015)

    Ed Wagner (6/8/2015)

    DonlSimpson (6/5/2015)

    Eirikur Eiriksson (6/5/2015)

    Monarchy

    Empire

    Republic

    Plato

    Socrates

    Philosopher

    Academy

    Starfleet

    KDF

    Bird of Prey

    Specialization

    June 8, 2015 at 12:37 pm

    #1803780

  • RE: Ceating a running total based on an a single (SUM) Opening Balance

    Same as pietlinden's, adjusted to the required output

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    IF OBJECT_ID(N'tempdb..#Temp') IS NOT NULL DROP TABLE #Temp;

    CREATE TABLE #Temp(

    [ROWNUMBER] [float] NULL,

    [Component] [float] NULL,

    [M/O No] [float] NULL,

    [Opening Balance] [float]...

    June 8, 2015 at 1:17 am

    #1803581

  • RE: SQL Server 2008 Query Help

    Quick solution, works with the sample data

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    ;WITH SampleData (REQCODE, PERSON, STARTDATE, ENDDATE, STARTTIME, ENDTIME, ...

    June 7, 2015 at 4:16 am

    #1803537

  • RE: Today's Random Word!

    Ed Wagner (6/5/2015)

    jasona.work (6/5/2015)

    ZZartin (6/5/2015)

    Ed Wagner (6/5/2015)

    jasona.work (6/5/2015)

    Ed Wagner (6/5/2015)

    Revenant (6/5/2015)

    SQLRNNR (6/5/2015)

    Ed Wagner (6/5/2015)

    BL0B_EATER (6/5/2015)

    SQLRNNR (6/5/2015)

    Eirikur Eiriksson (6/3/2015)

    Ed Wagner (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    SQLRNNR (6/3/2015)

    while

    Loop

    Eliminate

    Kawasaki

    Yamaha

    piano

    Organ

    tube

    subway

    Traffic

    Cone

    Ice Cream

    Float

    Pennywise

    :w00t:

    Stephen King (It)

    Monarchy

    June 5, 2015 at 12:07 pm

    #1803432

  • RE: Today's Random Word!

    Ed Wagner (6/5/2015)

    BL0B_EATER (6/5/2015)

    SQLRNNR (6/5/2015)

    Eirikur Eiriksson (6/3/2015)

    Ed Wagner (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    SQLRNNR (6/3/2015)

    while

    Loop

    Eliminate

    Kawasaki

    Yamaha

    piano

    Organ

    Donor

    June 5, 2015 at 9:17 am

    #1803341

  • RE: Are the posted questions getting worse?

    Alvin Ramard (6/4/2015)

    Eirikur Eiriksson (6/4/2015)

    Jeff Moden (6/4/2015)

    Shifting gears a bit...

    Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, I think...

    June 4, 2015 at 1:45 pm

    #1803158

  • RE: Are the posted questions getting worse?

    Jeff Moden (6/4/2015)

    Shifting gears a bit...

    Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, I think such a thing would...

    June 4, 2015 at 12:00 pm

    #1803106

  • RE: Are the posted questions getting worse?

    Ed Wagner (6/4/2015)

    Brandie Tarvin (6/4/2015)

    Ed Wagner (6/3/2015)

    SQLRNNR (6/3/2015)

    Alan.B (6/3/2015)

    So I'm curious about this (I'm trying to understand how SSC works):

    Then the comment is not there...

    There are a bunch of them...

    June 4, 2015 at 6:45 am

    #1802961

  • RE: Today's Random Word!

    djj (6/4/2015)

    Ed Wagner (6/3/2015)

    DonlSimpson (6/3/2015)

    Ed Wagner (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    Ed Wagner (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    SQLRNNR (6/3/2015)

    while

    Loop

    Eliminate

    Kawasaki

    Motorcycle

    Freedom

    Independence

    Missouri

    Caves

    June 4, 2015 at 4:55 am

    #1802938

  • RE: Help on query - produce permutation combination

    squvi.87 (6/4/2015)

    Hi There,

    I need a help on query to produce permutation combination.

    declare @t2 as table (tab varchar(100))

    insert into @t2 values ('V')

    insert into @t2 values ('VL')

    insert into @t2 values ('1099')

    insert...

    June 4, 2015 at 3:05 am

    #1802917

  • RE: Are the posted questions getting worse?

    Alvin Ramard (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    Luis Cazares (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    SQLRNNR (6/3/2015)

    Ed Wagner (6/3/2015)

    SQLRNNR (6/3/2015)

    Brandie Tarvin (6/3/2015)

    I am going to report ya'll to the USDA for pork chop abuse.

    I just thought you...

    June 3, 2015 at 12:52 pm

    #1802780

  • RE: Today's Random Word!

    Ed Wagner (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    SQLRNNR (6/3/2015)

    while

    Loop

    Eliminate

    Kawasaki

    June 3, 2015 at 12:45 pm

    #1802775

  • RE: Are the posted questions getting worse?

    Luis Cazares (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    SQLRNNR (6/3/2015)

    Ed Wagner (6/3/2015)

    SQLRNNR (6/3/2015)

    Brandie Tarvin (6/3/2015)

    I am going to report ya'll to the USDA for pork chop abuse.

    I just thought you should know.

    Actually, these days...

    June 3, 2015 at 12:10 pm

    #1802762

  • RE: Today's Random Word!

    SQLRNNR (6/3/2015)

    while

    Loop

    June 3, 2015 at 12:03 pm

    #1802755

  • RE: Today's Random Word!

    Ed Wagner (6/3/2015)

    cunningham (6/3/2015)

    Revenant (6/3/2015)

    eternal

    flame

    Fire

    Streak

    June 3, 2015 at 12:03 pm

    #1802754

Viewing 15 posts - 5,086 through 5,100 (of 8,753 total)