I'll give that one a shot, thanks. It seems to be used against the server instance on which is resides. Is it able to hook into a remote server?

Donalith

Yup.. I've never instituted full-text searching before so I'm looking into how to set it up on SQL 2008 and how to implement it. It seems to be more what...

All fixed...thanks folks. I must have misused the PATINDEX the first time.

I updated my table with this:

update TABLE_NAME_OBFUSCATED set AnswerText = REPLACE(AnswerText, CHAR(185),1)

where PATINDEX('%' + char(185) + '%',AnswerText)>0

Unfortunately no. CHAR(185) qualifies as a numeric in the ISNUMERIC()...

I look forward to reading that, Gail!

So as a rough idea.. unless XACT_ABORT is ON (which I have set as I don't want non-constrained data in my tables) then SQL...

I had to build your code set but you this will give you the results your looking for though you may want to store your data in a different relational...

Thanks, Corgi, I've read that. I'm trying to get an example of where the transaction failed so it moved from the TRY to the CATCH phrase but was still in...

Awesome, thank you very much. That's just what I needed.

My first thought would be to change your ORDER BY clause. For example,

ORDER BY

Pat.Patient_id,

Pcs.Order_description,

Cgi.End_Date DESC,

Cgi.Charge_item_id DESC

Donalith

edited to add:

CELKO's idea of adding ROW_NUM() OVER (PARTITION BY Pat.Patient_id, Pcs.Order_Description ORDER BY...

Perhaps it has something to do with the fact that the create table statement is being run against the database from an external .NET application.

When you run the create table...

Mr. or Mrs. 500,

I cannot drop the table because the applicationID is a foreign key in another table. I'm stuck with delete unless I want to mess around with dropping...

If you delete Applications and reseed the Identity to 0 when the Identity's initial value is null you will get a 0 for the first Identity BUT

If you delete Applications...

Nevermind.. I didn't realize that SQL Server only maintained a 3.33 precision on milliseconds..

case closed.. thanks

Donalith

Perfect! Thank you!

Thank you for your help. I didn't know that about cte's. It work fine now.