Split Data into multiple column

Bhavesh Vankar

6y984

how to i split data into multiple column and count from date if even then "out" and odd then "in" into sql server

Data like 1001,65-215485629215,05/06/2020 10:20:03

this data is in single column and i want to separate into multiple colomn like eliid, empid date_time

if time sec in even then emp is "out" and sec is odd then "in"

please help me...

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhavesh Vankar6y ago
i have already this database and i want fetch record in separate column there is nothing about my query..sir..
i have a data like 1001,65-215485629215,05/06/2020 10:20:03 and i want to fetch out in separate mode with emp in out if even then out and odd then in..
Arvind Kushwaha6y ago
Hi Bhavesh,

Follow this link which has given step step to insert data into sql server.

https://www.c-sharpcorner.com/UploadFile/18585c/insert-data-in-sql-server-from-front-end-by-using-windows-ap/

https://www.codeproject.com/Questions/1181039/How-to-insert-data-to-ms-SQL-server-using-csharp-n

https://www.sqlservertutorial.net/sql-server-basics/sql-server-select/
Bhavesh Vankar6y ago
how to write this query in sql server i have no idea because i am begginer expain me please..
Arvind Kushwaha6y ago
Hi Bhavesh,

Please try this code.

var data = "1001,65-215485629215,05/06/2020 10:20:03";
var unqiueVal = data.split(",");

Now unqiueVal[0] will have eliid, uniqueVal[1] will have empid and uniqueVal[2] have data_time.

To check the second value in datetime.

var extractTime = uniqueVal[2].split(":");

if(extractTime[1] %2==0) {
emp = out ;
} else {
emp = in;
}

To insert into sql server check this link

https://www.guru99.com/insert-update-delete-asp-net.html