Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
3
Answers
User Defined Function in sql server.
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Srikanth Reddy
9y
733
1
Reply
Hai Friends,
I am having a table as follows:
ID Row1 Row2
1 a 20
2 b 12
3 c 16
4 a 11
5 a 10
6 c 18
7 b 15
When we pass "a" from "Row1" in a query, we should get the output as follows:
ID Row1 Row2
1,4,5 a 20,11,10
I should get it by using functions(UDF's).
I have tried a lot friends, but unable to get the solution.
Please any one provide me solution for this.
Thank you.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
if a record exists in the table, run a procedure
Copy database from sql express to sql server 2008