(1) Do not use a Cursor Variable

(2) Declare the cursor Global

This allows what you need to do. So, this code should do it:

declare @sql varchar(200)

declare @tablename varchar(200)

set...

Remove your "Set working set size" configuration option in your setup - it does not work with AWE memory.

In Enterprise Manager, this option is found in:

Right-Click Server

  Properties

    Memory tab;

      Reserve physical memory...

Let's start by simplifying where possible. Consider the WHERE clauses (reformatted for clarity):

WHERE (dbo.tblProjectData.StateID IN (1, 2, 3, 4, 5, 7, 13, 14, 15, 16, 17, 18))

    AND (dbo.tblProjectData.ProjNoShow...

I have an answer. You're going to kick yourself when you realize what happens here... so allow me to explain.

Consider the simplified dataset below:

TableA

ID

1

3

4

6

7

8

TableB

ID Flag

1 ...

Try something like this:

Declare @Cols varchar(4096)

Set @Cols = ''

SELECT @Cols = @Cols + COLUMN_NAME + ' '

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'Categories'

Select RTrim(@Cols) As Columns

Personally, I would create a tiny app that did nothing other than those create/drop statements, and connected via a SQL Server login with the appropriate permissions. But then, I'm...

Hey now - don't diss the programmers. After all, I are one as well

Assumption: "Closest", in your definition, means the closest previous (same day or earlier) record.

Assumption: There will be no duplicate date/Sec_ID records

With this:

SELECT op_id, sec_id, op_val_date, sec_date, Sec_Price

FROM #tblOP...

Thanks to you all. Not only did I get a line on some good new books, but it looks like the Archive/History table model will be used for versioning,...

Nope - that's why I am looking for outside reinforcing opinions on this table structure. Thanks!

>>And what do you mean with two surrogate keys using identity?

Here is what a sample table layout would look like, with generic identifiers:

VersionID int identity

RecordID int <<--- Core of PK

RecordData...

Well, the changes I made (splitting the separate SQL Statements into multiple different Execute SQL tasks) fixed the problem entirely. So, this is a new warning:

In DTS Packages, do...

I am just now looking at a similar issue, and I was wondering:

Is the first task an ExecuteSQL task, and, if so, does the task contain GO statements separating things...

Poot. I didn't think through the logic fully.

Ah well, can't win them all.

I should have written:

WHERE @InTblName is Null OR Tblname = @InTblName

A couple of possibilities:

SELECT * FROM TblLog WHERE ISNULL(TblName,'-1') = ISNULL(@InTblName, '-1')

This has the built in assumption that '-1' is not legal in the field TblName. If this is...