Search results for query: *

I have created my first CLR in SQL to use regular expressions designed to match certain codes. Trouble is that I am trying to match the text HE1 in a string and keep getting a match for HE12 which is what I want to avoid. I have tried dbo.RegMatch(N'HE1[^0-9]' but this doesnot match anything...

I will try and make this as simple to understand as possible. I want to create a calculated member that will allow me to use the result as part of a query. The calculate member must contain the sum of a particular measure (measures.amount). This member must have already had two dimension...

And use the fact key in a many to many relationship as defined in the dimension usage? Thanks Mate

Sorry what I meant was number of attendances as a dimension rather. Eg below Attendances April May Jun ... 3 4 5 3 7 1 6 1 2 2 0 12 So for example from above 6 Unique patients attended 7 times in May. This was my attempt...

Can someone help me to construct an MDX expression. Its easier if I explain the final result. For admissions to hospital. Number of unique attendances as rows and months for a specific year as columns. The measures to show in the middle would be number of unique patients. So from the above...

Thanks for your reply, I cannot see anything wrong with my IF syntax after checking the help file. Is this because its function and not a USP?

Please can you help me with a function I am trying to create in TSQL. I want the results of different queries returned depending on the parameter I pass to the function. ALTER function [mercerd].[FN_Endoscopy_E01_QuarterlyCensus] (@lineid char(3)) returns table as return ( IF...

I am trying to work out a function that will allow us to round a given time to the nearest custom interval. I work in a hospital where we have consultant clinics. Take the example of a typical clinic where the session runs from 09:00 to 12:00 with each appointment lasting 30mins. So to fit...

Thanks for your post. I have just pointed the excel to the add in. Do you think this is the issue? The Add in does not require an install does it, you should just be able to copy the add in file.

I have just had my Microsoft Office Version upgraded to 2003. Since this upgrade the filter toolbar has become disabled and when I choose navigate nothing happens. I have tried to open another cube but this does not solve the problem. My colleague has the same version of office installed and...

Yes that works well done. Why does it not prompt when clicking on the report though? Thanks anyway David

Thanks for your reply I run the impromptu reports as normal ie open the reports from windows and it prompts for the details. Different story via upfront though it does not prompt. David

Does anyone know why the powerplay web reports we have will prompt when run from impromptu but not from upfront? Very bizzarre Please help I appreciate it. Thanks alot David

Please can someone clarify the solution for me. Apart from upgrading PPES do you have a link for me to download the patch. Is the patch availabe from COGNOS. I cannot find the detail via the knowledge base. Your help appreciated. David

This is very strange... When using the above mentioned program. We have encountered a major problem with dragging dimensions from the filter bar onto the grid. We are unable to drag the dimension onto the grid to replace a column or row dimension, although this works on some computers. Every...

Thanks for you help. I got an error message pointing to the increment word. I have however managed to get this to work. alter table KH06AdmissionsTBL add column rowid autoincrement not null primary key

Sorry I failed to mention that this new column has to be an autonumber field. This does not work alter table KH06AdmissionsTBL add column rowid autonumber not null primary key

The simple way to do it is create a vba function called nextmonday that accepts any date as a parameter and it would look something like this function nextmonday(thedate as date) as date dim i as integer dim rollingdate as date if weekday(thedate) = 2 then'2 is the number used for monday...

I want to add a column to a table and make that the primary key. I am using the following alter table KH06AdmissionsTBL add column rowid int primary key what am i doing wrong it said no nulls allowed but if i replace int to autonumber it still wont work. Any DDL experts out there? Many...

I want to add a column to a table and make that the primary key. I am using the following alter table KH06AdmissionsTBL add column rowid int primary key what am i doing wrong it said no nulls allowed but if i replace int to autonumber it still wont work. Any DDL experts out there? Many...