sql server limitation for row data length

[Former Member]

we are facing a challenge while creating UDF in SAP B1 - sql server limitation for row data length (8KB)

Has anybody faced such problem before and is there a solution / work around for this problem.

Please require an urgent help.

Thanks and Regards,

Ashutosh

7838432014

[former_member188958]

The common solutions include

1) storing some of the data in text/image columns

2) moving some of the columns to another table

3) splitting the data across multiple rows using a "sequence number" column to order them.