Here's an example:

DECLARE @HACCProj varchar(8000), @branch varchar(8000), @DivCode varchar(8000), @PrimZone varchar(8000)

SET @HACCProj = '80,81'

DECLARE @Multipara varchar(8000)

SET @Multipara = 'SELECT CNo,CName,[Search Name],CFName,CMidName,CSurname,Title,

CASE DOB

      WHEN ''01/01/1753'' THEN ''Null''

ELSE DOB

END AS DOB1,       

CASE...

Yes, the SPROC is not quite right. The problem is with this part of the dynamic SQL :

AND (@branch IS NULL OR Branch IN('+ @branch + ')

EDIT: Sorry, you were talking about stored procedures. You're correct, SP's cannot be dropped fromanother database context.

I would listen to PW, not only does dynamic SQL usually perform poorly, in this case its also very hard to read. Note the example below with all of the...

AWE allows access to memory OVER 4GB (4GB is the maximum amount of memory addressable with a 32-bit memory address). If you have a 4GB server, don't use AWE.  Next...

Using the previous two posts as inspiration, here's another way:

declare @sample table (id int, fax_date datetime)

SET NOCOUNT ON

insert @sample values(1, '2006-02-25 00:28:00.000')

insert @sample values(2, '2006-02-25 00:31:00.000')

insert @sample values(3, '2006-02-25 00:33:00.000')

insert...

SQL Server 2000 Standard Edition is limited to 2 GB, regardless of the OS or machine memory capacity. Refer to BOL "specifications-SQL Server objects"

One more thing, if you still can't connect, go to Control Panel | Administrative Tools | Services and start the SQL Server Browser service. Try to connect again. If you...

Have you reinstalled SQL Server Express, or do you have multiple instances? I would change the entry for MSSQL.4. You have to restart the server for it to take effect. ...

Ian's code works fine on my SQL Server 2000 SP4.

If your interface is complaining about comparing int with Decimal(4,0), cast the Year() function to Decimal(4,0):

select *

  from accBalance

 where myYear =...

Another issue might be that in SQL Server Express, TCP/IP is disabled by default. 

1. Run the SQL Server Configuration Manager

2. Expand SQL Server 2005 Network Configuration

3. Click on Protocols for...

Run REGEDIT.EXE and look for this registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer

One of the values in the pane on the right side should be LoginMode.

1 means Windows Authentication only, 2 means Mixed...

See if these links help:

http://support.microsoft.com/kb/240867/EN-US/

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463

My response was made under the assumption that the application that will use the file as input requires the EOF marker at the end of the file. I agree, Windows...

As fare as I know, you can specify a column and/or a row terminator, but not a file terminator.  If you can create a file that contains a single EOF...