Something like this?

select *,

       case

           when logindate = logoutdate then datediff(ss, loginzeit, logoutzeit)

           else datediff(ss, 2 + logindate + loginzeit, logoutdate)

       end 'From Date Work Seconds',

       case

           when logindate...

The first problem I see is that you must look for both Honors table and LoginLogout table for which kind of day to use.

You should consider having ALL rules in...

Here is just the sample data modified to be inserted into a table variable for further development by everyone.

See Last Post!

Can you provide some sample data here, da nicht alle gutes Deutsches sprechen.

Zeit is "time"

Iron clad?

-- prepare test data

declare @test-2 table (t varchar(50))

insert @test-2

select 'ov1' union all

select 'ov2' union all

select 'ov4' union all

select 'ov31' union all

select 'ssss1' union all

select 'ssss99'

-- show data before...

http://www.bluechillies.com/list.html?k=pl/sql+to+tsql

http://www.softhypermarket.com/SwisSQL---Sybase-to-Oracle-Migration-Tool-download_27268.html

Thanks.

What happens when ObligationNo is equal to, say "This is a number" ?

As the question is written in the original posting, I am assuming that the client application is sending the list to the database. Hopefully the programmer of the client application...

Also it is true that ISNUMERIC accepts currency symbols and not only tabs, spaces, plus/minus sign and decimal point that David pointed out earlier.

See this code

declare @test-2 table (item...

Yes, there is a better way as Jeff writes.

select     csuflxideb,

           csddedcode,

           csddeds2code

from       checksumm

inner join checksummded on csuflxid = csdflxidcsu

where      csupayperiod like '2005%'

group...

Why use XML and use additional resources from SQL Server when not needed?

WTF?

For this you need dynamic SQL.

CREATE PROCEDURE Test

(

    @List varchar(50)

)

AS

    DECLARE @sql VARCHAR(1000)

    SELECT @List = REPLACE(@List, '"', CHAR(39))

    SELECT @sql = 'SELECT * FROM Types WHERE Type IN ('...

insert textfile into temporary table. run check against temporary table. then insert data into the other tables you need to.