I did. I read this along with lots of other articles but Im still far from understanding whats going on...

I dont know C# code at all so by that point...

Still getting absoloutely no where with this.

I have made sure that the script is referencing Microsoft Excel 11.0 Object Library because the Macro was created in Excel 2003

I have a...

Phil Parkin (2/28/2013)

---

Debbie Edwards (2/28/2013)

---

Elliott Whitlow (2/27/2013)

---

I think the missing binary code is your clue. It often (usually?) means that there was a build error in your script. ...

Phil Parkin (2/28/2013)

---

Debbie Edwards (2/28/2013)

---

Elliott Whitlow (2/27/2013)

---

I think the missing binary code is your clue. It often (usually?) means that there was a build error in your script. ...

Elliott Whitlow (2/27/2013)

---

I think the missing binary code is your clue. It often (usually?) means that there was a build error in your script. Open the script and...

Eugene Elutin (2/25/2013)

---

Debbie Edwards (2/25/2013)

---

Eugene Elutin (2/25/2013)

---

That is exactly the thing which...

Eugene Elutin (2/25/2013)

---

That is exactly the thing which makes me suspicious that...

Well its now printing the correct details for my SQL.

If I can get it to excecute I will be very happy indeed

create table #SSC(ID INT IDENTITY (1, 1), Source_Code CHAR(1),Dest_Code...

I do for things happening later in the process.

It would take ages to explain that bit and I don't need to because Im Ok with that part of it.

Also...

Getting there!!!

create table #SSC(ID INT IDENTITY (1, 1), Source_Code CHAR(1),Dest_Code varchar(30))

insert into #SSC

select 'A' AS Source_Code, 'Total_A' AS Dest_Code union ALL

select 'B', 'TOTAL_B' union all

select 'P', 'TOTAL_P' union...

I do like the idea of creating a schema for all the tables if I have to create them all as permanent tables.

Hiya again,

Right.... Im getting there but Id made the initial ask simpler than it should be.

Within my SQL there is a source table and Destination table. Both hold slightly different...

Id forgotten to do that bit.....

:blush:

Right.... Im going in to see if I can add this to what I already have. Thank you X100

Debbie Edwards (2/25/2013)

---

OK,

I have a temp table of codes (Specified above)

Then I have a query that uses the code as critera so I am going to have another temp table...

Thats looking pretty good already just by looking at it!

Ill set it up and let you know how it goes 🙂