Click here to Skip to main content
14,739,836 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I used linked server. m_component have 50k rows. I query data as script below. But I received only 95 records. I don't understand why ? Every one help me.

select ProductCode ,RevisionCode, ComponentCode
 ,1.0 /  ProductCount * MaterialLength  / floor(500.0 / MaterialWidth) / 1000.0  as Std
 from [x.x.x.x].[FPiCS-B03].[dbo].[m_Component]



===> 95 records

select ProductCode ,RevisionCode, ComponentCode
 from [x.x.x.x].[FPiCS-B03].[dbo].[m_Component]



==> 50k records
Posted
Updated 12-Feb-15 22:15pm
v2

1 solution

I understood it. Because divide by zero error encountered.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900