James McCall (12/17/2009)

---

If I grant UPDATE on some table columns to another user or group but do not explicitly grant UPDATE on the table then it is possible to update...

UltraEdit. Haven't had a problem with it on any size file I've used it on. Very good, solid product.

Regarding the expected results:

EmpName Reg TourStart TourEnd FOrdDate FOrdType FtOrdAmt LOrdDate LOrdType LOrdAmt

John West 8/15/09 - 8/17 B 57K 9/17 A 78K

Mike South 9/1/09 11/15/09 9/4 A 32K 10/31...

Actually Greg, now that mak101 put some effort into setting things up, I'm more than willing to help, just haven't had a lot of time to work on it. ...

Does this help?

select 'SQL full text search', replace('SQL full text search', ' ', ' AND ');

You might consider giving BOL (Books Online, the SQL Server Help System) a shot. ...

chris.dunn-795452 (12/17/2009)

---

Hey,

I noticed you're using a cursor! isn't that forbidden? that a cursor is bad news for performance!

If I had the same task I'd use something like the following solution...

Are we talking a SQL table or an Access table that holds this sequence number? Also, is the number currently in the table the next value or the last...

Jack Corbett (12/17/2009)

---

I jumped...

I am having trouble thinking straight on this one, could someone else jump in here and help. It isn't collation, it is the dateformat.

Okay, I am really having troubles this morning thinking.

How are the users entering the dates?

You have two different clients from what I can tell. One works, one doesn't. I don't think it is the collation, but another setting. The reason I...

Noticed a problem in the code I had posted. Is this what you...

I would not set the t-log to grow by a percentage amount, but by a fixed amount should it still have to grow. By using a percentage, each time...

Dinner!

Did you try what I suggested? Did it work?