illegal?

Thanks Jason

I had made that change.

From now on I will use MERGE to replace Triggers for audit - all in one place.

Thank you. Your example is easier to read.

BTW I was restricting to only chnage rows by comparing the checksum values.

I didn't know you could add additional filters after is matched...

Thats a clustered index you describe?

You're right.. I've muddied the waters somewhat..

I guess though he like me works in a place where the Network Support Team would ask me to do it.

Thanks

I have a nonclustered index on this table with 2 fields numeric(8,0) + numeric(10,0)

5 + 9 + 12 (datetime clustered index) = 26 bytes

I Changed clustered index fields...

Your point in separating the code from the data is a very good one (accde I think you called it). I also luckly had no code in Access my code...

Hi

I've linked Access to SQL Server via ODBC, it links to updatable views that a few selected users can use for read/write. The rest link to SQL via Access so...

SELECT * FROM [AD_in_Out LOG] as tLog

INNER JOIN

(SELECT USERID, MAX(CHECKTIME) as LastTime

GROUP BY [userid]) as tREs

ON tLog.Userid = tRes.Userid

AND tLog.CHECKTIME = tREs.LastTime

Makes sense to me.

2 datatypes, one can store more digits in less bytes than the other, I must of missed something obvious here..

I'm asking as I wanted to use decimal (9,3) for prices,...

Although a friend has managed to install in no problems I continue to have this problem.

This product is not supported on Win7.

To get around this I've installed it in XP...

Jeff I'll pass on your reagrds to them.

I think the National lottery computer uses the same functionality many into one 😉

I've learnt quite abit form this forum, long may it...

A badly written join will produce more results normally than expected, a cartesian product it behaves correctly. Set based stuff thats what SQL is about.

This is a bug, that could...

Thanks Gila

I tried the update and it did work. I'm certain I have had to change queries before to do

set tbl1.field1 = MAX(tbl2.field1)

I'm more confused now..