October 3, 2007 at 6:49 am
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
October 3, 2007 at 6:58 am
How do you know how to get the count?
N 56°04'39.16"
E 12°55'05.25"
October 3, 2007 at 7:07 am
there is no such parameter or value from which i know the output.
October 3, 2007 at 7:09 am
Let me rephrase that...
How do you know the count is 1 for both records?
N 56°04'39.16"
E 12°55'05.25"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply