Hello Luis

I perform This operation one time for this reason and after sending data to historic database when i keep olders years.

This database is exactly like the same that the...

Hello Sean

Thanks for your reply, also what you recomend to shrink, SSMS, or do you know some good script to execute This operation ?

In fact, i always rebuild all indexes...

Hello John

Thanks for your reply.

I agree that using any reporting tool or SSRS is much easier, but in this case I have a tool that turns a SELECT statment into...

Hello Scott

Thanks, that is exactly what i need.

I need to read with more attention all the kind of JOIN, because i forgot some of them.:-)

Best regards,

LSantos

Hello Drew

I read the STUFF function on SQL server, i now that´s work great.

Many thanks for your help.

Best regards,

Lsantos

Hello Drew

This is exactly what i need, but curiously the keyref are not correct, this is the result:

[Code="other"]

ref base qttbaseCOS ...

Hello Sean

First, thanks for links that you send me.

In fact maybe my explanation is a little confused.

I will go to try explain better.

First, forget splitting string with comma delimiter because...

Hello again

Many thanks for all YouTube suggestions, now i will go to try each of them.

Best regards

Luis santos

Hello Eirikur Eiriksson

thanks for your reply, but what i need is only return information for the same Cabstamp+document where origin is different and not all the rows.

Many thanks,

LS

Hello

Thanks for yours reply they work fine.

Best regards

Luis Santos

Hello Steve

I solve the problem changing your Query:

[Code="sql"]

SELECT td.ndoc, td.nmdoc,

CASE

WHEN td.ndoc IN (1, 26) THEN 'Sede'

WHEN td.ndoc IN (30, 39) THEN 'Store Beira'

WHEN td.ndoc IN (83, 84) THEN 'Store Maputo'

WHEN...

Hello Steve

First , thanks for all your precious advises, but running the query the result don´t return any records.

Maybe i´am not explain correctly what i need, because on this...

Sorry Guys

I solve the problem like this:

ALTER FUNCTION VerificaAcessoPerfil

(

@codigo INT

)

RETURNS INT

AS

BEGIN

...

Hello again

Thanks for your reply, this is exactly what i need.

Best regards,

Luis Santos

Hello

Sorry but i don´t understand your answer.

What i can do is possible, i need rounding numbers in multiples of 0 and 5 in sql server, independently of decimal values.

Thanks

Luis Santos