Combining Two Rows in to 1Row
-
Good day Experts,
How can i combine these two rows into one in sql .So i want it to be one row.
Many thanks
- This topic was modified 9 months, 1 week ago by tmmutsetse.
- tmmutsetse wrote:
Good day Experts,
How can i combine these two rows into one in sql .So i want it to be one row.
Many thanks
Sorry... not seeing any "sample data" on your post.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Like Jeff, I can't see anything.
I'd suggest looking at a process called PIVOT? Might help. Can't know. Just guessing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Never mind. I see you've asked this question in multiple locations. Please, don't do that. It just splits up the conversation. Let's all agree to meet at this one where you already have some suggestions.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply