ZZartin (10/14/2014)

---

Your application is opening a connection and never closing it, that could be intentional, they expect they'll use the connection again at some point, or just sloppy coding, they're...

Brandie Tarvin (8/19/2014)

---

I've never seen "accdb" as an extension to an...

You can nest substring and charindex references directly to the original field, but that is definitely NOT...

I sort of figured that was the case, but thought maybe someone here would have some tricks they've dreamed up. This whole system is entirely my own creation, so I...

girl_bj (8/19/2014)

---

How to define to make it flexible on this part?

set @InputString = '7/5/2014 0:0:0 AUS UK 7/5/2014 18:21:0 7/5/2014 20:45:0 7/5/2014 19:10:0 7/5/2014 23:30:0'

Because I have a long list...

Okay, here's something that should get you started. I'm assuming the everything will be in the form you posted here:

[date]<space>[time]<space>[place]<space>[place]<space>[date]<space>[time]<space>[date]<space>[time]<space>[date]<space>[time]<space>[date]<space>[time]

The code depends on these spaces to isolate the individual elements....

girl_bj (8/19/2014)

---

i have a long list of data..will like to add in additional departure and arrival into the script..

7/5/2014 0:0:0 DEPARTURE AUS UK 7/5/2014 18:21:0 7/5/2014 20:45:0 ARRIVAL 7/5/2014 19:10:0...

zedtec (8/19/2014)

---

Apologies or being brief. Yes it was the file I was exporting to (.txt file) which wasn't showing all of my columns.

I have exported it to a .csv file...

Okay, inserting such strings is trivial, but how do we determine WHERE to...

girl_bj (8/19/2014)

---

i have a long list of string that look like this:

7/5/2014 0:0:0 AUS UK 7/5/2014 18:21:0 7/5/2014 20:45:0 7/5/2014 19:10:0 7/5/2014 23:30:0

how can i add in some indicator in...

Found it - there are a series of chained VBScript routines that activate all this, and one of them was sending a bad parameter to the stored procedure. Simple mistake,...

murnilim9 (7/23/2014)

---

pdanes (7/23/2014)

---

murnilim9 (7/22/2014)

---

pdanes (7/22/2014)

---

murnilim9 (7/22/2014)

---

pdanes (7/22/2014)

---

twin.devil (7/22/2014)

---

I think you should consider Jeff suggestion, as he described above that if your 1st column have very low number of value, which...

murnilim9 (7/22/2014)

---

pdanes (7/22/2014)

---

murnilim9 (7/22/2014)

---

pdanes (7/22/2014)

---

twin.devil (7/22/2014)

---

I think you should consider Jeff suggestion, as he described above that if your 1st column have very low number of value, which i can...

murnilim9 (7/22/2014)

---

pdanes (7/22/2014)

---

twin.devil (7/22/2014)

---

I think you should consider Jeff suggestion, as he described above that if your 1st column have very low number of value, which i can see in...

twin.devil (7/22/2014)

---

I think you should consider Jeff suggestion, as he described above that if your 1st column have very low number of value, which i can see in the procedure,...