select * from tbla where id=128 and good='G' and abs(((impt*rate)/(v1*shares*rate))*10000)>1000
declare @id as int set @id=128 select * from tbla where id=@id and good="G"; and abs(((impt*rate)/(v1*shares*rate))*10000)>1000
NULLIF
SELECT IdCol, Col1 / NULLIF(Col1 + Col2, 0) AS Col1Ratio FROM dbo.SampleTable;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)