So Jeff, what do you think which solution is the better solution and do you have a better one yourself?

You are right, the problem with using ROW_NUMBER slows everything down....

One way is to insert the needed data into a temporary table.

DECLARE @t TABLE(

customer1 varchar(25),

customer2 varchar(25),

customer3 varchar(25)

)

insert into @t

select 'SMITH','JONES','WILSON' union all

select 'EDWARDS','SMICKS','SMOKES' union all

select 'SMITH','TODD','HELP'

DECLARE @Results TABLE(

Customer...

The code has on the main page has been corrected. There was a problem with the code submittion tool that is used to publish

script code. Somehow the code...

You have described your problem, but a solution is still hazy, as I need to see what the actual data looks like. Please post a sample table, with test...

Grant that solution you posted is almost identical to the one I use :). I use a different formula to calculate page number, but the same principals exist.

SET @pgNbr...

I would go with the Row_number option.

It seems when I posted using the web tool, the spacing for the code was altered, among other things. :angry:

Does anyone know why this is?

Thanks.

Adam

Something happened to the code when I posted it on the site.

This code works:

/****** Object: StoredProcedure [dbo].[usp_New_Game] Script Date: 02/23/2008 16:35:24 ******/

IF EXISTS (SELECT *...

What syntax errors are you getting?

I have incorporated some logic that can only be used in 2005,...

Okay. Keep us posted.

thanks. But this query works only to modify one column. I need the query to modify more than one column at a time. Please send me the query to do...

Based on the sample data and the description you provided. You should be able to mold your query like this.

declare @t table(

OH_DOC_TYPE varchar(25),

OH_DOC_NUM INT,

OH_PO_NUM INT,

OH_SUPP VARCHAR(25),

OH_SRC_QJNUM INT,

OH_ORDER_VALUE SMALLMONEY,

OH_ORDER_LINES VARCHAR(25)

)

INSERT...

Andy,

Post your table definition, with some sample data, and we can work this out.

Thanks.

Hi GSquared,

Thank you for your input. I am currently working with a tutor on the finer points before I go fo certification.

She and I were discussing this very same...

You have a few choices here: The two best being an UDF and the other being XML.

You can get more information from the following thread. Additionally, Jeff has...