Emil Bialobrzeski (12/11/2014)

---

Don't be to harsh on me i just done it quickly while doing my other work. In the example below i'm assuming that if the optional letter does...

Hm, that's an interesting thought, but how would you code it? The function would need the infro from the...

Brandie Tarvin (12/11/2014)

---

As much as it pains me to say this (because it could cause performance issues), I think your best bet is to put in an AFTER trigger to...

Brandie Tarvin (12/11/2014)

---

pdanes (12/11/2014)

---

I didn't specify schema, and in fact, have no idea how a schema...

I didn't specify schema, and in fact, have no idea how a schema could be used...

Thanks, but neither of those queries worked as written - they have scope errors with the aliases. I'll take a look at them later today and see if I can...

Excellent script - many thanks. Already found and fixed some indexing screw-ups in my databases, just on the first run-through. This is something I will be studying in detail, and...

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