Forum Replies Created

Viewing 7 posts - 646 through 652 (of 652 total)

  • RE: Queries with Aggregate Functions

    Mahesh Bote (5/27/2009)

    [font="Verdana"]Answer should be 1, 2 and 4 as well as 2nd and 4th query are same.

    Mahesh[/font]

    Look more carefully - the second query is 'GROUP BY ManagerID' and will...

    May 27, 2009 at 4:51 am

    #1000467

  • RE: Create Database

    Lynn Pettis (5/13/2009)

    If you take a few minutes to read CREATE DATABASE in BOL you'd see that it is required that the directory structure already be in place, therefore for...

    May 13, 2009 at 8:52 am

    #993796

  • RE: Create Database

    Rachel Byford (5/13/2009)

    I don't, however, have much patience once the same observation has been made over and over again!

    Everybody should read the entire discussion before they decide to post to...

    May 13, 2009 at 5:57 am

    #993594

  • RE: Create Database

    Steve Jones - Editor (5/11/2009)

    If you see a path, you need to assume that path exists on the test system.

    Why? The question could be about whether or not SQLServer...

    May 11, 2009 at 9:04 am

    #992192

  • RE: Create Database

    Msg 5133, Level 16, State 1, Line 1

    Directory lookup for the file "C:\mssql\MYTEST.doc" failed with the operating system error 2(error not found).

    Msg 1802, Level 16, State 1, Line 1

    CREATE DATABASE...

    May 11, 2009 at 2:36 am

    #991950

  • RE: T-SQL Operators

    Lynn Pettis (4/14/2009)

    I guess not enough people complained about the answer to this question.

    I guess I'd better complain too then 😉

    MDX != TSQL

    April 16, 2009 at 5:29 am

    #978717

  • RE: Error Severity

    Agreed, the answer should definitely be 0 to 25 for the reasons already given

    April 16, 2009 at 5:27 am

    #978716

Viewing 7 posts - 646 through 652 (of 652 total)