///////////
Declare @Cols varchar(max)
SELECT @Cols = STUFF(( SELECT DISTINCT '],[' + LocationGUID from mstLocation where [Type]='WQ' ORDER BY '],[' + LocationGUID FOR XML PATH('')), 1, 2, '') + ']'
select @Cols
Subscribe to:
Post Comments (Atom)
Excel Sort values in ascending order using function TEXTJOIN
Excel :: Text :: 1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula :: TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...
-
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using... -
//////////////////////////////////////////////// Fusion fusion chart js Step 1. Generate fusion chart Step 2. Set a Java-script... -
//////////////// Step 1. Goto >> Control Panel >> Programs and Features >> Visual Studio --Version >> Chang...
No comments:
Post a Comment