January 17, 2008 at 8:52 am
Invoice Jan Feb Mar Q1 Deferred rev Apr May Jun Q2 Deferred rev July Aug Sep Q3 Def rev
2,500.00 2500 2500 2500
Now I need to populate a new field in the same table
Description
========
Q1 inv recognized in Q3 ( as 2500 $ is the Q1 invoice and it is recognized in the month of August from above example, I have to update the Description field as Q1 inv recognized in Q3..
If there is no revenue recognition for any of the months then the Description field should be
Q1 inv and nothing recognized
Invoice - Invoice Amount
Jan, Feb, Mar - Revenue recognized in each month
Q1 Deferred rev - if the Invoice is raised and revenue is not recognized for none of the months in that particular quarter then Q1 Deferred rev will be the same as Invoice..Similarly for other months..
How can I dynamically update the description field. Plealse help me..
January 17, 2008 at 8:56 am
I'm sorry, but this doesn't make any sense to me. Please will you post your table structure in the form of a CREATE TABLE statement, and some sample data in the form of INSERT statement(s). You suggest in the title to this thread that you want to use the CASE statement - can you show us what you've already tried, please?
Thanks
John
January 17, 2008 at 9:22 am
If this is homework, please try to do it and we are happy to help you if you get stuck, but you must make an effort.
January 17, 2008 at 9:26 am
When the paste the sample rows in a table, the image is getting distored..Can you please provide any group email where I send my question ?
January 17, 2008 at 9:34 am
This is one of the field that I got to populate in the report. I finished the report except the logic in this field.
January 17, 2008 at 9:38 am
You may also want to read this article about how to ask for help: http://www.sqlservercentral.com/articles/Best+Practices/61537/
😎
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply