Skip to main content

Select multiple rows data then show in one row

Select multiple rows data then show in one row
this is how to do that :

select DATA=stuff((
select top 2 '/' + supplierpicname
from TABELSUPPLIERCONTACT
where supplierid = 'SUP006' for XML path('')),1,1,'')


select DATA=stuff((
select  top 2  ' / ' + supplierpicname
from TABELSUPPLIERCONTACT
where supplierid = 'SUP006' for XML path('')),1,3,'')

Comments

Popular posts from this blog

Pop Up message Visual Studio "The operation could not be completed. The process cannot access the file because it is being used by another process"

Run your Visual Studio as Administrator account

Create Comment As .xls In Farpoint Spread

  Private Sub TAGS_PARENTING()         Dim DTPopUp As New DataTable         With DTPopUp             .Columns.Add("SEQ", GetType(String))             .Columns.Add("QTY", GetType(String))             .Columns.Add("ETD", GetType(String))             .Columns.Add("ETA", GetType(String))             DTPopUp = MePostab_Control.Cari_TAG_PARENTING         End With         With FPPOSTAB             For GG As Integer = 0 To .ActiveSheet.RowCount - 1             ...