Oh, certainly. Work does frustrate me on occasion, but usually it takes something orders of magnitude greater than that to bug me :-). I was just weirded out...

If I remember correctly, the calculations are run entirely on the Access end of the program; Access itself will pull the entirety of the data from the linked table, make...

Haha, as much as I'd wish I could explain less at my current employer, it's usually not possible to do so :hehe:. The main database system here used to...

This article sounds like it has insights on the issue you're experiencing:

http://www.sqlservercentral.com/blogs/stratesql/2012/06/18/the-side-effect-of-nolock/

If my understanding of the dirty reads process is correct, even if all transactions at a given...

Alright, I think I've got it! The code above seems to break everything into a week-long interval whenever a sale happens, so a sale on Monday creates an interval...

Doh! I really should've noticed that the date strings were in a different order... My mistake. This seems to do exactly what I'll need it to do;...

Ray, thank you for replying; I can see where this query is going, and I think it should be able to help me put something together, but it seems there's...

I manage a paltry two databases at my workplace, one in SQL Server, one in Microsoft Access. Not exactly a huge burden of work there, with only about 3GB...

Alright, revised it!

SELECT

ID,

PARSENAME(REPLACE([Subject],';','.'),1) AS Split1,

PARSENAME(REPLACE([Subject],';','.'),2) AS Split2,

PARSENAME(REPLACE([Subject],';','.'),3) AS Split3

INTO #SplitTable

FROM YourTable

SELECT ID,

CASE WHEN Split2 IS NULL AND Split3 IS NULL THEN Split1

WHEN Split3 IS NULL THEN Split2

ELSE Split3...

Took a shot at it...

SELECT

PARSENAME(REPLACE([Subject],';','.'),1) AS Subject1,

PARSENAME(REPLACE([Subject],';','.'),2) AS Subject2,

PARSENAME(REPLACE([Subject],';','.'),3) AS Subject3

FROM YourTable

Works with your sample data and the assumption that 3 subjects is all you'll need. If the number...

Hm. My current employer would probably not be considered professional by these metrics, indeed :-). I entered this job as a SQL Server developer/admin, but for the first...

Hm. At my current workplace, management isn't particularly computer-savvy, which has benefits and limitations when it comes to innovation :-). On one hand, things tend to be a...

Are you using a Pass-Through Query in Access? If so, right-click the query, open it in Design View, and open the Property Sheet. The second item in the...

Hm. I certainly try to document as much of my coding as I can manage at my current workplace, but I could certainly understand the feelings of futility some...

Hm. I'd say I have about a 70/30 split of maintenance to development. At my workplace, all of the business tools in use were coded by the company's...