Hi Sean,

thanks for the reply and my bad. updated the data on my original post two process happening

1. Updating the balance on the table @UserBalance

2. Making the IsProcessed...

thank you dude. appreciate your time on this.

thank you dude. appreciate your time on this.

even i tried the below code

CAST(round(AVG(convert(numeric(5,2), RScore)) over (), 0) as decimal(8,0))

it works. but would it impact anything?

hi roryp,

thanks for the reply and i am getting the output as 71.000000. How can i round this as 71. Because i don't want to have the precision.

how can i...

quick question about avg mathematical,

i data i gave as sample data. For my original case, the sum i am getting as 423 and total months as 6.

so 423/6 has to...

thank you guys for all the reply and imex, your solution works for me.

Hi Lowell,

thanks for your reply and your query gives aggregate of all the records and plots in...

Hi Luiz,

thanks for your reply

If i use the variable alone in the where clause, below condition will not work,

if i pass value other then 0, i need to pull all...

Thank you Steve for your reply and will browse through.

Thank you Jeff and Steven for your thoughts on this. Really am little confused to proceed this process or not. Is there any documentation how to handle this situation on...

Hi Jeff,

thank you so much for your precious time on this post. You two systems we need for this. Does it mean two sql instances and one two application servers?...

Thank you Dwain. nice example on the link.

Finally i came up with

SELECT DISTINCT Parent

FROM @T WHERE Child = @Id OR Parent = @Id

UNION

SELECT DISTINCT B.Child

FROM @t A INNER JOIN @t B

ON A.Parent = B.Parent

WHERE A.Child =...

Hey guys,

Any help on this post. I am sure masters are busy for the Xmas- Event. I will be more happy if i get any suggestions.

Thakns

Hi Aaron,

thanks for your suggestion. My project was build two year ago and i am new to this project. So it was not implemented till i came to this project....