Here is another solution

DECLARE @test-2 table

(

tstval varchar(30),

sortorder as case charindex('.', tstval)

when 0 then tstval

else substring(tstval,1,charindex('.', tstval)-1) + '.'+ REPLACE(substring(tstval,charindex('.', tstval) + 1, LEN(tstval)),'.','')

end

)

insert into

Will it work in multiuser environment???

select

IsNull(firstName+ ' ','') + IsNull(MiddleName+ ' ','') + IsNull(LastName,'') as Name,

CASE E.Id

WHEN -1 THEN "Games Missed"

WHEN 13 THEN "Desc for 13"

WHEN 14 THEN "Desc for 14"

WHEN 15 THEN "Desc for...

select

count(lbd.his_user_id)

from

#LBD lbd INNER JOIN #TIT tit ON

lbd.his_user_id = tit.his_user_id

AND

convert(varchar(10), lbd.schedule_start_date, 101) = tit.date

AND

tit.ID_Num = 1

WHERE

lbd.schedule_start_date >= '4/4/2006' AND

lbd.schedule_start_date = .80)

select

IsNull(firstName+ ' ','') + IsNull(MiddleName+ ' ','') + IsNull(LastName,'') as Name,

CASE E.Id

WHEN -1 THEN "Games Missed"

WHEN 13 THEN "Desc for 13"

WHEN 14 THEN "Desc for 14"

WHEN 15 THEN...

Create a format file using bcp and use the same in ur BULK INSERT

I can help you if you could send me the code that you have used for trigger?