Hi Steve

Thanks for that. But i still cannot find anything? Can you help please?

Thanks Kenneth for the prompt response. I am using sql sever 2000. Sorry for my ignorance, but what is BOL and where can i find it?

I am trying to incorporate my query but using this function

CREATE PROCEDURE crosstab

@select varchar(8000),

@pivot varchar(100),

@sumfunc varchar(100),

@table varchar(100),

@where varchar(1000)='1=1'

AS

DECLARE

@sql varchar(8000), @delim varchar(1)

SET NOCOUNT ON

SET...

Thanks for the response. I have seen all the code used but some how i cannot get it to execute the command i want? Any idea's on how i...

Hi

Thanks for the response

My input table contains the following

SUBURB price_band institution SumOfSumOfBOND_AMOUNT

EASTERN CAPEB. R100k - R250k ABSA ...

Hi Guys

I need help desperately. My problem is also the Pivot functionality in sql server 2000

I am trying to convert my Access sql to server. My access code is

TRANSFORM...