Took me about 3 minutes the first time to write it. Then I lost the code and retried to write it. Guess what, it took over 30 minutes....

Ran fine on mine too... I'm anxious to see how I can make it fail now .

So what did you think it did...

Hehe.

If you need real punch, you should ask Joe Celko to comment on this design. They'll start running for their mommies once he's done with 'em

I'll avoid to show my total ignorance in that subject and won't put any guess out there . But since you talk about...

Is is possible that you have a table function that returns a column that has the same name as an input parameter??

It's the only thing I can think of at...

How odd, remove the colid from the PK and it'll run... I guess????

I just added the third column so you have a more evident view of what's going on when...

Can you live with this type of query???

Select VersionID, RecordID, RecordData, isDeleted, Created, CreatedBy, LastModified, LasmodifiedBy from dbo.YourTable Main inner join

(Select RecordID, max(LastModified) as LastModified

from dbo.YourTable

group by RecordID) dtCurrentDate...

Amen.

May the force be with you .

I see what you mean. I was reffering to something like : Select * from MyTable where MyId in (Select Element from dbo.Split(@Param, ',')), while you seem to be...

Hehe.. first time I hear a name like that!! What's the language of origin?

Hmm, if he doesn't have access to the tables, nor the views, can he use stored procs??

Cause if he can't use procs, I'd simply deny them access to the db...

Is it possible that you have some bad data in the enterprise edition server??

I don't know what this is (ï¼'ï¼-ï¼(tm)), but it surely doesn't seen like a ssn to me.

On...

Thanx for the quick reply to our requests about the end of that story .

Has anyone used this technic before of running the...

Think anyone will take up the challenge??

Maybe we should submit it as a question of the day .