Forum Replies Created

Viewing 15 posts - 106 through 120 (of 530 total)

  • RE: Avoiding NOT EXISTS or NOT IN

    I believe the performance of either three solutions is highly dependant on the data that is contained in the tables.

    1. The number of records in both tables

    2. The number of...

    September 24, 2003 at 4:09 am

    #475558

  • RE: Avoiding NOT EXISTS or NOT IN

    I don't believe there is a performance difference. The query optimiser should take care of this.

    Bill, I would like to point out that your query is not entirely correct.

    September 23, 2003 at 8:43 am

    #475433

  • RE: making calculated cells

    I don't think that is possible. You can only set the property for your measure; on all levels.

    If you want to set it on one level only, I think it's...

    September 23, 2003 at 8:34 am

    #475431

  • RE: making calculated cells

    Sairah, I am not sure what you want to accomplish exactly, but from your explanation, you don't need a calculated cell.

    It should be sufficient to set the Aggregate Function property...

    September 23, 2003 at 1:00 am

    #475352

  • RE: making calculated cells

    Steve, you are right; calculated cells don't store the value in the cube.

    I was trying to say that, if you store a calculated cell or member in your cube...

    September 23, 2003 at 12:57 am

    #475351

  • RE: making calculated cells

    A calculated cell is a value that is calculated ('doh') from other values in the cube.

    It is used to provide a certain value without everyone having to do the maths...

    September 22, 2003 at 6:45 am

    #475240

  • RE: How would you handle this and why??? (Common Data)

    I would strongly consider using a single table. Maybe not for phone numbers, but if you want to add any kind of business logic to such a table, you would...

    September 16, 2003 at 7:24 am

    #474406

  • RE: Repeating Formulae

    I'm afraid you do have to repeat it. One way around it would be to use a subquery in the FROM clause, but I don't know about performance.

    September 8, 2003 at 10:22 am

    #473053

  • RE: SQL 2000 and Windows 2003

    No issues at our test environment. Only make sure you have SP3 at hand. SQL Server won't start without it (on Windows 2003).

    September 8, 2003 at 10:16 am

    #473052

  • RE: Query to return nested info

    There is another thread around just dealing with this kind of problem.

    Look for http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15815&FORUM_ID=23&CAT_ID=2&Topic_Title=Recursive+Stored+Procedure+in+SQL+SERVER&Forum_Title=General

    To go short. You will need the maximum depth of the tree and build some dynamic query.

    Or...

    September 3, 2003 at 12:34 pm

    #472417

  • RE: Query to get first number

    Frank,

    Just read your post (well read it before, but didn't get it... Few glasses of wine and a bunch of Microsoft sales people work wonders ). Nice...

    September 3, 2003 at 12:22 pm

    #472413

  • RE: Recursive Stored Procedure in SQL SERVER

    Andy, this was the idea I had too, so no need to write the code . But I was just hoping you had a very clean and...

    September 3, 2003 at 1:49 am

    #472316

  • RE: Update trigger

    In each trigger, regardless of the type (INSERT, UPDATE and DELETE), there are two 'internal' tables : 'inserted' and 'deleted'.

    By default, the 'inserted' table contains the new values, whereas 'deleted'...

    September 3, 2003 at 1:46 am

    #472314

  • RE: A SUM problem

    Correct. Should be in two recordsets. If for some reason, you really need it in a single set, try the following statement.

    

    SELECT media_cost, production_cost,

      ...

    September 3, 2003 at 1:43 am

    #472313

  • RE: Rows into columns

    Similar questions have been asked before in here. Trying to get this from memory.

    First of all, you will need a table with all UTC values, call it Times.

    Secondly, you will...

    September 2, 2003 at 9:55 am

    #472211

Viewing 15 posts - 106 through 120 (of 530 total)