Forum Replies Created

Viewing 15 posts - 10,621 through 10,635 (of 39,885 total)

  • RE: Random values

    You can qualify with the full table name.

    I find that to be incredibly annoying to read in a query, especially when I have tables like

    - CustomerAddress

    - InstantForum_MessageTopics

    Having long names...

  • RE: Random values

    I'm with Jeff. If I had

    SELECT

    CustomerID

    ,Name

    ,Address

    ...

    FROM

    Customer

    I like the alias. Not because I'd self join to Customer, but...

  • RE: You Can Still Vote for PASS

    I'm glad too. They deserve the praise for acting and getting things done.

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (9/29/2014)


    Went over 13,000 points today. Seems like a déjà vu 😀 😎

    Congrats, and thanks

  • RE: RAND Unions

    stormsentinelcammy (9/29/2014)


    i totally read the question wrong, for some reason in my head i was thinking how many columns since that was the first thing i was thinking about, but...

  • RE: Fantasy Football 2014

    It was amazing. I came back from the high school rodeo to find myself down at the start of the second games something like 90-40. Slowly I saw my scores...

  • RE: RAND Unions

    Sorry, I was in the middle of other stuff an paraphrased.

    I've removed some of that info to keep it simpler, since I can't really build a solid explanation to cover...

  • RE: RAND Unions

    Thanks, added more detail to the explanation.

  • RE: Fantasy Football 2014

    that was a good move. Made a few myself. Hope one of them works out.

  • RE: Random values

    Yes, I have Prompt set to build aliases. It works well for me and I have custom ones for certain tables.

    I neglected to put it in for the "id" column...

  • RE: Are the posted questions getting worse?

    In terms of spammers, the devs are testing askimet, which looks to prevent some posts from spammers. I also spent some time writing a job to whack posts with patterned...

  • RE: Is SQL Server Mature?

    Dave62 (9/26/2014)


    My company takes a middle of the road approach. We don't upgrade every version but we do try to stay in a version that is supported. When...

  • RE: Is SQL Server Mature?

    pjdijkstra (9/26/2014)


    We are in the proces of dropping our Oracle DB + SAP BODS + Cognos stack and starting fresh with SQL Server 2012 (we asked for 2014 but our...

  • RE: Is SQL Server Mature?

    s.bradbury (9/26/2014)


    I realise this applies to the editorial less than the SQL Server 6.5 example, but 2008 r2 is such a good product I can't see any real reason to...

Viewing 15 posts - 10,621 through 10,635 (of 39,885 total)