The views of views can be very disadvantageous when you perform a lot of operations that may no be needed on the higher level ones and sometimes you may learn the...

Well,

I GOOFED! my count(*) > 1 was count(*) > 11

then I copied an pasted the SAME query twice to change only the columns 

In my opinion

>>SELECT MIN(autoID) AS autoID, Email

FROM dbo.customer

GROUP BY Email

HAVING COUNT(*) > 1 <<<

 will return ALWAYS 0 records affected !

USE MESSAGE 18264 to create the alert!

ex:

IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Some body run a BACKUP successfuly'))

 ---- Delete the alert with the same name.

  EXECUTE msdb.dbo.sp_delete_alert...

sysindexes

Vichka,

There is no such a thing as the record number conceptually in SQL. There is no implicit order on how those are stored.

You cal always write something like

create table #T1(i int identity(1,1),...

Good for You!!!

mrwid LIKE 'R[0-9]%'  OR  mrwid = 'R' -- That will bring what you don't want

If you are able to describe what you want in terms of positive patterns use that,...

I don't really understand  how you want to group them but:

Ist this what you are after ?

SELECT LEFT(YourColumn,Len(YourColumn)-1) AS Code, Count(*) AS Records

FROM dbo.YourTable

GROUP BY LEFT(YourColumn,Len(YourColumn)-1)

[Edit:] Credit To...

sp_describe_cursor_columns

??

Select Count(*) from Yourtable where YourColumn like 'D0004%'

>> The result of the update cannot be determined. The value of the column will depend upon either order of insertion, (if there are no clustered indexes present), or on...

And...

They are computed on the fly (not saved). But if you need a complex expression you may want to create an index on it and then you would have effectively...

>>Unfortunately I cannot make use of Triggers in this situation.<<

You have to use either Triggers or third party tools 

BOL = Books OnLine