OK, the BlkBy column is clear (-) and DBCC InputBuffer is returning the initial script. I ran another script during the problem one just to make sure something was...

Hello. I ran the two sprocs while it was haning but I don't know what to look for. The sp_who2 is pretty short:

53 RUNNABLE ...

Hello. Assuming I understand deadlocks correctly, a deadlock message did not print out and there's nothing in the log.

Thanks for the response.

Although I did add a 'WITH RECOMPILE' line to the two changed stored procedures, I tested the possibility by deleting and then recreating all three of the...

Hello. I'm not sure why freetext is in the column position of the example but a FREETEXT full-text search searches for a close match, not an exact match. ...

Hello. It's unusual to not get a response on this site so maybe I need to whet the appetite more.

A couple of nice search scripts have come through this...

Just off the top of my head, the power of placing an application on an end user's desktop via web standards is reason enough to program business logic in JavaScript....

What caught my attention in the article was the issue of where to place the business logic layer. This is somehting where I think Microsoft has misled their community...

Hm, well I took it to mean the data in the table can be modified after it's creation. From the article:

Note that by defining multiple CTEs, you can...

Hello. Would it be correct to say that in views CTEs give most of the flexability of temporary tables while temporary tables still have a place in scripts since...

Systems Analyst seems like it comes pretty close. I like that.

On Access, I'll agree it's good for a quick solution and great for end users to develop their own applications....

Ferguson and Frank, thanks for the stories. I have to say that the model Ferguson is working with sound smart and worth taking big picture ideas from.

I have to...

I believe this is an MS SQL error.  Can you run the Oracle part only of the above statement on the Oracle server via SQL Plus?

Thanks for the reply, I was more curious than anything else.  Unfortunately I have no experience with Access driving the SQL Server.  Good luck.

So, this returns the expected result (I threw in the first line of the WHERE clause) with visit_date and @MinusDate displaying the exact same string for those records that you...