Actually I've an Items table which has a field(TotalQty), now i need a
sql query so that everytime  new items arrive in my store, i can add
the number of quantity of item arrived to the existing quantity entry
in the databse. Hope u understand me.

I have a column that shows one character for each day in a year, it is either
Y or N 365 times
eg. the 2 Januari will show NYNNNNNNNNN.....
I want to do a query that shows how many Y there are in a row and what place