You can place the original calculation for MonthsInService into the calculation for MyCol3. It would look like this:

datediff(year,[DateEngaged],getdate()) * 2

Hope this helps,

Eli

SQL Server Express has the ability to create Database Diagrams. You can also use Reporting Services. Not sure about the others....

Eli

What are you trying to do? More information is neccessary.

Eli

The layout is based on the order of your listed parameters (Report -> Report Parameters). You have the ability to move them up or down which will affect where they...

How about the datatypes for your parameters? Are they date to datetime?

Eli

What is the error you are receiving?

Eli

Good call - should've thought of row_number.

Would this still be off by 1? If the maxnum function retrieved the next incremental number and row_number starts at 1, then there will...

How about using a cursor?

Eli

What are you validating this against? Additional information is needed - such as table structure/schema etc.

Eli

You could add a bit field indicating whether a notification was already sent out for the records to determine if they're new records or not.

Eli

1. Tables Quiz and Answer do not need the subject_id field. This is because that can be determined from Table Question which falls under a Subject.

2. Not that it's necessary...

It's hard to say without really seing the structure of the tables and it's data. However, try using a LEFT OUTER JOIN on the table with the date.

Eli

I'm not sure if this is the best route, but if you know that your field will always have the last day of the month, you can say something like:

WHERE...

You can use a CHECK contraint to enforce that only certain values can be entered. This can be done when you create the table (in-line) or added to the table...

I just ran it in SQL Server 2005 and it worked. What happens when you run it?