How to split comma separated value in SQL server :
----- Approach 1: Common Table Expression (CTE) ----- Lets call this function as Split2. here we are using
CREATE FUNCTION dbo.Split2 ( @strString varchar(4000))
RETURNS @Result TABLE(Value BIGINT)
AS
begin
WITH StrCTE(start, stop) AS
(
SELECT 1, CHARINDEX(',' , @strString )
UNION ALL
SELECT stop + 1, CHARINDEX(','...
Thursday, November 16, 2017
Monday, February 27, 2017
How to get odd/even value from array and display in table using Javascript
var dataArr = ["1","Maths","2","Science"];
Add a bare bones table to a div.
$("#subjectTable").append('
');
For each table row loop over the array in steps of 2 (i+=2). oddPositionVal is the first element in the step, evenPositionVal is the second element.
Build the row HTML and then append it to the table.
for (var i = 0, l = dataArr.length; i < l; i+=2) {
var oddPositionVal = dataArr[i];
var evenPositionVal = dataArr[i + 1];
...
Subscribe to:
Posts (Atom)
My Blog List
-
-
-
-
Kumaon University Nainital B.Ed entrance exam test result 2012 - कुमाऊँ विश्वविधालय, नैनीताल (उत्तराखण्ड)11 years ago
