Database

<pre>
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 

khaliloenit wrote:

I must have a sql or batch script

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

@ECHO OFF
FOR /F  %%i IN ('sqlcmd -S YourDBInstance -Q"set nocount on;select  CONVERT(DECIMAL(10,2),FVersion) from TVersion"') DO SET VNO=%%i

call .\v%VNO%\script.bat
@echo done.

Jörgen Andersson wrote:

without using procedural code

Mycroft Holmes wrote:

can't see the PK field

Jörgen Andersson wrote:

m going to try to do it using a recursive CTE.