Converting SQL Server to Teradata

[ek400]

I am working on a project to convert SQL Server syntax to Teradata and am using Queryman.
Here is some basic code I am trying to convert:

select cast(((select cast(count(*) as numeric) from Dimtable where StdCode is not null) /(select cast(count(*) as numeric) from Dimtable)) * 100 as numeric(5,2))
as '% Std Values'

Also information/links on converting joins would be helpful.
Thanks!

 

[Sridharan]

ek400,

try this...

select
cast((sub1.n1) as decimal(9,2))/sub2.n2 * 100 as "% Std Values"
from
(
select
count(*) as n1
from
dimtable
where
stdcode is not null
)sub1,
(
select
count(*) as n2
from
dimtable
)sub2

 

[ek400]

Sridharan,
Thanks for the code! I ran it successfully.

ek400