What are the data types for this two fields

obhssq

oahssq

😎

Well, after fixing a couple of inconsistencies in the code (the system I am using is case sensitive so CoPay <> Copay, DateofBirth <> DateOfBirth, etc) I get the following...

What is the result of this query (as asked earlier).

SELECT *

FROM hsdet inner join hshed on obhssq=oahssq

where oainvd>20050100 AND NOT ISNUMERIC(oaorsc) = 1

😎

CASE is not a control flow statement, its actually a function. For what you want to do, you need to use the IF statement.

😎

So what is the actual error message you are getting with the second proc?

😎

Looks to me that you have one too many "end" statements in the second stored proc.

😎

Better if you provide it as INSERT statements so that whoever decides to give it a go just has to cut, paste and execute. Some people don't have the...

The sooner you can provide the schema and some sample data the better. Suggestion for the schema and data, primary key(s) on the table, and the additional columns needed...

Jeff,

I'd be real interested in seeing that, and testing it as well. I have never seen that myself, so that has to be a Missouri moment (show me).

Thanks,

Lynn

Try this in a test environment:

DELETE PW -- COUNT(1)

FROM

performance_esx3_workload PW

INNER JOIN performance_sample PS

on (PW.sample_id...

Post your code you wrote.

😎

There are two issues here. The first is that the update is taking a long time, and second as a result the log file is filling up the disk...

That's what I forgot to put in that post on another thread, a BACKUP LOG!

Yes, you need to do that as well. As I asked earlier, if you post...

The BEGIN and END may not be necessary, but I find it makes it easier to see what code makes up a trigger, stored procedure etc. Especially true if...

Okay, I have to bite on this one. What server settings prevent you using indexed views?

😎