Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need Help ! Expand / Collapse
Author
Message
Posted Wednesday, October 3, 2007 6:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:03 AM
Points: 1,154, Visits: 866
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
Post #406154
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse