Database

JM76 wrote:

Please take a look to the following image

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

JM76 wrote:

I don´t understand what have to do.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

<Authentication>
    <AuthenticationTypes>
        <RSWindowsBasic/>
        <RSWindowsKerberos/>
    </AuthenticationTypes>
    <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
    <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
    <EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>

PIEBALDconsult wrote:

Now you've cross-posted.

Select *
From Table T
inner join fn_Split(@List,',') l on L.item = T.FieldName

ALTER   FUNCTION [dbo].[fn_Split]
 (@List  varchar(8000), @Delimiter char(1))

RETURNS @Results table
 (Item varchar(8000),ID int Identity(1,1))

AS

begin
 declare @IndexStart int
 declare @IndexEnd int
 declare @Length  int
 declare @Word  varchar(8000)

 set @IndexStart = 1
 set @IndexEnd = 0

 set @Length = len(@List)
If @Delimiter = '' Set @Delimiter = ','

--Get rid of any tabs or returns
Set @List = Replace(@List,char(9),'')
Set @List = Replace(@List,char(10),'')
Set @List = Replace(@List,char(13),'')

while @IndexStart <= @Length
begin
	set @IndexEnd = charindex(@Delimiter, @List, @IndexStart)
		
	If @Delimiter = char(32) 
		set @IndexEnd = charindex(Space(1), @List, @IndexStart)

	if @IndexEnd = 0
		set @IndexEnd = @Length + 1

	set @Word = substring(@List, @IndexStart, @IndexEnd - @IndexStart)
	set @IndexStart = @IndexEnd + 1

	INSERT INTO @Results(Item)
	SELECT @Word
end

return
end