Yeah, that works, good thinking.  Obviously if an index definition has changed, the 'check for existing' is necessary as you'd want to replace the one that's there currently.

When you debug a stored proc which contains statements that fire a trigger, you do not get to debug the statements in the trigger - even if they are executing...

You can script the indexes one at a time (yawn) in Query Analyser, without getting the tables scripted.  I can't see how you can do this in one step for...

This is probably just my preference, but I think I would combine these two INSERTs into a single trigger.

Are you receiving any error messages?  Try performing a simple INSERT through QA...

select stud_id, count(stud_id)

from table

group by stud_id

having count(stud_id) > 1

will give you a list of stud_ids with more than 1 occurence.

Have you been able to work out a pattern - if you look back at the source data, do the fields that come through as nulls have anything in common?

When you...

So you want the first column of a returned recordset to be row number?  Not straightforward via T-SQL (although I'll wait for someone here to prove me wrong!).  I would...

Are you running QA on the server itself, or over a network?  I think I've heard of this happening over a network - can you copy the db to your...

Here's another (similar) way - I wrote it to run on the orders table in Northwind and it returns the tenth row, based on order ID:

select top 1 a.* from (select...

Try this:

ROUND(478.0/15, 0)

Your example is performing integer division, whereas you want to perform float division and then round.

Yes - I would advise you to amend the other procedures to deal with this.

The only reason I can think of as to why they seem to work already is...

Then SQLBill's post is 100% relevant.

Have a look here:

http://www.sqlservercentral.com/scripts/contributions/1545.asp

Do you mean a script to insert data?

You just need to add an additional WHERE condition to your queries.

Query 1 - >

SELECT DrawID,DrawDate,WinningNumbers FROM [Result Table] WHERE

 DrawID IN (SELECT Max(DRAWID) From [Result Table] where...