A few questions before giving definitive advice...

Will you be recording EXACTLY the same sort of information (e.g. name, address, dob) for Father and Son, or will one have more/less information...

Isn't that what UDTs go some way to providing, as long...

Take the quotes off

AND TOT.TaxTotal 0.00 and it should work.

You can do it by using the OUTPUT clause...

CREATE TABLE a (id int, descr varchar(255))

GO

CREATE TABLE b (id int, descr varchar(255))

GO

INSERT a output inserted.id, inserted.descr into b values(1,'Description')

select *...

... or Gail's article

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

It can be done, but the mirroring and replication must be set up in a specific way.

From your brief description, I suspect it won't work.

Have a lookat this link...

Wilfred van Dijk (8/5/2009)

---

"Let me see ... seems your for an amputation of your left leg?"

"No ?? .... Aha! My appointment is B5010D2A-F8F9-482B-AC29-C1351ECE52C8"

"Oh yes, you're pregnant, let's see how the...

The reason why ,I have to use u is because my supervisor made request for the apppointment number format to start...

No. You will need to change the input parameters for those stored procedures from 12 to 15 as well. Just changing the data in the table will not be enough....

Simplest way is

SELECT LastName + ', ' + FirstName+ ', ' + COALESCE(MiddleInit,'') AS Name

If you make your primary key in both tables CLUSTERED (which would be a reasonable choice in this case given that some of the queries are ORDERing/GROUPing by locid), the...

Ouch! If the file has grown from 40gb to 75gb by 1mb a time, then you could have 35,000 file...

Yes, that is...

Can you provide a bit more detail...what has grown to 75GB? What size is the database itself? How much space is free in the database? What size is the transaction...

SQL Server is obviously having to run 2 queries instead of one... but each of these queries should consume less resources...