Thank you so much for your help Eugene.

Got this thing working. One question though am I going to have to convert ALL of my fields to Varchar to...

Okay here is the data and tables you asked for assuming I did this correct.

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#FileInfo','U') IS...

Eugene Elutin (6/29/2010)

---

Sorry George,...

scott.pletcher (6/24/2010)

---

You could also do something like this:

CREATE TABLE combined_table_for_export (

id int identity(1,1) not null,

case# <datatype> not null,

sec_seq#...

WayneS (6/24/2010)

---

George, please see the first link in my signature. If...

Eugene Elutin (6/24/2010)

---

george.greiner (6/24/2010)

---

Eugene Elutin (6/24/2010)

---

And I believe, you don't need to use the cursor in this case as well 😀

Please provide some DDL...

Eugene Elutin (6/24/2010)

---

And I believe, you don't need to use the cursor in this case as well 😀

Please provide some DDL script to setup...

Lynn Pettis (4/16/2010)

---

To begin with, this is really a business decision first. Once you have the requirements for doing the invoicing, then it should become easier to determine what...

Jason Selburg (4/6/2010)

---

george.greiner (4/6/2010)

---

Does this also give me the ability to process a batch subscription. For instance if there are 10 finished files within the last 24 hours that...

Does this also give me the ability to process a batch subscription. For instance if there are 10 finished files within the last 24 hours that need to go...

Excellent thanks. Is there any way to prevent this from happening...

The reason it is grayed out is because I am running SA. Apparently as long as there is a check mark I am good to go regardless of color!...

On the encryption key tab I created a backup of the...

I got it all figured out. I neglected to use the correct scope which resulted in the failure. Thanks all for your help.

Yes it does thank you. I do have an odd issue though. My code is as follows =Cstr(Fields!TaxFrom.Value) & "-" & Cstr(Fields!TaxTo.Value) . For some reason ONLY...