myID myVal minTic maxTicticCount
---- ------ --------- --------- ---------
1 A 0.20 1.500.1
2 B 1.00 1.001
if object_id('tempdb..#tmpValues') is not null
drop table #tmpValues
create table #tmpValues
(
myIDtinyintidentity(1,1),
myValvarchar(10),
minTicnumeric(5, 2),
maxTicnumeric(5, 2)
)
insert #tmpValues( myVal, minTic, maxTic )
select 'A', 0.2, 1.5
union
select 'B', 1, 1
select * from #tmpValues
if object_id('tempdb..#tmpValues') is not null
drop table #tmpValues
========================================
Output required ::
myID myVal minTic maxTicticCount
---- ------ --------- --------- ---------
1 A 0.20 1.500.1
2 B 1.00 1.001