Jeff Moden (7/7/2014)

---

jfogel (7/7/2014)

---

Great, just great. A year ago I wrote something that has to break down a CSV-style parameter string and it uses a loop to do it. It...

Jeff Moden (7/7/2014)

---

david.holley (7/7/2014)

---

If you're working with a specific range of numbers, for example 1980 to 2020, simply add that to the WHERE statement.

SELECT [Value]

FROM [sysNumbers]

...

If you're working with a specific range of numbers, for example 1980 to 2020, simply add that to the WHERE statement.

SELECT [Value]

FROM [sysNumbers]

WHERE Value BETWEEN...

"We always test and when we do, its in production."

Disney uses a AS/400 based PMS which uses sequences on every record. I never started a conversation as to it purpose, but I'm assuming that it provides a means of...

That was my first thought. Then it occurred to me that 1) there are columns in the table that aren't required and 2) there could be columns in the file...

I'm now entertaining the idea automagically presenting a list of fields relevant to the import that the user is attempting and the status of each field.

Field ...

Sweet! It's mostly up and running.

Thank you for that very thorough reply that sounds a lot like an article on here (hint). I think that my frustration is the general lack of practical examples. I...

I was thinking holidays where a business is closed and then just US holidays. Of course, it'd also be nice if MS were to do something whereby they published worldwide...

Woah! My brain just exploded (a la Mars Attacks!). That'll take some time to digest. It didn't occur to me until just now that most major US holidays observed by...

{Obvious newbie-ness comment deleted}

Would wrapping the SELECT inside another work if the specific order is a concern? Something like...

SELECT @NewString = @NewString + NameInitials FROM

(SELECT NameInitials FROM Employees WHERE OfficeId = 1001 ORDER...

jjturner (4/5/2013)

---

hmm... seeing that my data is in Access and the recordsets are pretty light, I may opt to keep everything local with the VBA cursor on a custom function.

Otherwise...

jjturner (4/5/2013)

---

Ok, thanks for the confirm - now I'll have my work cut out for me trying to build a solution with ADO slinging around recordsets between Access and SQL...