I'd union the two datasets BEFORE counting ...

SELECT COUNT(*) AS NUM

FROM

(

SELECT EmployeeID

FROM table1

WHERE EmpTermDate IS NULL

UNION

SELECT EmployeeID

FROM table2

WHERE EmpTermDate IS NULL

) AS UT

Reinstall Reporting Services.

It sounds like IIS or the Reporting Services Service has lost some configuration. IIS should be bringing up reporting services, without any meddling with IIS configuration.

BTW. Microsoft's MSBlaster network scanner is really good for locating hidden SQL Server and MSDE installations. It's amazing how many more instances you can find over osql -L

SELECT     MONTH(DATE) & YEAR(DATE) AS MONTHYEAR FROM   TABLE   

& is performing a bitwise AND between the month and year outputs.

In Sql Server you use + to concatenate values...

Use Int Identities where you can. Make them a primary key, and build a proper relational database with enforced foreign keys and then you wont have data integrity issues.

If...

Books online has all about the different data types and their physical storage sizes.

For what it's worth though, you will want to use decimal not float for numbers, as float is...

Some responses:

re Issue 1: SQL Server only contains a DateTime data type. Date and Time are always combined.

re Issue 2: Use CONVERT style 112 ISO (yyyymmdd) which will always sort correctly...

You can create a Sql Agent job that was scheduled to execure everyday,, with a step to executed a T-SQL command.

The SQL Command could be set to insert a record...

You probably will get better performance with using a seperate process/service to send out the emails. Then your updates are not going to take as long, or use as much...

SQL Server service should be shutting itself down gracefully in any case.

The service will recieve a message from the OS to stop, just the same as if you were to...

Your log full problem doesn't occur because of cross posting does it ?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=155419

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=155416

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=155415

One message is usually enough to get an answer. Now I have to post this...

Your log full problem doesn't occur because of cross posting does it ?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=155419

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=155416

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=155415

One message is usually enough to get an answer. Now I have to post this...

Your log full problem doesn't occur because of cross posting does it ?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=155419

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=155416

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=155415

One message is usually enough to get an answer. Now I have to post this...

Errr. that's very not right. Perhaps you want something like:

UPDATE TableA

SET val1 = valueX,

      val2=  valueY,

      val3= valueZ

FROM TableA

JOIN (SELECT *

         FROM OPENQUERY(linkedserver,

1. Are you wanting this to occur after an UPDATE occurs on the row?

OR

2. Are you wanting this to occur when the current time makes the calculated age field...