Table Valued Function

Question

How to convert rows to column in SQL Server 2008 using table valued function?

Example:

Name: Danish; Sex: Male

convert to Male as column heading and Danish as field data.

Thanks, Danish

You mean you want to convert a string to a table? What are you asking? — Tim Rogers, Sep 07 '11 at 07:41

score 0 · Answer 1 · edited May 23 '17 at 12:06

0

Your question is really vague.

Converting rows to columns in sql server can be done with the PIVOT function. Look at the documentation on MSDN, and maybe this stackoverflow question for examples.

I fail to see what this has to do with table-valued functions

edited May 23 '17 at 12:06

Community

answered Sep 07 '11 at 08:44

jeroenh

1 Answers1