i checked my version.Please find the details.

select @@version

Microsoft SQL Server 2014 (SP1-CU13) (KB4019099) - 12.0.4522.0 (X64) Jun 28 2017 17:36:31 Copyright (c) Microsoft Corporation Standard Edition...

Thank you.Working fine.

SELECT V1.F_PRODUCT,
  F_TEXT_CODES = STUFF((SELECT DISTINCT TOP (1000000)',' + V2.F_TEXT_CODE FROM first_view V2 WHERE V1.F_PRODUCT = V2.F_PRODUCT ORDER BY V2.COUNTER1 FOR XML PATH('')),1,1,''),
  F_PHRASES = STUFF((SELECT...

I tired  the ORDER BY before FOR XML but it is showing error message.

it is showing error message varchar is not  recognized built-in function name.

DDL COMMANDS
CREATE TABLE [dbo].[PRODUCT_TEXT]
(
[Product] [nvarchar](50) NOT NULL,
[Format] [nvarchar](3) NOT NULL,
[Text_Code] [nvarchar](8) NOT NULL,
[F_Date_Stamp] [datetime]...

Not able to understand your question.please explain.

It is working fine.But it is also required two queries.Instead of ProductCodes table i am using the view(v1) and using your query i am taking records from that view(V1).so the query...

i am using sql server 2014 so it is showing 'STRING_AGG' is not a recognized built-in function name.
Any other method or way to achieve this?

view will be faster then table?.Please suggest.so that i can avoid second table.

The main table T_pdf contains millions of records,so we created another one table and moved some required records into another table(T_WV_RESULT).View will be faster then table? because view does not...