Hi Guys, I have managed to got it all working. I am inserting values into 2 different tables in the stored procedure. I have simply joined these two tables to...

Thank you sean that fixed my problem and this is just a report I am making for a client which will be viewed in a word document so I had...

Sean i totally agree with what you said and apologies i didnt post the data in the correct format. In future ill make sure I post all the required data...

Sorry i am new to the forum and I will keep that in mind for my future posts.

I am executing

With mySampleData(strComment)

AS

(

SELECT TOP 100 strComment FROM [DB_access].[audit].[tblScenarioRunAudit]

WHERE strComment LIKE '%scenario%'

)

,IntermediateResults...

Hi,

When i run your code, on the second column actType I get '}' with all the results.

For example:

254}

254}

254}

Is it possible for you to remove the '}' from...

Thank you

Thank you for your reply.

Here is the DDL and the sample data as requested

USE [DB_Access]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [audit].[tblScenarioRunAudit](

[id] [int] IDENTITY(1,1) NOT NULL,

[keyScenario] [int] NULL,

[strComment] [varchar](8000)...

Thank you, will give it a try.

Thanks for your reply. I have added

FETCH NEXT FROM crSystem

INTO @SubId, @startDate, @endDate

Now I am getting this error:

Must declare the scalar variable "@SubID".

Msg 102, Level 15, State 1, Line...

Thats what i needed. Thanks a lot Lynn - you are a star! 🙂

Thanks for the quick response Lynn. I already have a table called tblConfig, I think I need a stored procedure or some sort of a cursor which will copy the...

Thats Correct.

Thanks and Regards

Thank you Lowell for creating a view for me. Its been a great help.

Kind Regards

Hi Ron,

Following is the TSql I used:

SELECT OBJECT_NAME(EXP.major_id) AS TableName,

C.name ...

Thank you Ron, appreciate your help.