Hi,

The above is duplicated code.

I have identified that the below code is taking the time for the same as multiple recursion is going on as 1 transaction has multiple dependency.It...

• This reply was modified 4 years, 7 months ago by  vikramchander90.
• This reply was modified 4 years, 7 months ago by  vikramchander90.

STRING_AGG is not supported in SQL 2016. Getting error STRING_AGG is not a built in function. Is there any other option for SQL 2016 please.

As when checked STING_AGG is supported...

Thanks will check

Ok will check... But it appears to be from 2017 and my server still has 2016 sql

Can you please share the query used to get that ouput.. after the update statement getting output as

1 D1

2 D1

3 d6

Hi,
      Thanks for your help!!!!

      Yes using SQL Database mail only.  I will check the same and let you know for issues if any.

Thanks that worked!!!.   It was for a report output and not storing data.

Can you suggest what to change? Or another lock that can be used?

This is the SP which i am using.... I added with rowlock to check but duplicate no is generating for about 5 people when 18 users access simultaneously. The table...

Hi,

Can any 1 help to find if this solution is possible.

Keep the header as a separate file and use BCP / Openrow set to append data into that file?

Ok thanks Taylor. Will check and revert.

Is there any other command available to generate Excel file without throwing that error message?

Hi Jeff,

Sorry for late reply and thanks a lot for your reply. Your solution worked out perfectly which helped reduce from hours to seconds. Thanks a lot.

Hi Jeff,

I made a small change to ur query as for row no 0 the debit column and credit column will be NULL.

This data is similar to the...

No issues Jeff. Thanks for your help.