Thanks, i hope this code will get best perfomance than the another (with while statement)

thanks.

Thanks,

it work of course, but have a detail..

when in my table exists 2 values equals i just need 1

you see:

DECLARE @number int, @C INT

SET @number =9

SET

I tried with this:

SELECT @cols = STUFF(

( SELECT DISTINCT TOP (@number) PERCENT '],''0'' [' + CPA.n

FROM @data...

with this query i have the same result:

DECLARE @number int, @C INT

SET @number =9

SET @C =0

DECLARE @colstotal VARCHAR(MAX)

SET @colstotal=''

WHILE @number >= @C

BEGIN

SET @colstotal=@colstotal+'''0''['+CONVERT(VARCHAR(2),@c)+'],'

SET

what do you mean, with the clause while gonna be slow?

Thanks to all,

this query can execute with -while statement-?

if that have 3 upgrades of 4 records,

how do I insert the record was not updated??

Sorry, the SQLSERVER it's 2005.

Thanks,

that result can be export to a folder ? like "c:\config.xml"

it's possible?

Hi!

this help?: Result Output.[/url]

Hi, thanks

the rules are, just when the voucher_id='N' (i mean pymnt_separate column) are going toghether and the co_a_pagar joins in the totals final of the group by.

if the voucher_id='Y'...

Yes,

Thanks!

Hey thanks!

and if i want scan all the man_hours by id_resource of the table @spotresource and compare it with the table @spotCM_cc46311AREP how can i update the man_hours for each...

Yes, well it's a draw end of the year awards to employees..

Hi,

thanks!

but the outcome of the query needs to be a character..