Select from a table within a cell of another table

Question

Asked 8 years, 5 months ago

Viewed 299 times

2

In the SQL SERVER 2012 it is possible to construct a table that in one of its columns contains the result of another table?

The master key would be the reference.

Not like this, but it might be keeping one array in the column, separating the results by comma maybe.

– Diego Souza

2016/02/01 at 19:29
1

You need this to present the result in some report?

– cantoni

2016/02/01 at 19:35
Yes @Cantoni, need for a report.

– dHEKU

2016/02/02 at 11:24
@I believe you’re mixing the responsibilities. This kind of thing you need should be solved in the view (report, HTML, etc). SQL should only provide the data and not format it the way the user wants to view it.

– cantoni

2016/02/02 at 11:29
Thanks @Cantoni, I was really thinking yesterday and what needs to be done is in php, do a routine inside. What’s the best thing to do with the question? Close?

– dHEKU

2016/02/02 at 11:30
That’s it. Solve it in another layer. On the question, I’ll signal you and the moderators will do something.

– cantoni

2016/02/02 at 11:34

No answers

You are not signed in. Login or sign up in order to post.