Hi am nagesh,
i have client and service programs developed, am trying to pass byte array (which is generated by converting image to byte array) to service method. but i giving an below error
"The remote server returned an unexpected response: (400) Bad Request".
CREATE FUNCTION [dbo].[Split](@LocationIds varchar(8000), @seperator char(1))
returns @temptable TABLE (ids int)
as
begin
declare @idx int
declare @slice varchar(8000)
select @idx = 1
if len(@LocationIds)<1 or @LocationIds is null return
while @idx!= 0
begin
set @idx = charindex(@seperator,@LocationIds)
if @idx!=0
set @slice = left(@LocationIds,@idx - 1)
else
set @slice = @LocationIds
if(len(@slice)>0)
insert into @temptable(ids) values(@slice)
set @LocationIds = right(@LocationIds,len(@LocationIds) - @idx)
if len(@LocationIds) = 0 break
end
return
end