mandoswork (8/1/2012)

---

The normalisation is the whole point of the exercise. I'm trying to import a flat file, with the same columns repeated 10 times, into a more logical structure -...

oolawole (8/1/2012)

---

To make it easy then, I will say amt is amount, acc is an account, smp is a sample, and regn is a region. The table His is for...

--edit--

Your structures appear to be suffering greatly from a lack of normalization.

morepainot (8/1/2012)

---

I add GO before every proc? Its giving me an incorrect syntax error right about it where the comment lines are.

GO

CREATE PROCEDURE syd_StagedCols_DT_Differ_SourceCols

@ApplicationName VARCHAR(100)

,@SourceDatabaseName VARCHAR(100)

,@SQL_str NVARCHAR(max) OUT...

You can't use IF EXISTS in a where clause. The IF statement...

Why do you...

morepainot (8/1/2012)

---

From looking at the code, could you tell me what you think the errors may be? I have a few syntax errors and the rest are scalar vaiable errors....

OK so now we have ddl and sample data. What is the question? Can you tell us what the desired output...

Well...

Charlottecb (7/31/2012)

---

Hi Sean,

I'm only going to insert the rows for the passed in customers and I'm only going to select the rows for the passed in customers. The example data...

With regard to your comment about being easier to do this with proper dates as opposed to separate months and years - I'd be happy to adjust the structure to...

So your process is going to insert rows into the original table? And then you are going to select all the rows from the table regardless of which Customer IDs...

I am a little late to this one but...

Your desired output does not come close to this.

CustID 1...

The reason for the error has been identified.

However nobody really addressed this question. Honestly I see a lot of things not necessarily...

Try running your code in an empty database. There are dozens of errors. It would also be preferred if you can use IFCode shortcuts (over on the left when posting)....