Hi all,

Right it is now working..

Found out that it was a numpty play on my part, although I've the 2005 management tools, I had SQLExpress 2000 running in the...

Nope still the same error.

Thanks for the replies though, this is all new to me. Simple SP's are not a problem, but I wanted something more elegant then the...

Hmm, I now get another error.

Msg 170, Level 15, State 1, Procedure TestProc, Line 34

Line 34: Incorrect syntax near '.'.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:pryder

-- Create date:

-- Description:

--...