Ok, so I created a new project, and connected to the database, which then made all that databases tables appear, all with the same names I had them as as...

Ok, I'll do that, but no sp's for now - that will have to come later for technical reasons. As I absolutely detest the record navigation that Access...

Whatever my frustrations were 10 years ago, I've long since forgotten. I just remember converting and then having no means to make changes, and nothing I did from...

Minimal effort? I've been working with Access for a long time, and while I haven't spent much time making the attempt, the effort I did spend led to...

While I agree that the .adp is nice as a best practice, many larger companies simply no longer have the time to invest in the additional complexity, and would more...

Brandie,

I'm going to have to side with Gila Monster on this one - THERE"S NOTHING IRRATIONAL about your fears in that case...

Steve

(aka smunson)

:):):)

GilaMonster (9/12/2008)

Brandie Tarvin (9/12/2008)

"Don't let that developer touch...

Hi All,

Perhaps I can add a few thoughts here... I've been working with Access, Crystal Reports, and SQL Server databases for the last 13 years, and I can...

Perhaps the most important thing for people to realize is that the energy level of the collisions that will take place in the LHC is actually less than the energy...

I tried SELECT-ing those two items from an SSMS query window, and regardless of which server I connected that query to, both items were the same as the ID used...

Interesting. I didn't have a temp table, but I do have a table variable in my query, and once I eliminated a DELETE FROM statement by moving that...

Solved my own problem. I re-engineered the query to eliminate the need for a DELETE statement by taking that criteria into the INSERT INTO SELECT query with a...

I don't know about the evaluation order, but why are you having to use any kind of fancy calculations? If you perform your query correctly, there's no...

I have to agree with GSquared, unless you feel up to writing your own OLE DB driver... Perhaps the larger issue is the TRUE cost of continuing...

Turns out I had a small error in my script. Here's the corrected version:

SELECT CAST(YEAR([date] AS char(4)) + '_' + RIGHT('0' + LTRIM(RTRIM(CAST(MONTH([date]) AS varchar(2)))),2) AS YR_MTH,

...

I agree with Michael. Investigate "Data Driven Subscriptions", as I think that might be exactly what you need. Then you can create your letter as a...