Search results for query: *

rac2 "The amount is obtained with an expression using ISNULL, COALESCE, or CASE to show 0.00 for those days which have no transactions." Days w/o transactions are not necessarily 0.00 -> they are the current balance. Example: If you did not have a transaction on your bank account in a...

This is the data I have: Account Date Balance 1 1/1/2007 9 1 1/6/2007 17 1 1/11/2007 25 1 1/16/2007 0 1 1/21/2007 8 1 1/26/2007 16 1 1/31/2007 24 This is what I need: Account Date Balance 1 1/1/2007 9 1 1/2/2007 9 1 1/3/2007 9 1 1/4/2007 9 1 1/5/2007 9 1 1/6/2007 17 1 1/7/2007 17 1 1/8/2007...

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...

Wow - this works perfectly.. quick too (Method 2)! Nice solution.

This database is running on a 2000 box. I am trying to clean up what is currently 12 SQL statements. Dynamic SQL is what I was trying to pull off in my above example. UNPIVOT sounds very useful... wish I could use it.

I agree! This is an import from a legacy system. I am building a new table that replaces rows for columns. Unfortunately, I have to extract monthly balance fields as individual columns thanks to my progress data source.

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...