I am having some problems getting this to work on Reporting Services 2005.

I am trying to produce a key in the footer of a report, of possible values and descriptions...

Thank you for that GilaMonster.

I was planning to use the @@IDENTITY function to get the job number back, I don't think I had made it clear enough.

jason

I am assuming that this serializing access to this table is handled by Sql Server internally.

Having a identity field on the main table would also cause the same serailization...

Thank you for your ideas.

GUID is a new concept to me and I am not sure that I works in this case as it is not good for indexing as...

Hi Everybody

Continued on to produce the following stored procedure which does what I want.

create proc [dbo].[usp_calc_volumes]

@unq_ref int=null

as

begin

set nocount on

;WITH cteTemp AS

(SELECT RN...

Hi Everyone

Had a productive day with help from bt.

New code below

;WITH cteTemp AS

(SELECT RN = ROW_NUMBER() OVER(PARTITION BY mReadingDeviceReference, mReadingMeterType ORDER BY...

Thanks bt for that.

I will try and explain a few things and then ask some questions about your code so that I can work on it.

Both C# and SQL are...

Hi Everybody

Manage to get a stored procedure to work using a parameter to find values for a particular

mReadingDeviceReference.

ALTER PROCEDURE [dbo].[usp_meter_combine]

-- Add the parameters for the stored procedure here

@unq_ref...

Hi Gianluca and ColdCoffee

Thanks for the help guys. Currently working through Gianluca's dynamic generating example and converting it to my table.

I have a question though about the first part of...

Hi Everyone

Table Schema

CREATE TABLE [dbo].[meterReading](

[mReadingCallReference] [int] NULL,

[mReadingDeviceReference] [int] NULL,

[mReadingReadingType] [varchar](4) NULL,

[mReadingMeterReadingDate] [datetime] NULL,

[mReadingMeterType] [tinyint] NULL,

[mReadingMeterReading] [int] NULL,

[mReadingStatus] [tinyint] NULL

) ON [PRIMARY]

Sample Data

1646893,111078,PREP,2008-05-23 16:30:00.000,1,3,5

1646893,111078,PREP,2008-05-23 16:30:00.000,2,1,5

1648693,111078,DN,2008-06-02 00:00:00.000,1,3,5

1648693,111078,DN,2008-06-02 00:00:00.000,2,9,5

1658044,111078,INIT,2008-06-02 00:00:00.000,1,3,6

1658044,111078,INIT,2008-06-02 00:00:00.000,2,9,6

1648703,111078,I,2008-06-02 09:20:00.000,1,3,5

1648703,111078,I,2008-06-02 09:20:00.000,2,9,5

1648717,111078,LI,2008-06-02...

Hi Everybody

Just come across your site today as I was looking at exactly the same problem.

I have a similar table with at the moment 2 different resulting columns but this...