Instead of updating the running total each time as you have to calculate the running total again and again and don't forget the locking on the table if the transaction...

tshad (11/3/2015)

---

This gives me any row that has any of the states in the @stemp variable.

Can the query be changed to give back only rows that have ALL the states...

Quick question is there any transaction table where you are storing each Debit / Credit entry for the specific card number. If yes then share the DDL for that table...

Quick note, your design is not so great if you work on large data set. i would recommend that data should be already parsed for states.

you will eventually get into...

I feel like rugby expert now after answering is correctly. Nicely put. Thanks for sharing.

and have a nice weekend.

May be people are used to radio button and forgot to choose two option like i did or i am the only...

Hey Folks, It happens on QotD. Don't worry Steve will fix it 😉

As per the question, good basic question thanks for sharing. And Steve you will be be very happy...

Good question. Thanks for sharing.

You didn't properly share the problem. So we all have to guess what exactly your problem is. Its always better to share detail of the problem and your desired output...

Nice question. Thanks for sharing

Thanks guys. As Tom said this is really inconsistently designed.

It's one of those areas where the language is an inconsistently designed mess.

Consistent language design would mean that END would always...

good basic question. Thanks for sharing.

Didn't got a chance to use it may be in future. thanks for the refresher Steve. nice question.

+1

Thanks for sharing Steve.

nice question steve, thanks for sharing