If you have unique patient ID's and Visit ID's try something like this:

SELECT *

FROM tblPatient,

        tblVisit,

        (SELECT DISTINCT 

                    PatientID, 

                    MAX(VisitDate) AS LatestVisit

        FROM    tblVisit

        GROUP BY PatientID) AS TEST

WHERE  tblPatient.PatientID = TEST.PatientID

AND      tblVisit.VisitDate...

We have been using a simple e-mail program called "Blat" that uses SMTP. You can create scripts via the dts package to select the data into a file for the...

Verify the transaction log is not still growing. Manually execute 'checkpoint' in the database.

Can you create a new database and then create views to the linked server tables and grant access to the views to the AD accounts?

Are you looking for something like this?

CREATE TABLE Files (id INT, filename VARCHAR(255))

CREATE TABLE Email_Lookup (id INT, emailaddress VARCHAR(255))

CREATE TABLE Mapping (Files_id INT, Email_Lookup_id INT)

INSERT INTO Files VALUES(1, 'test 1')

INSERT...

You can create a .bat file to copy the date stamped file name to a generic file name:

for /f "tokens=2,3,4 delims=/ " %%i in ('date /t') do (

set my_day=%%j

set my_month=%%i

set my_year=%%k

)

set...

You should be able to add a linked server and then use that servername in your query: [LINKED SERVER NAME].[DATABASE NAME].[owner].. Here is a link to MSDN http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp

I have had numerous problems importing data from Excel files in the past. Most the issues have been caused by data and formatting issues with...

RS parameters have two options: allow blank, allow null. If these are checked it will add the default ("<Select a Value>"). Make sure you set...