dotnetrockz Posted November 1, 2011 Report Share Posted November 1, 2011 [size="2"][color="#0000ff"][size="2"][color="#0000ff"]select[/color][/size][/color][/size][size="2"][color="#000000"] @bodyrecordcount[/color][/size][size="2"][color="#808080"][size="2"][color="#808080"]=[/color][/size][/color][/size][size="2"][color="#000000"] [/color][/size][size="2"][color="#ff00ff"][size="2"][color="#ff00ff"]count[/color][/size][/color][/size][size="2"][color="#808080"][size="2"][color="#808080"])[/color][/size][/color][/size][size="2"][color="#000000"] [/color][/size][size="2"][color="#0000ff"][size="2"][color="#0000ff"]from[/color][/size][/color][/size][size="2"][color="#000000"] #xx_tt ani query run chesthe result 5 vasthundhi...naku ila ravali...000005..any idea?[/color][/size] Quote Link to comment Share on other sites More sharing options...
Ranga_The_Donga Posted November 1, 2011 Report Share Posted November 1, 2011 count(RIGHT('00000'+ CONVERT(VARCHAR,Num),6)) 1 Quote Link to comment Share on other sites More sharing options...
dotnetrockz Posted November 1, 2011 Author Report Share Posted November 1, 2011 [quote name='Jeedeelu' timestamp='1320173862' post='3054236'] count(RIGHT('00000'+ CONVERT(VARCHAR,Num),6)) [/quote] thanks... Quote Link to comment Share on other sites More sharing options...
k2s Posted November 1, 2011 Report Share Posted November 1, 2011 [quote name='Jeedeelu' timestamp='1320173862' post='3054236'] count(RIGHT('00000'+ CONVERT(VARCHAR,Num),6)) [/quote] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.