Thanks, much appreciated

This data is exported from another older dos system to text file and has additional information that is needed. We have the matching Client ID. If data is missing we...

Yes, it is not a problem. We already have the data so we can cross reference with imported data to determine which records are missing. We can then go and...

The id column is an identity field with numbers generated auto so it should be o.k.

Thanks for all your comments. This data is coming from text files. It is being parsed and cleaned as much as possible. So that is why some sets of 5...

Hi I implemented your code change but my line lenght did not change. My lines still get runcated.

I replace:

FOR SELECT code FROM #text WHERE idnumber BETWEEN ((@nopg *...

I was able increase width. However, my row still gets truncated. How can I increase the lenght of the row so it does not truncate

I set MediaBox to:

INSERT INTO #pdf...

Where did you increase Mailbox params? I am trying to get 20 columns in one report. It keeps getting truncated.

How can you make pdf landscape? I have a report that has 20 columns.

How can you make pdf landscape? I have a report that has 20 columns.

Yes, this will identify all tables in db and will disable/enable all constraints and any triggers. Richard

We used the following to disable all constraints and triggers when importing data into existing SQL tables. Hope this helps. Richard

-Disable CONSTRAINST & TRIGGERS

DECLARE @TempSQL NVARCHAR(200)

  SET @TempSQL = 'sp_msforeachtable...

Yes, I did a search and did find it. I will try re-installing the client.

Thanks

Richard