Unit tests are specific in nature. A unit test determines whether a unit of code meets a certain specification. When unit tests fail they should point to a...

This is interesting - but it's not generating unit tests - it's generating integration tests which are not diagnostic, and do not run quickly, or cover all functionality.

Thanks for the help Terry!

I am trying that right now.  I will let you know the outcome.

-Jonathan

Looks like you want to think in terms of sets here.

You can probably indentify the rows that need to be updated with a view (where they exist on bot hh...

If you want to send a message to MSMQ from one machine to another, you need to install MSMQ on three servers.

On the Primary Domain Controller (PDC) you need to...

I think you are referencing lots of tables in your view.  So the underlying data may be more volatile than you think.

Another approach you may want to consider is materializing...

I only glanced at your T-SQL, but I think what you want to do is the following.  HTH!

-Pick an ID that is unique for each insert, say PatientID, and then...

Alternatively, you can define an INSERT trigger to set the insertdate.

You may fare better using DTS from Enterprise Manager.

In enterprise manager, choose Tools -> Data Transformation Services -> Export Data. 

Follow the prompts, and you can name target type, separator...

My gut reaction is that your employers really want you to create a view, so that they can see similar objects in one data structure.

If the entities are different, they...

I've done some development where I materialize base views into tables...  Generally, if the result sets are very large, or some of the base views distinct their results, this can...

The following will probably work for you:

INSERT INTO businesses ([name], datelastmodified)

SELECT DISTINCT  left([secondary ins co],80), '5/3/2005'

FROM upload2 T1

WHERE NOT EXISTS

( SELECT 1 FROM businesses T2

  WHERE productid = 12

  AND left(t1.[secondary ins...

I have what I believe is a better way of doing this.

I don't like to build strings and then exec the results, as there is the possibility of SQL injection,...

If you have message queue configured to run over the network, you are likely actually sending data from the SQL Server Box to the testbox via the PDC.  So you...