You should read these two comprehensive articles on error handling in SQL Server by Erland Sommarskog:

http://www.sommarskog.se/error-handling-I.html

http://www.sommarskog.se/error-handling-II.html

Try this:

selectemails.email as emailAddress

,reverse(substring(reverse(emails.email), 1, charindex('.', reverse(emails.email)) - 1)) as emailDomain

from(

select'xxx.yyy@xxx.com' as email

union all

select'xxx.yyy@xxx.co.uk'

) emails

Please, post the definition of the query that causes the error.

Also check whether the called component is actually installed.

In the trigger you could put all the data from the INSERTED virtual table into a single XML instance and send that to the queue. Of course, you'd have to...

Are you looking for a generic procedure that can be used to import data from various sources? A more appropriate solution would be to just provide your coleague with an...

Please, post proper DDL, sample data and expected results.

See this article for details:

http://www.aspfaq.com/etiquette.asp?id=5006

Yes, loose ends should be tied up before moving on.

SQL 2000 is still being widely used, and let's not mention SQL 2005 SP2. Oh, I just did.

Have you considered using SSIS for this?

Assuming your data is correct, I believe this could be close:

selectcurrentyear as CYear

,District

,School

,RollNo

,zipcode

,[type]

,count(*) as actual_count

,Emp_Related

= sum(case when ([status] = 'E' and relation = 'R') then 1 else 0 end)

,Emp_Not_Related

= sum(case...

Please, post proper DDL, sample data and expected results.

See this article for reference:

http://www.aspfaq.com/etiquette.asp?id=5006

Anyway, what you're describing is a self join. In order to achieve that, you need to...

Please, explain in more detail what it is that you're trying to achieve.

There is no "grid view" per se in SQL Server. If you're referring to a UI component you...

Please, post a simplified version of the repro. I think by simplifying this you can even discover the source of the problem without any outside help.

Make sure the laptop WinNT user is mapped to a login on the SQL Server Express instance, and this login is a user of the database, and the user has...

Take a look at these two articles by Erland Sommarskog:

http://www.sommarskog.se/arrays-in-sql.html

Please, provide proper DDL, sample data and expected results, otherwise we're all looking at days of guessing and not really helping anyone.