show (value1,value2) in one column in sql

By -

declare @edition varchar(100)

 

select @edition = STUFF((SELECT  '/' + newspaperedition FROM ADVT_REQUEST INNER JOIN  NEWBILL ON ADVT_REQUEST.RO_CODE = NEWBILL.ROCODE
   INNER JOIN MRADDRESS ON NEWBILL.NP_CODE = MRADDRESS.np_code WHERE New_ROCode = '1137/13/64/2021/71753/31/3'
        FOR XML PATH('')), 1, 1, '')

Comments

Post a Comment

Popular posts from this blog

Difference between Byte and Char in Oracle

By -
If you define the field as VARCHAR2(11 BYTE), Oracle will allocate 11 bytes for storage, but you may not actually be able to store 11 characters in the field, because some of them take more than one byte to store, e.g. non-English characters. By defining the field as VARCHAR2(11 CHAR) you tell Oracle to allocate enough space to store 11 characters, no matter how many bytes it takes to store each one. I believe that in Oracle 10g, 3 bytes per character were used.
Read more

How to change value on selection of dropdown list control in datagid

By -
How to change value on selection of dropdown list control in datagrid. // drpmodify is dropdown list. protected void drpmodify_SelectedIndexChanged(object sender, EventArgs e) { DropDownList list = (DropDownList)sender; TableCell cell = list.Parent as TableCell; DataGridItem item = cell.Parent as DataGridItem; DropDownList index = (DropDownList)item.Cells[10].FindControl("drpmodify"); DropDownList drpmodify12 = null; drpmodify12 = (DropDownList)index; TextBox txtupdate = null; txtupdate = (TextBox)item.Cells[11].FindControl("TxtUpdate"); if ((drpmodify12.SelectedValue == "N") || (drpmodify12.SelectedValue == "M") || (drpmodify12.SelectedValue == "NE") || (drpmodify12.SelectedValue == "DU") || (drpmodify12.SelectedValue == "D") || (drpmodify12.SelectedValue == "I")) { txtupdate.Text = ""...
Read more
By -
Solution to error - String was not recognized as a valid DateTime.                                                       or  Conversion from string "29/04/2020" to type 'Date' is not valid Save date in SQL DB Dim requestdate As String             requestdate = DateTime.ParseExact(txtfrom.Text, "dd/MM/yyyy", Nothing).ToString("yyyy/MM/dd") comm.Parameters.AddWithValue("@req_date", requestdate)
Read more