Prior to Frank's post I downloaded sqlbolsetup.cab (SQL2K (SP3) BOL). The cab contains setup plus msi's for the Windows Installer and one msi for BOL. It installed to the default location

C:\Program...

For non negative values I prefer

REPLACE(STR(512,15,0),' ','0')

Check language setting for login on new server. This can affect date input.

You can only build a cursor using a SELECT statement.

Use a temp table, e.g.

CREATE TABLE #temp (col1, col2 ...)

INSERT INTO #temp EXECUTE proc1

DECLARE cursor_name CURSOR

FOR SELECT col1, col2 ......

This solution uses a loop instead of a function

CREATE TABLE #temp (Claim_ID, Cust_Name, Entry_Date, ReportsPrinted)

INSERT INTO #temp

    SELECT DISTINCT Claim_ID,Cust_Name,Entry_Date,NULL 

    FROM Claim

DECLARE @report_type char(1)

SELECT @report_type...

Hi Frank,

No problems here

Use ActiveX workflow script to stop processing if duplicate_count>0 by setting

Main = DTSStepScriptResult_DontExecuteTask

The sid of the specified user in the 'current database' is changed to the sid of the specified login. If you use the proc on the 'new database' the 'old...

Try adding

;ANSINPW=OFF

to the OPENROWSET connection string.

Hi Frank,

Yeh and the avatar looks better

Nice

Just beginning to get to grips with it.

Noticed today in Active threads, if on a page a while and then move to...

I would preprocess the files first before loading into sql.

Use DOS command

findstr /i /r "." \folder\* > \difffolder\newfile.txt

this will produce single file containing each line of all the files with the...

Example TSQL from BOL

RESTORE DATABASE MyNwind2_Test

    FROM MyNwind_2

    WITH

    MOVE 'MyNwind2_data' TO 'D:\MyData\MyNwind2_Test_data.mdf',

    MOVE 'MyNwind2_log' TO 'D:\MyData\MyNwind2_Test_log.ldf'

Why not bcp?

Create a proc to output the data in the format you want then use either bcp, dts or isql to output to a text file.

I would do the following

Create a staging table (RecordID int IDENTITY(1,1), name, otherinfo, grade1, grade2, grade3, grade4)

Create a single DTS package to

1. Truncate staging table

2. RESEED if...