You are quite welcome. Glad that worked!!! Thanks for letting us know.

morepainot (8/1/2012)

---

Sean Lange (8/1/2012)

---

morepainot (8/1/2012)

---

Should I do the same for this? I used your suggestion for the procedure and looks like the problem was solved. I have ONE more after...

morepainot (8/1/2012)

---

Should I do the same for this? I used your suggestion for the procedure and looks like the problem was solved. I have ONE more after this and I...

morepainot (8/1/2012)

---

[/color]

No, it means the procedure alread exists and you are trying to create it again. Two things you can do. One, change the CREATE PROCEDURE to ALTER...

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...