Search results for query: *

Like this guy? -- Francis Francisus ego, sed non sum papa.

I may be old-fashioned, but I think that "engineer" is overused in job titles, and should only be used when the employee has an engineering degree, or operates a railway locomotive. I also think that baseball caps should only be worn with the bill in front, unless you are that catcher on a...

Spotted on a Ram dually: CUTACOW Butcher? (probably not a baker or a candlestick maker). -- Francis Francisus ego, sed non sum papa.

Outlook (with Gmail) is slow as a tortoise on tranquilizers. -- Francis Francisus ego, sed non sum papa.

I have found eM Client to be pretty good in Windows 10. Works fine with Gmail, Icloud, and others. Much faster than the native mail apps and (shudder) Outlook. -- Francis Francisus ego, sed non sum papa.

You can compare yesterday's and today's record in the flat file (before you import it). If the employee number is the first field, you can use that as sort of a key for the two records. If it's a fixed-length file, all the better; just compare using SUBSTRING. Otherwise, you'd have to parse the...

People don't know that peanuts are really legumes, though. -- Francis Francisus ego, sed non sum papa.

Oops. sorry. [blush] -- Francis Francisus ego, sed non sum papa.

Bond, Jimmy Bond 003.5 -- Francis Francisus ego, sed non sum papa.

SOYLENT (on a green car, of course). -- Francis Francisus ego, sed non sum papa.

Or, if you prefer (this works in SQL Server 2012): WHERE DUE_DATE BETWEEN CONVERT(DATE, GETDATE()) AND CONVERT(DATE, GETDATE() + 30) This strips the time so you can use BETWEEN. And the + 30 just adds 30 days to today's date. -- Francis Francisus ego, sed non sum papa.

A colleague of mine once spent the entire day trying to fix the carrier on an Electronic 75 before he gave up and took it into the shop. We ended up replacing the carrier. He could have done the same thing in 20 minutes, cover-to-cover, but he thought he knew better. From this and similar...

Back to the subject: Once worked on a Selectric that was having problems with carbon sets. The secretary was using 9-part (!) carbon paper, and the bottom copies were not clear (no kidding). The kicker? The typewriter was right next to a Copier II. -- Francis Francisus ego, sed non sum papa.

Ed: I still remember the part number: 1280017 for the gallon; 450608 for the little 8 oz. can. I was mostly a a Selectric, typebar, and IPE guy. Some Series III and 4520 copier work. Also fixed PCs and worked in the parts room. -- Francis Francisus ego, sed non sum papa.

@Edfair - We used to use IBM Cleaning Fluid for such tasks. That stuff cleaned anything. Don't know what's being used now, as 1,1,1-trichloroethane has been banned. I don't recall that as being particularly flammable, though. We once used a gallon of it to kill fire ants at the branch office...

Back 30 years ago, when I was servicing typewriters (remember those?), I had a call on a Selectric that was dead. Turns out it was unplugged. And this was the engineering department of a large chain hotel. -- Francis Francisus ego, sed non sum papa.

As a side note, I was reminded (by Facebook) that his birthday is today. [sad] -- Francis Francisus ego, sed non sum papa.

I've been away from TT for a while (being out of work for a couple of months). T was very saddened at the news that John had passed away. Sleipinir, John, and I met in person for the first time a few years ago in Baton Rouge (a midway point between them and myself). I will miss his presence...

gk53, I was assuming that CompleteDate was datetime. What gave that away is the clause in the original query: WHERE convert(varchar(10), O.CompleteDate, 101) BETWEEN '09/01/2013' AND '03/31/2014' -- Francis Francisus ego, sed non sum papa.

To expand on George's answer: WHERE O.CompleteDate BETWEEN '09/01/2013' AND '03/31/2014' will never return any result, because '09' is greater than '03'. So, what I do would be this: declare @startdate datetime, @enddate datetime set @startdate = '09/01/2013' set @enddate = '03/31/2014'...