Hi Guys,

This is the additional query I would like to add onto the existing one.

SELECT PropId, COUNT(*) AS [Number of Rows]

FROM ...

Here goes,

First time i've done this so I hope it's correct.

CREATE TABLE #PropDet

(

PropId INT IDENTITY(1, 1) PRIMARY KEY,

UserId UNIQUEIDENTIFIER,

PropName NVARCHAR(50),

Resort NVARCHAR(50),

Col5 NVARCHAR(50),

Col6 NVARCHAR(50),

Col7 NVARCHAR(50),

Col8 NVARCHAR(50),

Col9 NVARCHAR(50),

Col10 NVARCHAR(50),

Col11 NVARCHAR(50),

Col12 NVARCHAR(50)

)

--===== All...

fair enough...

i'll have a look and try to provide some data in the manner stated in the links.

might take me a while though so bear with me.

Thanks again

Mark

Hi,

I don't want to take the **** but while we're on the subject.....!;)

As part of the same procedure I'm also hoping to add another statement that will query a seperate...

That worked beautifully...I'm most impressed and you've certainly earnt your place in the hall of fame.

Thanks a million everbody for helping me with this.

Regards

Mark

Hi Seth,

My Group by should be on Col1 not Col3 ...thanks for pointing this out. This is fine for my query.

Mark

Do I really need to nest a repeater control in the main one If I will only have one value displayed in the nested repeater?

I thought it would be simpler...

Hi,

That definitely points me in the right direction. If I understand correctly I need to perform the first query, then create a join which will add the results of the...