SQL Query

[former_member269992]

Hello All,

Can anyone please help me to understand the meaning and effect of following query.

Declare @FG_PART_No varchar(50);

SET @FG_PART_No = (SELECT T0.[ItemCode] FROM OITM T0 WHERE T0.[ItemCode] = [%0]);

EXECUTE FINDCHILDS @FG_PART_No , 1 , 1 ,  @FG_PART_No ,

    '1' , 1 , @FG_PART_No, 1;

.

Thanks & Regards,

Hitul

[kothandaraman_nagarajan]

Hi,

You are executing FINDCHILDS stored procedure by by declaring FG-Part as varchar and selecting value from OITM table for this declared variable.

Thank you.

[frank_wang6]

The first part basically will allow you to choose item code.

It actually has no other effect.