Thank you both for your responses. 

The reason I wrote the UDF with the parameter was to limit the amount of data that needed to be included when I did...

That's probably tomorrow's question. 

I looked at the MSDN reference, and it had the following line:

The SQL-2003 synonym for char is character.

What is...

It could be that

pressure_date.datetime AS pressure_date

should be

pressure_data.datetime AS pressure_date

Mattie

Greg,

Thank you.  When I see questions in a category like SQL Server 2005 - Security, I assume it's a change from 2000.

Mattie

How does this differ from what would happen in SQL Server 2000?

Mattie

Thank you both so much.  I couldn't get it out of my head that I should be using an exotic join condition or something other than 'equals'. 

Mike, I appreciate...

I found this logic somewhere on this site, and I use it all the time to build email lists.  It doesn't seem to have a problem with the leading or...

I'm hoping (actually, I'm pretty sure) that 'when charindex('TWP', City) > 0' is SQLese for 'when the starting location of the text string 'TWP', in column City, is not zero'. ...

Getting back to cspangler's original question, I suspect you don't want to replace the entire contents of City, just the abbreviations used. If that's the case, I think you...

I really enjoyed the interview, but I didn't quite follow this:

It included 15 months in year 3

Is that a metric year?  Or does it explain Microsoft's release schedule?

That's it:  public has select access on all tables in the Enroll database, but no execute access.  I'm guessing that's so their stored procedures can have access across databases.

When I...

Brian,

Thanks so much.  I'm guessing I'll have to stick with the copy method, because the powers that be will most likely tell me your solution violates stricture #2:

No changes...

No, I haven't added in the rollback yet.  Incredibly enough, it's more important to me to track what's happening when it fails than to have it not fail.  So far,...

Remi,

Well, as always happens when I'm trying to isolate why something fails intermittently, everything they tried today worked.  So I'll keep my log table going until the process fails, and...

Released from the hospital would be this icon I suppose.

I don't explicitly rollback the transaction after the first sp_executesql because I thought that exiting...