- About us
- Services
- Skills
- Web Development
- ColdFusion Development
- SharePoint Development
- Classic ASP Development
- ASP.NET Development
- Modern ASP .Net Development
- DotNetNuke Development
- Java/JSP/servlets Development
- Python Development
- PHP Development
- Perl Development
- Ruby on Rails (RoR) Development
- Lasso Development
- Real Basic Development
- Google API Integration Services
- Mobile Development
- Database & Client server Development
- Plug-in Development
- Reports/BI Development
- Automated Testing
- QA/Testing Skills
- Domain-based Testing
- E-Commerce Development
- CMS Development
- Desktop Development
- RIA Development
- App-based development
- Salesforce Development
- SugarCRM Development
- Dynamics GP GreatPlains development
- Dynamics SL Solomon development
- Microsoft Dynamics CRM Consulting Development
- Dynamics RMS development
- LiveCycle development
- QuickBooks development
- Drupal development
- Joomla development
- Typo3 development
- Magento development
- Dolphin social development
- Others
- Web Development
- Industries
- Knowledge
- Process
- Models
- Clients
- Career
| |
Software Technology Tips
The following approach can be helpful while showing multiple columns(',' seperated) in a single row of a grid for a particular value.
SELECT Column1,Column1,
--Column for which you need ',' seperated values State = substring(EL.ORDER_list, 1, datalength(EL.ORDER_list)/2 - 1) from Table1 c
cross apply
(select state + ',' as [text()]
from Table2
where Condition
FOR XML PATH(''))
EL(ORDER_list)
|
||||||
Output
|
Related Tags:
Database, SQL Server
Author: Manish Tiwari
Database
- Use of cross apply to show ',' separated values(SQL Server)
- MYSQL:Ordering A TextField Numerically
- How to select Random rows in SQL Server using TABLESAMPLE
- How to add dynamic data in to the SQL Report header and footer
- How To Set Page Break in a report Conditionally
- MySQL: Filter or Search Records Using Regular Expression
- MSSQL-Insert records for columns where IDENTITY is set
- Forming Comma Separated String in SQL Server
- How to create folders in SQLReport server dynamically ?
- Get database connection string using UDL files
- How to INSERT, UPDATE or DELETE record in one statement
- SQL Server : Multiple record insert
- Making Inserts into from one table to another table excluding duplicates - without using cursor / temp table/ loop
- New Line character and Forming a comma Separated String in SQL Server
- SqlServer Query Optimization Tips
- MySQL : Exporting The Resultset of a Table into CSV File
- MySQL: How to get the Particular Data Range
- Transact-SQL :- ROW_NUMBER()
- Deleting Duplicate records in SQL Server
- How to backup and restore MySQL database.
- More Related Tips
