Recent content by eo

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

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

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

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

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

That worked thanks EO Hertfordshire, England