Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: eo
  • Order by date
  1. eo

    Complex view query needs improving - CHARINDEX join

    I have a few tables which are used in a view (SQL 2012), but the query takes far too long to run and I am looking at suggestions to improve performance. I do howevver know that clear bottleneck is the following join.. LEFT JOIN dbo.ToneDictionary D ON CHARINDEX(Dictionary,Title) > 0 The...
  2. eo

    Question re SSIS encryption

    Hi, I need to distribute an SSIS package to another person to use in a demo, but it is very important that I retain the IP, so must only provide him the ability to run the package, and disable the ability to open, view or modify the package. But I am not sure how to achieve this. It seems that...
  3. eo

    Extract multiple string parts from a string

    Using a Twitter Tweet loaded to a SQL table as an example, how would I create new columns to show # and @ string parts. For example the column called 'Tweet' contains 'Our home @pmanfoggers #home #house #garden #adelaide #southaustralia #building #brick #bricklove... http://t.co/YkaHqYg6 <via...
  4. eo

    Aggregation type - NONE; but setting aggregation through MDX - how to?

    Hi, I have a measure I want to shown ONLY at a certain scope. But cant seem to get this to work. The measure aggregation type is set to None, as to show nulls when analysed normally. But in MDX the measure is set to aggregation using a scope (which specifies the ONLY intersection where the user...
  5. eo

    Mystery of PIVOT, or is it???

    Hi, I think this is quite unique, but there is hopefully a way to achieve this. My data has 2 identifyers and 3 values: state city value1 value2 value3 SA Adealide 100 50 60 SA Port Adl 20 50 20 WA Perth 15 20 10 WA...
  6. eo

    Topology question across 3 servers (MS BI incl SSRS, SSIS, SSAS &amp; SP)

    Hi, We want to deploy a BI solution and have 3 environments: A large database server (DB Server), a SharePoint environment (MOSS2007) and another unused server (Additional). Looking for some guidance/ validation: Current: DB Server - SQL Server databases including the data warehouse, MOSS2007...
  7. eo

    How to get a parameter entry to identify a table.column

    Thanks for all the responses. I do normally steer clear of dynamic SQL. So I did end up following George's route, which is good to see validated by him. Etienne EO Hertfordshire, England
  8. eo

    How to get a parameter entry to identify a table.column

    Hi, I am writing a function. The function is based on a single table with 10 datetime columns. Lets call then DataTime1, DateTime2, ..., DateTime10. The user will decide at runtime which Column to return, so I thought of parameterising the function to allow the user to select between...
  9. eo

    From SharePoint lists into SQL Server 2008 R2 database

    Hi, Technologies - SQL Server 2008 R2, MOSS2007, and Office 2007 I have a set of SharePoint lists which I would like to expose to a variety of reporting technologies (SSAS, SSRS, etc). I am constrained with out of the box functionality, so custom solutions or third party options is not a...
  10. eo

    Advice on this clustering/ HA requirement

    Hi, I know this is like saying how long is a piece of string, but I need to advise (just as a starting point) for the provision of SQL Server 2008 r2 clustering/ HA solution to the business. There are three geographical locations. The topology broadly: • The client side • Data centre A – Here...
  11. eo

    trying to use currentmem properties to use the dim value as calc measu

    Hi, SSAS 2008. I am trying to use currentmember properties on a dimension attribute value as a calculated measure. The dimension has (amongst other) two attributes. Balance and Status. Balance is a value that could have been in a fact table, but is in the dimension due to many other reasons I...
  12. eo

    MDX Calculated member to compare dates for SLA purposes

    Hi, I have a task table, which contains Task Start Date, Task Due Date and Task Completed Date. I want to use this information to calculate a variety of things. I created a degenerate dimension from the FACT_Task table called TimeTransactionTask with the three datetime fields as dimension...
  13. eo

    Looking for a T-sql query that will convert UK postcodes

    And just to add, a postcode could have two, or one start alphas. So it could be WD11 3RU, or E1 2NY. So I need something to calculate when the first numeric from left to right occurs, and then to use RTrip to cut all the characters off from that point onwards. Dunno how to est when the first...
  14. eo

    Looking for a T-sql query that will convert UK postcodes

    I have played around with CharIndex, but cannot get this to work. I need to convert full UK postcodes from (example WD11 3RU to WD. I.e. drop any numeric or character to the right of the first numeric. Any ideas? EO Hertfordshire, England
  15. eo

    MDX Calc measure to accomdate Smi-Additive and delta at the same time?

    I am actually looking for a calculated measure. So I have used what you said and tried CREATE MEMBER CURRENTCUBE.[Measures].[LoanRequested] AS SUM({[DateAsAt].[HierarchyDateAsAt].[DayNumber].FIRSTCHILD:[DateAsAt].[HierarchyDateAsAt].[DayNumber].CurrentMember} , [Measures].[Loan...
  16. eo

    MDX Calc measure to accomdate Smi-Additive and delta at the same time?

    Hi, SSAS 2008. SQL Server 2008 Standard Edition I have two measure types in my cube, standard sum aggregated measures (which are baased over deltas/ changes from one day to another), and semi additive. The semi-additive have been implemented succesfully (using MDX calc measures) and so has the...
  17. eo

    How to generate distinct Month/ Years between two dates

    SQL Server 2008 (Std) I have a SP, but the data generated will ignore where no transactions have occurred. For example the first dataset is grouped in the second, and you can see April 2010 obviously ommitted as there where now data in April 2010: Dataset 1: TransDate Amount 01/01/2010...
  18. eo

    Query to return the MIN(Date) record in a group

    @George - the DIM_CO_Account_SSK and TransactionDate_DATETIME is most likely unique and logic for creating @StatusAccount is DECLARE @StatusAccount TABLE ( StatusTo_DWSK uniqueidentifier null ,StatusFrom_DWSK uniqueidentifier null ,DIM_CO_Account_DWSK uniqueidentifier null ,DIM_CO_Account_SSK...
  19. eo

    Query to return the MIN(Date) record in a group

    SQL Server 2008 Hi I created a query that returns the earliest record in a group, and links it as a new field back to the orig dataset, but it behaves very badly. Is there a more optimal version of such a query? select a.UnifiedAcctApplNumber ,a.DIM_CO_Account_SSK ,a.StatusTo...

Part and Inventory Search

Back
Top