Hello Chris,

Great idea and example 🙂

it´s the first example with Cross Apply and separate decision logic that i saw, i will go to test it.

Many thanks for your reply.

Best regards,

Luis

hello Mike

I send in attach the entire script to create temp tables with data, i hope don´t forget any field.
i send you my function above : [dbo].[FnPesoTransporte](fo2.u_tstamp)[Peso]...

Hello Mike01

You ´r right , i will go to create DDL script for all tables and fields that i use on my Query.

Thanks
Luis

Hello Drew,
Thanks for your reply.
1) You don't want to filter your CTE. The filtering will take place later when you link to the BO table.
     ...

Hello again Drew,

I solve the 2 problems with some modification, like this:

;
WITH bii
AS
(SELECT
        *
     ,ROW_NUMBER() OVER (PARTITION BY bi.bostamp ORDER BY...

Hello Drew,

Thanks for  your reply  and  your  rewrite  query , but  they  don´t return any information about lines just information of header.
Also, i need to pass @Stamp...

Hello Drew,

Thanks for your advises, i send you the script for the 3 tables only with the columns  that keep the data for my XML query.
Also, all...

Hello Drew,

my apologies, you are quite right, here are the insert to create the 3 tables with data:
Table BO :

INSERT INTO dbo.bo...

Hello Frederico,

Thanks for the reply.
I understood the answers that were mentioned that I thank you all, my question was only to assign several text values in a...

Hello Lynn,
Thanks for your reply, i need the variable because i want more than One order for muito query result and nota ONLY the order 83167.
For example :...

Hello,

Thanks  for all your replies , i will go create function to split values.

Many  thanks
LS

Hello,
Thanks for all your  replies.
tI have discovered why the CTE repeat the rn , is that because i haven´t document_Type = 'SI'.

Best regards,
Luis Santos

Hello Tom,

Sorry , my  Coding comments are incorrect, this is the correct code:

CREATE TABLE stock_table
 (document_type VARCHAR(2), document_date datetime, product_id varchar(18), qty_out NUMERIC(14,3), qty_in NUMERIC(14,3), price...

Hello,

Thansk you Luis for your explanation.

Best  regards,
Luis

Hello,
Many thanks  for all your replies.
Luis Cazares i read your example that is in fact not complex, i think that return both married and not married.
Can you...