Q&A for people looking to improve their interpersonal communication skills
declare @time table (Zone varchar(200),Times varchar(200)) declare @toronto datetime,@india datetime,@hongkong datetime insert @time SELECT 'India -',dateadd(mi,330,getdate()) insert @time SELECT 'HongKong -',dateadd(mi,480,getdate()) insert @time SELECT 'Canada -',dateadd(mi,-240,getdate()) select Zone+' '+Times Time from @time