Do you show data from database directly to end user? Without any front-end application?

Define the presentation format is a task for a application, not SQL Server.

System account is not the right account to start SQL server. The are many issues corresponding to this option. If you want you can make a quick research and find...

As I understand problem was not in treturning array from SP but in supplying array to SP.

You cannot do it with parameters, but you can use #Table.

Check the account started MSSQLSERVER.

It must be "Local System Account".

Change it to proper account and try not to use Local System Account to start MSSQLSERVER anymore.

You have 2 tasks.

1st - find latest set_id

2nd - use this set_id as a filter.

Subquery by definition.

Sorry.

Create table function dbo.Managers(EmployeeId) to return list of all managers of the Employee (you may add column "level" to retyurned recordset) and then join this function to employee table.

Use hash tables.

Create TABLE #array () in procedure from where you call SPReturnarray and fill it with data.

Than you can select from #array inside SPReturnarray.

You need to "Include Extended roperties" when "Create Destination Object" via DTS wizard.

.0 forces real calculation.

If you need float precision type .00000.

And finally, use variables. Do you actually remember what they told you on programmers courses?

And don't use "sa".

Throw away the cursor.

INSERT INTO SB_DEBTOR

SELECT ....

WHERE NOT EXISTS (select

   SB_DEBTOR_ID

  from

   SB_DEBTOR

  where

   SB_DEBTOR_CONTACT_SURNAME = D1.SB_DEBTOR_CONTACT_SURNAME and

   SB_DEBTOR_ADDRESS_1 = D1.SB_DEBTOR_ADDRESS_1 and

   SB_DEBTOR_SUBURB = D1.SB_DEBTOR_SUBURB and

   SB_DEBTOR_POSTCODE = D1.SB_DEBTOR_POSTCODE

)

INSERT INTO SB_PATIENT_REGISTER

SELECT

FROM < joins you use for select>

INNER...

Calculate your "from date" this way:

DECLARE @StartDay smalldatetime, @Today smalldatetime

SET @StartDay = '1900-07-01'

SET @Today = getdate()

... between dateadd(yy, datediff(yy, @StartDay, @Today), @StartDay) and @Today

Just convert it to float and apply whatever format you want in front end application.

you have space within your time value.

So when you remove brackets your 1 column containing date becomes 2 columns.

And if problem is not in excessive number of columns but...

SET DATEFORMAT YMD

would help.