I have table data like
data1 data2 data3 data4
and I need to select these rows like this:
data1 data1 data1 data1 data2 data2 data2 data3 data3
and how to perform this in SQL Server 2005?
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.
You haven't explained why you need SQL Server to do this multiplying out of rows rather than your application. You are quite possibly asking the wrong question.
You can do this With an auxiliary table of numbers though.