Hi,

Actually its not a "big" table with many columns. actually there are 20 columns. Problem is I need to follow SUMs all the time. but I need only monthly SUMs....

great, thanks.

have a great day.

BankResult is not unique. and I use it in every query.

select ... where BankResult <> '-' or ... BankResult='APPROVED' or ....BankResult='DECLINED'.... there are 6 or more BankResult types which are...

yeap, as I said there's too much rumors about that. thanks for your answer.

By the way, as you answer my questions, here's the another related one:

what about SUM functions like...

puff, my friend,

my question is does it cause any problems on sql server or not. every read request locks the row.

if using NOLOCK option causes no problem then I...

no no, you got me wrong. my queries will al be same like:

SELECT Parameter1 FROM Companies WHERE ID = 25

only one or two fields at a time with ID specified....

actually there were index problems as I mentioned and also too many SUM(total) like operations that locks entire table and I changed them. As I said there are no...

yeah, its merge replication. though I had difficulties about ID column, I made it. but if you make mass updates in database (which I need to) and meanwhile users continues...

dear friends,

I'm just confused about varchar and nvarchar types. I learned that nvarchar holds unicode character sets and varchar cannnot. varchar doubles the size. thats fine.

What I confused about is...

my friend, thats exactly what I need.

you helped me so much. thanks..

I think this is the code.

merge into revenues as R

using (

select companyid, amount, trndate from transactions where ID=2

) T

ON (R.companyid = T.companyid and r.trnmonth = ...

I have no knowledge about MERGE I'll google it. meantime, if you write down some sample 😀

okay, not related with this topic but if I use ms azure for hosting instead of renting my own physical one, would I guarantee that my sql data will always...

opc.three's solution looks cool. I'm still testing it.

Actually I found many solutions about that. but I really want to be sure that any given solution works perfectly under heavy load....

I found filling a dataset programmatically more easy. My concern was sql performance vs aspnet performance but this way is more easy.

I thank you everyone for their ideas.

to Eugene Elutin:...