1) You must sort your output or use an index on your MainTable.

2) Use ISNULL() or COALESCE to handle the null value.

SELECT ISNULL(Events,'') FROM #TEMP --...

Great question. This is what the QOD is all about. A great explanation of the answer as well.

Music is my hobby. I am a part time musician. I play between 65 and 75 shows a year. But it's not enough money to pay the...

You should be able to run x32 version of SQL on 64 bit OS. You cannot run x64 version of SQL on 32bit OS.

grant alter on [InsertViewnameHere] to [InsertUserAccountHere]

Should allow the user to alter the views. Apply this to the views the user has created.

Remove the db_owner priviledge.

I would grant...

select CONVERT(varchar(11),DATEADD(YY,-1,getdate()),101) -- would give you last year.

select CONVERT(varchar(11),getdate(),101) -- produces 05/25/2010

select CONVERT(varchar(11),getdate(),108) -- produces 20100525

You could introduce bottlenecks to slow down the process.

You could move the database to slower hardware.

You could change how you define a transaction in your application.

You could remove all indexes...

I used to work for an organization that had a rule that if you got stuck on a problem for more than 10 minutes, you were required to grab someone...

From OBJECTPROPERTY BOL:

The Database Engine assumes that object_id is in the current database context. A query that references an object_id in another database will return NULL or incorrect results...

I suspect you're failing your if test. Check the value of your variables:

set @checkbox = (select att1 from pdt_first_time_homebuyers_Club_View where client_id = @client_id and pd_id = @pd_id)

select @checkbox...

We use Data Integrator because it does something we need that SSIS does not do. We get packed decimal from our data supplier and Integrator can read the copylib...

Just FYI, CONCAT_NULL_YIELDS_NULL will always be on in future versions of SQL Server.

My problem is that I overthink the answer.

To me the answer was yes, the suggested scenario would work. It seemed obvious. It seemed it couldn't be that simple....

Nice question.