Thanks All: I found a typographical error and resolved the issue. Meanwhile I really appreciate the link to the "Catch All query" debate. Very helpful!

Additional comment:

Another approach would be to build the entire SQL statement in the frontend and skip the dynamic SQL on the backend. Which is preferred or industry standard?

greatly appreciate the help. I ended up using a cursor and generating my list fine now.

Thanks,

Sam

figured it out! This works great:

ISDATE(REPLACE(SUBSTRING([column],PATINDEX('%[0-9][0-9]%',@x),10),' ','/')) =1

REALLY appreciate the help!! Almost there.

Here is my statement so far:

SELECT d.ImageDetailID, d.ImageLink,

CASE WHEN

ISDATE(REPLACE(SUBSTRING(d.imageLink,PATINDEX('%[0-9][0-9]%',d.ImageLink),10),' ','/'))

THEN

CAST(REPLACE(SUBSTRING(d.ImageLink,PATINDEX('%[0-9][0-9]%',d.ImageLink),10),' ','/') as datetime) END

AS adate

FROM dbo.ImageDetail d

WHEREd.DateImage IS NULL

When I try to run get...

Thanks, This helps.

I also copied the log so that is likely the problem.

Sam

then how to call values? That's where I seem to be stuck.

exec spOutTest ...

Thanks so much! This solved my problem so I thought I'd post it:

ORDER BY

CASE WHEN @SortVar='name' AND @order = 'ASC' THEN s.LastName+s.FirstName END ASC,

CASE WHEN @SortVar='name' AND @order...

Paul:

I assumed the code should encapsulate the updates as well, right? :

BEGIN TRY

BEGIN TRANSACTION;

SAVE TRANSACTION [DoUpdates];

BEGIN

Update...

Update..

...

Big thanks! Thanks for the additional error trapping as well.

Sam

yes, did that and it made a big difference but didn't completely solve the issue. Now looking at server resources such as more memory, etc.

I have side by side instances running and it's killing us right now.

thanks, checking the stats and memory.

These are not connected offices. We schedule procedures and tests with radiology or other sites that have their own systems in no way related to ours.

But I will check out...

I would guess more along the lines of a screen scraper. I have a medical application and the same data may be requested from numerous sources. Let's say it's a...