Sunday, February 19, 2012

Column Expressions?

Is there any way to use User Defined Functions
in a column expression?

Hi,

Could you please be more specific? It's too vague to guess.

|||

Sure:

in the column expression you can do this:

SUM(parent(someRelationship).SomeNumericField)

I would like to do this:

StringConcat(parent(someRelationship).SomeTextField)

In the above 'StringConcat' would be an
aggregate method that I would define.

Thanks.

|||Off topic for Windows Forms General, moved to SQL Server Database Engine forum.
|||This really has nothing to do with the SQL Server database engine.
I'm not sure why it was moved. This question has do with datasets,
more specifically dataTables and their column definitions.|||

Somewhat of an answer can be found here

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=668775&SiteID=1

No comments:

Post a Comment