Forum Replies Created

Viewing 15 posts - 16 through 30 (of 37 total)

  • RE: Help with a query.

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

    thanks.

  • RE: Help with a query.

    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 @c =1

    DECLARE @cols...

  • RE: Help with a query.

    I tried with this:

    SELECT @cols = STUFF(

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

    FROM @data AS CPA...

  • RE: Help with a query.

    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 @c=@c+1

    END

    SET @colstotal=SUBSTRING(@colstotal,1,LEN(@colstotal)-1)

    print @colstotal

    how do I select...

  • RE: Help with a query.

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

  • RE: Help with a query.

    Thanks to all,

    this query can execute with -while statement-?

  • RE: Help with a cursor

    if that have 3 upgrades of 4 records,

    how do I insert the record was not updated??

  • RE: Help with a cursor

    Sorry, the SQLSERVER it's 2005.

  • RE: tsql - xml question

    Thanks,

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

    it's possible?

  • RE: Help with a Select statement

    Hi!

    this help?: Result Output.[/url]

  • RE: Help with a Select statement

    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'...

  • RE: Help with this UPDATE

    Yes,

    Thanks!

  • RE: Help with this UPDATE

    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...

  • RE: choose a random record

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

  • RE: choose a random record

    Hi,

    thanks!

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

Viewing 15 posts - 16 through 30 (of 37 total)