Hi Jeff,

Quick Query about if i have 60000 + records to process with this logic will it break anywhere with timeout issue. could you please suggest me

Also it is possible...

Hi Jeff,

I am using the code what you have provided. I didn't change anything on yours and tested with more data and it's working great. thanks for your wonderful...

Thank you Jeff for the great explanation. Before seeing you thread this is what i tried.

DECLARE @Work TABLE (UserId int, refund int);

INSERT INTO @Work

SELECT UserId, refund

FROM (

UPDATE users_transaction

SET [status]...

Hi Jeff,

Yes you correct. i always start to write algorithm before i write logic.

Here is my algo,

1. Get the records from users_transaction table group by user id where status =...

thanks for your time on this pandey

Yes it gives proper result. that's why i marked this a resolved already

Thank you for your time Luis.

Hi Luis,

How are you? Since long time keeping your foot print on my post. Appreciate your time on this. Some time mind doesn't work to write easy logic.

this is...

Guys,

Thank you so much for the wonderful replies and really helped me to understand the scenario.

wondering no reply for this. Anyhow Finally i ended up with writing CLR function to achieve this.

Great. It is invisible to me. Thank you for notifying this. It works now. Appreciate your time on this MM.

Thank you jeff and Adi for this wonderful post with great...

Hi MM,

I am sorry that am bid confused about the issue. You meant to say the issue is with my sample data or the where condition ? what could be...

error :

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near '2'.

Print result

2D5E558D4B5A3D4F962DA5051EE364BE06CF37A3A5@Server.com|user1@domain1.com|0|2014-02-05|Microsoft|100

E52F650C53A275488552FFD49F98E9A6BEA1262E@Server.com|user2@domain2.com|1|2014-03-05|Samsumg|120

4fd70c47.4d600e0a.0a7b.ffff87e1@Server.com|user3@domain3.com|2|2014-01-05|Nokia|139

4fd70c47.4d600e0a.0a7b.ffff87e1@Server.com|user4@domain4.com|3|2014-02-08|HTC|149

4fd70c47.4d600e0a.0a7b.ffff87e1@Server.com |user5@domain5.com|4|2014-02-13|Paypal|129

Any suggestion please

would like to try all possible way to do this and which ever is taking lesser time will be used. i am going to try bulk insert from my front...

Hi Jeff,

Thank you so much for your wonderful time on this post and it really helped me. i tried to incorporate your changes on Adi's query and getting error. It...

Thank you Jeff for rescuing me from Aaron's modified function. I understand the cause from your explanation. Please post your comment about Adi's suggestion.

Thank you