Jeff I did not perform any scientific research on this 🙂

I just took your code compiled it on the server

and run it side by side with what I...

Hi Jeff,

nice splitter function thanks.

I run it against some of my data and it works consistently faster than the one I have.

not by much, about 13 to 16 milliseconds...

will do , thanks

ok.

I am not sure but there might be a way to use that in SQL

google SQL extended stored procedures

however this is a deprecated future and will not be available...

hi I found this function somewhere on web and it have been very helpful 🙂

just run it on your DB and you can always reference it from anywhere

/*

SET...

true but you have to still go from end to start like to get proper result 🙂

set @SeenDate = '2011-10-31'

set @RequestDate_3 = '2011-03-26'

set @RequestDate_2 ...

quick note here

if I understand your requirements

you want to calculate datedif() form either of the 3 fields

in order like so

if(field3 is not NULL) take DateDif () ...

sorry a typo, I ment UDF

the code for the function that does formating

as far as I understand that should be more or less normal SQL code (right?)

just want to...

thanks bucket,

happy to report that I solved this my self.

it was a datafile issue, first row were missing a column.

as for attachment... well next time I will post everything in...

you can maybe use something like this to get all the files

and them process therm in a loop

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure [dbo].[GetFilesToProcessList]

as begin

EXEC master.dbo.sp_configure 'show advanced...

hi, if it would not be a big problem can you post the

UTF from firebird here,

I would really like to see what it actually does...

as it was said before,...