Viewing 3 posts - 1 through 3 (of 3 total)
arun.sas (6/3/2010)how to restrict the rows having the decimal values in the columnB in the select clause of the above table?select * from @test-2where round(col2,0)- col2 = 0.00
arun.sas (6/3/2010)
how to restrict the rows having the decimal values in the columnB in the select clause of the above table?
select * from @test-2
where round(col2,0)- col2 = 0.00
Worked...
June 3, 2010 at 11:46 pm
#1176333
Thanks for the reply.
But I want the data from the table3 and not from table1.
May 27, 2010 at 4:42 am
#1173227
Never mind, I have added the additional information required in the header and footer of the worksheet and it is working fine.
Thanks!
April 20, 2010 at 6:53 pm
#1155041