Forum Replies Created

Viewing 15 posts - 1,021 through 1,035 (of 19,564 total)

  • RE: Today's Random Word!

    Revenant (8/4/2015)


    Ed Wagner (8/4/2015)


    bcsims 90437 (8/4/2015)


    whereisSQL? (8/4/2015)


    Ed Wagner (8/4/2015)


    DonlSimpson (8/4/2015)


    Eirikur Eiriksson (8/4/2015)


    Ed Wagner (8/4/2015)


    SQLRNNR (8/4/2015)


    Revenant (8/4/2015)


    Ed Wagner (8/4/2015)


    bcsims 90437 (8/4/2015)


    whereisSQL? (8/4/2015)


    Ed Wagner (8/4/2015)


    DonlSimpson (8/4/2015)


    Eirikur Eiriksson (8/4/2015)


    Ed Wagner (8/4/2015)


    SQLRNNR (8/4/2015)


    Prime

    Number

    Act

    Phone

    Smart

    y Pants

    Where's...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/4/2015)


    SQLRNNR (8/4/2015)


    Steve Jones - SSC Editor (8/4/2015)


    Since we're all piling on the behavior of others, I was wondering.

    Is there value in getting the questions/knowledge that people lack in...

  • RE: only show the duplicated records

    kennyhuang0108 (8/4/2015)


    Thank you all very much.

    Should I apply the whole thing or only below part in my query? thank you

    SELECT LEV5

    FROM MyCTE

    GROUP BY LEV5

    HAVING COUNT(*) > 1

    )

    SELECT MC.*

    FROM MyCTE...

  • RE: non trusted constraints vs performance

    newbieuser (8/4/2015)


    Friends,

    What are other causes that make check/FK constraints non trusted because we normally don't enable/disable constraints during loads or scripts or anything. We always drop and re-create...

  • RE: Are the posted questions getting worse?

    WayneS (8/4/2015)


    Sean Lange (8/4/2015)


    yb751 (8/4/2015)


    Raise your hands if you like Entity Framework...then I'll know who to shoot!

    Sorry just needed two seconds to vent. :crazy:

    I'm sure like anything else it can...

  • RE: can a foreign nationals find a job in BI position ?

    bghad1 (8/4/2015)


    Alvin Ramard (8/4/2015)


    FYI, there are many foreigners working in every imaginable IT position, including BI, in the US.

    are you sure that BI is not kinda restricted area of IT...

  • RE: How to build in SSIS

    sqlinterset (8/4/2015)


    I am new to SSIS, so after reading it so far... i need to install business intelligence development studio to build SSIS solution to bring data from One SQL...

  • RE: only show the duplicated records

    kennyhuang0108 (8/4/2015)


    Thanks Steve.

    When I added below part into my query

    group by B.BF_ORGN_CD, B.LEV5, A.BF_ACTY_CD

    having count(B.LEV5) >1

    none of the records was showed. Not sure if I did something wrong.

    thanks.

    Try using...

  • RE: Today's Random Word!

    Prime

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (8/4/2015)


    Since we're all piling on the behavior of others, I was wondering.

    Is there value in getting the questions/knowledge that people lack in interviews published? Not...

  • RE: Sql Query

    Cadavre (8/4/2015)


    Cheat! 😛

    Who me?:crazy:

  • RE: file server / SQL cluster

    Are you trying to access the files from SQL via the UNC as well, and that is failing?

  • RE: Sql Query

    Jeff Moden (8/4/2015)


    Might have to add the 3 different WHERE clauses to that... they are all different.

    Minor things. Who needs a correct filter (as I went back and fixed mine...

  • RE: Sql Query

    Cadavre (8/4/2015)


    Again, not very clear what you want. . . maybe something like: -

    Look at that, getting lucky. 😀

  • RE: How to build in SSIS

    sqlinterset (8/4/2015)


    Can you share some really good articles?

    I would start with the Stairway Series on SSIS by Andy Leonard.

    http://www.sqlservercentral.com/stairway/72494/

Viewing 15 posts - 1,021 through 1,035 (of 19,564 total)