I'm doing 70-462 next week and I'm not even a DBA. Trouble is you now need all three to get a qualification. Have set up local environments to practice on...

Can you just look for TransCode being a substring of @TC?

This was a good question and there's been a bit of "OP bashing" here.

The question asked if an infinite loop was created which it definitely is. The fact that...

Does that mean you assumed the collation was Case Sensitive? Normally, when no specific information is given, it's...

Try this bit in the middle:

SELECT @contact_id = contact_id,

@staff_issued = staff_issued

FROM inserted

The inserted "table" contains the record you have inserted whilst contacts won't know which record you want.

Create a table with the same structure as the output from sp_help (e.g. tblHelp) and modify your code to insert to it, e.g.

Select @sql =

I don't see the benefit of the subqueries here. Also your "New" filter should use a >= rather than just an =.

Does

AND IMF.ImportDate > DATEADD (day,-60,getdate())

AND CASE WHEN ImportDays>=DATEADD...

Interesting that we currently have four people who picked "neither". I suppose it could all be done in Excel, but.......

A NOT EXISTS may be better than a NOT IN

Something like

SELECT CONVERT(VARCHAR(4), R.FCde) AS Flty

FROM Rtns R

WHERE NOT EXISTS (

SELECT 1...

... sorry, didn't notice you were on SQl Server 2000. I han an answer for 2005+.

If the table has a key column another option would be to UNPIVOT it into a temp table and then do your update based on that. For example you could...

Bit worrying how many people found this easy without giving any consideration to what the default schema might be for the user. Easy to get it right if you assume...

Looking forward to our friends in the USA helping out with a cricket question 🙂

So, just add 3 to the result and all will be well 😉

If using SQL2008 you can also use a MERGE instead of the INSERT...WHERE NOT IN structure. This should be much more robust and considerably faster.