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...

That is somewhat clearer, though I am still a bit puzzled about how you are prepared to wipe all of the data that exists in some of the tables in...

I must be missing something, but here's how I would answer questions (1) and (2)

1)  select * from projects where '2006-03-01 00:00' between StartDate and EndDate

2) select * from projects...

To get those results, what did you put in @StartDate and @EndDate?  Was it 1/8/2005?