Viewing 15 posts - 2,071 through 2,085 (of 2,171 total)
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...
June 19, 2006 at 2:59 am
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...
June 19, 2006 at 2:33 am
June 19, 2006 at 2:20 am
Here is just the sample data modified to be inserted into a table variable for further development by everyone.
See Last Post!
June 19, 2006 at 2:07 am
Can you provide some sample data here, da nicht alle gutes Deutsches sprechen.
Zeit is "time"
June 19, 2006 at 1:45 am
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...
June 17, 2006 at 11:57 am
What happens when ObligationNo is equal to, say "This is a number" ?
June 16, 2006 at 6:57 am
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...
June 16, 2006 at 2:58 am
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...
June 16, 2006 at 2:36 am
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...
June 16, 2006 at 2:18 am
Why use XML and use additional resources from SQL Server when not needed?
June 16, 2006 at 1:34 am
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 ('...
June 15, 2006 at 11:01 pm
Viewing 15 posts - 2,071 through 2,085 (of 2,171 total)