Hi Steve, thanks for your reply - sorry about the delayed response.

I agree with your solution and certainly building reports directly from the CRM system would be a lot easier....

Looks like you're trying to insert a record into a field called "ID" which is an identity field. You either don't want to import a record into that field or...

Thanks for your reply.

I have been thinking about this for a while now and what seems to have been built for the company is an Operational Data Store (ODS). But...

Got it in the end !!

ParallelPeriod ([CRM DIM Time].[Date].[Date], -6 , STRTOMEMBER(@ReportDay) )

So far I have tried using the hierarchy members with various combinations of the following;

MEMBER [Measures].[ParameterValue7Days] AS '[CRM DIM Time].[Year - Quarter - Month - Day Hierarchy].[date].lag(7)'

MEMBER [Measures].[ParameterValue7Days] AS...

Thanks Steve, I'll give this a go tomorrow.

I have to product several reports which have NoOfAppointments, CancelledAppointments, SuccesfulAppointments etc. By Sales Person and by Area.

At the moment the only fact...

Thanks for your help guys. At the moment I used Derek's old skool technique provided earlier. But I will be sure to review Jeff's article and see if I can...

This is good. Closer to what I require.

The point that I need to make clear is that this table will contain object information for each day, (sometimes more than once)...

Jeff, thanks for you advice.

The collation used is SQL_Latin1_General_CP1_CI_AS. So this is case insensitive. If the join handles the RTRIM then as you state that leaves the LTRIM to deal...

It does have a datetime field but this contains 2008-11-01 00:00:00.000 and so on. So if we have a datetime field with 2008-11-01 12:58:21.000 we cannot use this field to...

Thanks guys, some interesting perspectives. I invite more people to raise their points.

Steve where will I be able to read your article?

Thanks, but how would go about spliting the one transaction into many?

Hi, thanks for your reply. I am not following exactly what you mean in relation to the script task, but it certainly sounds like the best way to go.

I have...

I have made the change but get the following error Must declare the scalar variable "@SeqNo".

Here is my revised code;

CREATE PROCEDURE up_SequenceNumber

@ReportName CHAR(30),

@SeqNo int OUTPUT

AS

DECLARE @SQLGetNo nvarchar(250)

DECLARE @SQLUpd nvarchar(250)

SET @SQLGetNo...

Yes, @ReportName is the name of a column. I would prefer to use dynamic SQL.