Forum Replies Created

Viewing 15 posts - 181 through 195 (of 272 total)

  • RE: Sub Query

    sknox (7/25/2014)

    At its heart, a correlated subquery is simply one that refers to data from the outer query.

    These are (non-correlated) subqueries:

    SELECT DB_NAME()

    , (SELECT count(*) FROM sys.objects) AS TotalObjects

    , (SELECT count(*)...

    July 28, 2014 at 8:36 am

    #1732870

  • RE: Byte Me: Deep Insight

    Thanks for the laugh.

    July 23, 2014 at 12:22 pm

    #1731899

  • RE: Back from Sabbatical

    Our pastors get a sabbatical every few years (I think maybe every 5, but don't hold me to that.)

    It's usually a mixture of time to relax and...

    July 22, 2014 at 1:12 pm

    #1731567

  • RE: How many Records are Returned?

    Clever question. Have to admit I got it wrong.

    June 30, 2014 at 8:25 am

    #1725875

  • RE: Application Developers don’t own their data

    Jeff Oresik (6/28/2014)

    I wouldn't take "my" data to mean at the exclusion of others. It is a declaration of ownership, but usually in the context of taking responsibility for the...

    June 29, 2014 at 11:49 am

    #1725730

  • RE: The Great Escape

    Jeff Moden (6/26/2014)

    Heh... it would appear that the default definition of default is in default. 😀

    Gave me a smile at the start of the day.

    June 26, 2014 at 7:49 am

    #1725080

  • RE: Stairway to T-SQL: Beyond The Basics Level 7: Controlling the Flow of Your T-SQL

    What are some real-life examples of using the While statement that don't involve RBAR code?

    June 25, 2014 at 11:06 am

    #1724729

  • RE: The Great Escape

    Got it wrong because of missing that [t-a] wouldn't work, but learned about the escape clause.

    June 25, 2014 at 10:33 am

    #1724720

  • RE: CTE DML

    SQLRNNR (6/17/2014)

    BWFC (6/17/2014)

    rhythmk (6/17/2014)

    Thanks for question.It reminds me the trick to delete the duplicate records in a table 🙂

    Could you enlighten me on that please? It sounds very useful.

    Here...

    June 17, 2014 at 12:57 pm

    #1722459

  • RE: Try to focus on the positive

    I'm grateful to be able to work from home. (I'm especially grateful for that in the winter when the roads are a mess.)

    I'm grateful to work for a manager...

    June 10, 2014 at 1:46 pm

    #1720565

  • RE: Bean Counting

    Richard Warr (5/12/2014)

    Ola L Martins-329921 (5/12/2014)

    Only because you find it easy, it doesn't necessarily is for all...

    If you find it easy - good for you and keep it to your...

    May 27, 2014 at 8:23 am

    #1716706

  • RE: Datatypes In Your Mind

    Eirikur Eiriksson (5/6/2014)

    I think Andy has been a tiny bit naughty:-D

    Excellent!

    May 24, 2014 at 1:44 pm

    #1716337

  • RE: Open Call for Editorials

    Hope you enjoy your sabbatical, but you'll certainly be missed.

    April 22, 2014 at 2:34 pm

    #1707907

  • RE: Consolidation Matters

    Jeff Moden (4/21/2014)

    Heh... this reminds me of hemlines in fashion. They change every other year.

    Remember when distributed computing was all the rage? It wasnt' that long ago. ...

    April 21, 2014 at 7:24 pm

    #1707600

  • RE: Syntax Validation

    Manic Star (4/8/2014)

    Better idea is to run the script on a staging environment that is a clone of production.

    Agree wholeheartedly. I would want to test more than just the...

    April 8, 2014 at 6:24 pm

    #1704348

Viewing 15 posts - 181 through 195 (of 272 total)