Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

I have a report with two row groupings: Group1 - StatusGroup, Child Group(2) - ApplicationID In the details section is amongst other fields a value (LoanRequested). It is aggregated at the Group2 group level as Max(LoanRequested). Is ut possible to change the order in which Group2 is displayed...

I will use a simple dataset. This dataset shows mortgages applications, and the applicants. For applicant 100 and 200 there are single applicants per applicantion, but for application 300 there are 3 applicants. Application Applicant 100 Smith Andrew 200 Jones Daniel 300...

I have a set of data on which I perform fuzzy grouping, but only need to use the most recent of each group. The group is based on a Business Key (SSK). I will show bwo example data DWSK SSK CompanyGroupName CompanyName 001 100 A.H.L A.H.L London 002 100 A.H.L...

I have a table of customer names & surnames. The business requirement is for me to highlight from those two columns any possible matches via a report, that the users can then go an investigate. But I am not sure how to use soundex or fuzzy logic to highlight such potential matches. Any advise...

I am working on a DW project, and have to massage the data so that down stream development can continue. I have a few rate (percentage) columns (data type money), and at the moment they are all populated with 0.00. I want to randomly populate them with an update statement with values of between...