Thanks for your help. It works perfectly 🙂

Hi,

I have used Pivot query but since I need to get values from MsgType field which is varchar, I am unable to get the desired result. Below is the query...

Thanks .. this is what i was looking for..

yes. I want it the same way because this must be a common function returning a table.

eg:

@array varchar(max),

@RowDelim varchar(10),

@ColDelim varchar(10)

I will pass the values to the above parameters...

actually i am passing this as a parameter from ASP.net application as a string and then in the Stored Procedure, i want to split the string and return a table,...

In the 1st step of the Job, i have written this code, with TYPE as Active X Script.

CheckFiles()

Function CheckFiles()

Set objFSO = CreateObject("Scripting.FileSystemObject")

File1 = "\\136.51.141.167\temp\SCM.csv"

File2 = "\\136.51.141.167\Test\HOST.csv"

File3 = "C:\SCMExports\RELATIONSHIP.csv"

File4 = "C:\SCMExports\SVC.csv"

File5...