Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: databanker
- Content: Threads
- Order by date
-
Generate Daily Balance From Transaction Table
I developed a query that creates a running balance from a transaction table. My issue is that I would like to establish an end of day balance for all 7 days of the week even if there are not transactions on a particular day. What is the best strategy to go from a running balance to an end of...- databanker
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
-
Increment Column Name
I am trying to figure out how to increment a column name in a select statement. Basically I want one select statement to run against my 12 monthly balance fields (EOMB). The below code is what I have so far. Any advice is greatly appreciated. declare @counter int set @counter = 0 while...- databanker
- Thread
- Replies: 8
- Forum: Microsoft SQL Server: Programming
