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?

Try this:

WHERE date >= convert(datetime, '2009-12-16 00:00:00.000, 121', 121) and date < convert(datetime, '2009-12-17 00:00:00.000', 121)

Actually that isn't what Jack asked for. If you read the article he suggested (also happens to be the same article I reference first in my signature block as...

Glad I could help.