Hello Jeff

Many thanks for all the documentation that you send me and your useful advise.

I will try the scripts to see which one fits best what I intend to do,...

Hello Steve,

Thanks for your reply.

Best regards,

Luis

Hello Steve,

Many thanks for your great explanation an examples that you send.

I plan to use hierarchies to classify my accounting chart of accounts. I am using Power bi to create...

Hello Scdecade,

Many thanks for your reply and also the last consideration that you have post.

I understand your concept and the same work like great.

Many thanks,

Best regards,

Luis

Hello Scdecade,

this is work, but this is not the problem that i need to solve.

in pratice, if on first line i have a remain value, then when i calculate the...

Hello Jeff,

Many thanks for your  coding  and comments on it.

I will go to make some test with it.

Many thanks,

Best regards,

Luis

Hello Jeff,

Thanks you to reply to my post.

In this case i have always 2 digits on either side, but  thanks for asking if I will always have 2 digits before...

hello Phil

I have no words to thank you, without your help it would have taken too long time to solve this challenge of mine.

Thank you so much for your great...

Hello community,

Phil send me this excellent code and I solve Part1.

but on Part 2 of my question i want to create a sequence between [FirstChar] and [LastChar] for each ref...

Hello Phil,

thank you very much for the reply and thank you when you have a little time, if you can help me solve the second part because this will be...

Hello Community,

I try using another technique to querying the XML File that i find in: https://www.red-gate.com/simple-talk/sql/database-administration/ad-hoc-xml-file-querying/ and post by Seth Delconte.

I use the Microsoft Xml file and i...

Hello Lynn

Sorry you are right.

DECLARE @Stamp AS VARCHAR(25) = 'ADM19062261955,812000001'
DECLARE @XML XML = N'';
DECLARE @XMLSTR NVARCHAR(MAX) = N'';

SELECT
@XML = (SELECT
(
SELECT 
memissao AS [OrderHead/OrderCurrency/Currency],
bo.obrano AS [OrderReferences/BuyersOrderNumber],
bo.dataobra AS [OrderDate],
bo.nome...

Hello community,

Sorry, please forget thi Post , i solve it .

Many, thanks,

Luis

Hello communty,

Thanks but i solve my problem like this :

;WITH CTE

as(

select distinct ft.ccusto,

sum(ft.ETTILIQ) OVER(partition by ft.ccusto order by ft.ccusto) [Total],

SUM(ettiliq-ECUSTO)...

Hello community,

maybe to understand better, what I need is to return the grand total for each line independently of the family.

Do you have any suggestions for doing this?

Thanks,

Luis