Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 counting a row with a following rows. .

Author  Topic 

alencid888
Starting Member

2 Posts

Posted - 2011-02-07 : 22:13:33
hi guys!
ill show my tables first.

viewTransaction View


viewTransactionCopyFinal View


the thing a used a view table to get how many times the copies column from the viewtransaction view is repeated.
it gets the times borrowed.

it was okay at first, but when i wanted to retrieved the # of times the copies column was repeated from a start date to an end date, i got stuck.

i was thinking of always altering the view that lets me count # of times it was repeated. is there an easier way?

advance tnx to all

cidoria
   

- Advertisement -