Forum Replies Created

Viewing 15 posts - 196 through 210 (of 322 total)

  • RE: Sort Order - Include Null al last

    Lynn,

    Well put. I couldn't have said it better myself.

    (I considered doing a quoted reply, but I wasn't sure whether or not we get points for acreage.)

    😀

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 25, 2008 at 7:52 am

    #833970

  • RE: Cloning

    Steven Cameron (6/25/2008)

    How many shops don't have a development or testing server to clone it to?

    How much is SQL Server Developer Edition? $150.00? Something like that. Doesn't have to run...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 25, 2008 at 7:25 am

    #833928

  • RE: Cloning

    Why not just throw it on to a Developer instance?

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 25, 2008 at 7:11 am

    #833907

  • RE: Sort Order - Include Null al last

    I suppose we could probably put our subscription fees to better use.

    :smooooth:

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 24, 2008 at 3:42 pm

    #833622

  • RE: Sort Order - Include Null al last

    Steve must be off for a couple of days. The newsletter was published today, but I didn't get it by email. The editorial was by Tony. After he sees this...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 24, 2008 at 1:45 pm

    #833571

  • RE: The Core

    All you really need to know is how to open a command window and type "HELP".

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 24, 2008 at 10:45 am

    #833461

  • RE: The Core

    It does require an understanding of the Command language (formerly DOS). Do they even teach that any more?

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 24, 2008 at 9:28 am

    #833385

  • RE: Sort Order - Include Null al last

    Perhaps they figured out how much fun we have reviewing them ourselves.

    :hehe:

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 23, 2008 at 7:41 pm

    #833112

  • RE: Create Temporary Tables Dynamically in cursor loop

    elmerbotha (6/23/2008)

    Thanks a lot! I will see how I can implement all that you've given me. Regarding throwing away useless values and replacing them: The store procedure returning the result...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 23, 2008 at 11:23 am

    #832928

  • RE: Sort Order - Include Null al last

    sl.sajeev (6/23/2008)

    Yes you are correct. Actually i posted it as a question with only the second one as correct answer.

    sl.sajeev (6/23/2008)

    Yes you are correct. Actually i posted it as a...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 23, 2008 at 9:56 am

    #832841

  • RE: Sort Order - Include Null al last

    smunson (6/23/2008)

    This is despicable - a QOTD where the supposedly correct answer is quite clearly incorrect, unless you happen to take an extraordinarily ODD interpretation of the question and assume...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 23, 2008 at 8:53 am

    #832757

  • RE: Sort Order - Include Null al last

    evifra (6/23/2008)

    "You have a table with EmpName and DateOfLeaving columns. The EmpName column is mandatory, but DateOfleaving will have null value for those employees who have not left the company....

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 23, 2008 at 6:52 am

    #832616

  • RE: Sort Order - Include Null al last

    Select EmpName, DateOfLeaving from Employees order by DateOfLeaving desc, EmpName asc

    That's just wrong. :hehe:

    DECLARE @Employees table (

    EmpName varchar(5),

    DateOfLeaving datetime

    )

    insert into @Employees select 'Abc', '10 Oct 1999'

    insert into...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 21, 2008 at 2:37 pm

    #832292

  • RE: The Core

    After losing a 10 minute reply to some kind of session timeout :w00t:, I'm going to just brief it now.

    Great, true, and positive stuff has already been posted.

    I'm a .NET...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 21, 2008 at 1:54 pm

    #832280

  • RE: Best Practices for Database Design

    paulhunter (6/21/2008)

    What a let down. I was expecting an article on good database design practices. Instead we're treated to another diatribe on naming conventions. About the only...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 21, 2008 at 12:28 pm

    #832265

Viewing 15 posts - 196 through 210 (of 322 total)