Try this

DECLARE @Mode varchar(10), @StartDate datetime, @sql varchar(4000)

SET @Mode = 'Weekly'

SET @StartDate = '2005/08/01'

IF @Mode = 'Weekly'

  BEGIN

  SET @sql = 'ALTER TABLE #temp ADD...

use group by instead, eg

select arrangements.description,arrangements.number_sql as arrno,[col1],col[2],[coln]

from events inner join arrangements on events.arrangement_number = arrangements.number_sql

where events.room_number in (61,59, 50)

and events.performance = -1

group by arrangements.description,arrangements.number_sql as arrno,[col1],col[2],[coln]

order by

case lower(@@Orderby)

when...

No it is not a typo (the highlight and underline is the forum's doing)

Look up syntax in BOL

sp_executesql [@stmt =] stmt

[

    {, [@params =] N'@parameter_name  data_type [,...n]' }...

CREATE PROCEDURE [dbo].[linked_Server_Test]

  @ORDERID bigint, @errorcode char(2) OUTPUT

DECLARE @Accref varchar(50), @sql nvarchar(4000)

SET @sql ='SELECT @Accref = CustomerID

FROM OPENQUERY(LINKEDSERVERNAME,

''

SELECT CustomerID

FROM dbo.SS_ORDER

WHERE O.OrderID = ' +...

Don't forget modest as well 

is that another vote for sushila then 

I am surprised that I am falling that much behind

Not as much as I