Hi,

Thnks for the reply.

But My issue is suppose webservice is having a method Insert(Employee emp). It requires input parameter of type Employee.

How can we dynamically assign SQL Task results to...

Hi,

Create a function which takes csv(coma saperated values) as input and returns all the values as rows of a table.

Function:

CREATE FUNCTION [dbo].[CsvToTable]

(

-- Add the parameters for the function here

@Csv...

Hi,

Thanks for your solution. Its really great to see a slution without using cursors as well as any loops.

The following solution also working..

DECLARE @strTemp VARCHAR(MAX)

SET @strTemp = ''

Select @strTemp...