Forum Replies Created

Viewing 15 posts - 16 through 30 (of 43 total)

  • RE: Self-Joins?

    Looks like we can go on forever

    Your first query is correct, but the second one will...


    robbac
    ___the truth is out there___

    July 28, 2004 at 2:56 am

    #516515

  • RE: Question of the Day for 28 Jul 2004

    This is irritating!

    Why is no testing done by SqlServerCentral of the Question of the Day?

    One day you are supposed to see the query typo, and...


    robbac
    ___the truth is out there___

    July 28, 2004 at 2:27 am

    #516507

  • RE: Self-Joins?

    Hi alzdba!

    I do agree that the first querys where-statement is unnecessry and correct statement should be:

    SELECT   DISTINCT

             [Account#]

    FROM     [System_Account_Association]

    WHERE    [Account#] NOT IN (

                SELECT [Account#]

                FROM [System_Account_Association]

                WHERE [Associated?] LIKE 'YES' )


    robbac
    ___the truth is out there___

    July 28, 2004 at 2:11 am

    #516502

  • RE: Select B From (Select B,C From Table1) not working

    Hi Jerry!

    Without solving your first question the correct syntax for the second query should be:

    SELECT   c.InnerID

    FROM     (SELECT Customer.InnerID FROM Customer) c

     


    robbac
    ___the truth is out there___

    July 28, 2004 at 1:35 am

    #516493

  • RE: Self-Joins?

    Hi again!

    I was a pain From the last information I do realize (read understand) your question. You only need to use the last...


    robbac
    ___the truth is out there___

    July 28, 2004 at 12:37 am

    #516481

  • RE: Standard versus Enterprise

    Hi!

    One "easy" way to have a redundancy without having the cost of enterprise edition and clustering is to on a scheduled basis move db-backups and logs from one server to...


    robbac
    ___the truth is out there___

    July 27, 2004 at 11:50 pm

    #516474

  • RE: Version of SQL Server 2000

    Hi Bufsabres!

    Good linkes to Microsoft about the two versions:

    http://www.microsoft.com/sql/evaluation/overview/default.asp

    http://www.microsoft.com/sql/evaluation/features/choosing.asp

    And yes, you can use OLAP with both version.


    robbac
    ___the truth is out there___

    July 27, 2004 at 3:42 pm

    #516420

  • RE: SQL Server 2005

    Hi Juan!

    There are loads of new features in SQL 2005. Not to sure if I like an upgrade this big as moving to the next version of SQL. Half of...


    robbac
    ___the truth is out there___

    July 27, 2004 at 3:17 pm

    #516413

  • RE: SQL Newbie

    A good basic book for both learing a bit about SQL administration as well as the basics in T-sql is for example "Tech yourself SQL Server 2000 in 21 days"...


    robbac
    ___the truth is out there___

    July 27, 2004 at 3:10 pm

    #516406

  • RE: Self-Joins?

    Sorry for beeing a pain here, but where is the information stored about system that you mention?

    Write down either the structure of the two tables, or those tables that are...


    robbac
    ___the truth is out there___

    July 27, 2004 at 3:02 pm

    #516403

  • RE: Self-Joins?

    Hi Ramona!

    Could you please write down the table structure of those tables that will be involved in the query? If I don't missunderstand your question, there should be at least...


    robbac
    ___the truth is out there___

    July 27, 2004 at 8:45 am

    #516315

  • RE: Standard versus Enterprise

    Hi Kris!

    There are some differences between the two, but not that much. You have i.e. log-shipping in enterprise edition and:

    Enterprise: 32 processors, 64 gb memory

    Standard: 4 processors, 2 gb memory

    Both...


    robbac
    ___the truth is out there___

    July 27, 2004 at 8:26 am

    #516306

  • RE: Permissions in sql server 2000 (URGENT)

    You can't.

    If a user has ddl_admin-rights, they are able to alter existing tables as well as other objects.

     


    robbac
    ___the truth is out there___

    July 26, 2004 at 6:26 am

    #516059

  • RE: how to change the mssqlserver logon account to backup db on other machine

    It's correct that the SQL Server service that holds the database you need to back up should run under an NT-account with local administrator group on server A. The same NT-account should...


    robbac
    ___the truth is out there___

    July 26, 2004 at 5:34 am

    #516055

  • RE: Replication between Main server and remote sites

    If you will use both:

    Main site push data to sites

    Main site get data from sites

    You have two choises (as I see it). Either you use a two way transactional...


    robbac
    ___the truth is out there___

    July 26, 2004 at 3:56 am

    #516049

Viewing 15 posts - 16 through 30 (of 43 total)