Forum Replies Created

Viewing 15 posts - 91 through 105 (of 106 total)

  • RE: What was that field name?

    Sebastian Zeller (8/6/2014)


    You could also use a simple table alias to choose from the list of columns 🙂

    Select *

    FROM dbo.Customers c

    WHERE c.

    +1

    This is my preferred method, because...

  • RE: Using Views

    We have leveraged this option to some degree. But our system also uses replication, and each new view is another article of replication we must add. We are...

  • RE: table variable declaration inside a loop

    patrickmcginnis59 10839 (7/30/2014)


    Xavon (7/30/2014)


    But you still can't use a variable before you declare it...

    This 'logic' makes my head hurt.

    When that error is picked up, its actually checking to see if...

  • RE: table variable declaration inside a loop

    But you still can't use a variable before you declare it...

    This 'logic' makes my head hurt.

  • RE: Summer, Summer, Summertime

    Did some reading, watched some movies, played a few games. The normal stuff.

    I did go to the local amusement park once, hope to go again.

    My big vacation will be...

  • RE: Number of rows returned by different JOINs

    Stewart "Arturius" Campbell (7/3/2014)


    Found myself thinking this was way too easy, where's the catch?

    only to find there wasn't one

    Nice question, thanks Abbas

    +1

    This took me way too long to answer, because...

  • RE: No Files For You

    After narrowing it done to 2000 or Cloud, and realizing neither was valid by the question's own logic, I went with Cloud because with most QotD, going with the more...

  • RE: Laptop Dreams

    I love my Surface 2 Pro, and am even adapting to Windows 8. And the Power Cover is a great, easily detachable keyboard and second battery. I used...

  • RE: Geeky Entertainment

    +1 on the Magical Kingdom of Landover series

    Rick Cook's Wizardry series would make a decent set of films, but would probably be too geeky for the general public.

  • RE: Geeky Entertainment

    When the first Artemis Fowl book came out, there was a secret code in the book that was supposed to be an entry for a walk on role in the...

  • RE: Fixing CREATE TABLE

    Because altering a table is not as simple as altering a sproc.

    Altering a sproc is basically replacing it from the ground up. Altering a table is less...

  • RE: Adding to SQL Server

    A minor request, but I would very much like to have GREATEST() and LEAST() like MySQL has.

  • RE: The Geek Christmas Poll

    I want an official Red Ryder, carbine action, two-hundred shot range model air rifle!

    Sorry, had to be said.

    Seriously though, my netbook just died, so I have been looking for...

  • RE: What's in a Name?

    My surname is deJager; with the 'J' pronounced as a 'Y'. So I run into both pronunciation and spelling issues, as it is ingrained into people to capitalize the...

  • RE: wildcards

    Richard Warr (9/11/2013)


    Secondly, and more importantly, I am a computer professional. I work in a world of absolutes. Compilers do not give you credit for the code you...

Viewing 15 posts - 91 through 105 (of 106 total)