WHAT???

You insert MaxID into ExternalId, and ExternalId suppose to reference some ID from some external table.

If you just increment MaxId by 1 everytime you're doing insert what those new ExternalID's...

DECLARE C_TESTE INSENSITIVE CURSOR

FOR

SELECT TESTE

 FROM TESTE

WHERE TESTE NOT LIKE '%[^0-9]%]

Not numeric values just filtered out from selected set. No need to check for errors.

Comment ORDER BY and you'll get bunch of other errors.

Fix them and restore ORDER BY. It will work OK.

Which visit "DISTINCT per ACCT" you want to see?

First? Last? First for today? Last before today?

If you include Visit into returned set and you want to see only one per...

Using trigger you can catch it in table deleted.

Absolutely correct.

For full information behind this statement I would suggest againt to read BOL.

Especially if you gonna assume anything.

In this case pay attention to the topic "CREATE TABLE", section "Temporary Tables".

Probably what you need is simple XML out of you data.

This question is being answered on this forum several times every week.

Open BOL and read about system tables: syscolumns, systypes.

The only way is to create new table(s) with right structure and create trigger on old table to populate new table on each INSERT/UPDATE/DELETE on old table.

You not gonna notice...

You don't need subquery at all.

For better performance always try to build "one go" query.

INSERT INTO my_table (comments,

...

What stops you from doing it in application?

If you have @vChar = '1458.87' and you are trying to treat it this way you'll perfectly match it to integer value 1458. But they are...

Inside the trigger you can check

IF SUSER_SNAME() NOT IN ( ...&nbsp

ROLLBACK TRAN

The list for NOT IN may be hardcoded, may be read from...

As well as NVARCHAR datatype for RegionDescription.