declare @i int,@T smallint
select @i = 20100101
Select @T=1900
select dateadd(minute,@T%100,(dateadd(hour,@T/100,
CONVERT (datetime,convert(char(8),@i))
)))
try this
Edited to say that I am now confused so I am leaving initial attempt in here, but might not work anymore.
Thought we were trying to concatenate int date and int time into a date time.