By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,934 Members | 1,476 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,934 IT Pros & Developers. It's quick & easy.

Combining two row values of a same column into one

P: 2
I have a select statement like Select weekdayoff from Weekday which returns me Saturday and Sunday, I want to select the values as Saturday & Sunday in a statement.
Mar 8 '08 #1
Share this Question
Share on Google+
1 Reply

Brad Orders
P: 21
The most efficient way would be to do this at the code level rather than the database level. Doing this kind of query at the database level will be slow and can be a bit messy.

If you are using .NET, you could the stringbuilder object, and loop through the results from the database.

Mar 9 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.