Did you try to rewrite the trigger with derived table instead of CTE? Did it work correctly that way?

I'm not sure whether CTE work properly with triggers (I'm comparatively new...

Yes, that's what I supposed - that the form distorts characters before they get to SQL... it doesn't have anything to do with collation. You need to change the script...

I don't think it would make any sense to SELECT something as a certain collation... collation says, how the data is stored in the database with respect to ordering and...

peitech,

from the pictures you posted I suspect that the hash could be generated outside SQL... what type is the form you are using to input data? Is that PHP? Check...

Hello,

it is hard to tell without dissecting the code, and not knowing the data types, indexes and amount of data in tables, but I can see one possibility... there are...

metawizard2,

now that you explained your background, I can understand better why you chose the way you described... and I'm glad you started to explore the set-based approach. If you'll work...

Hello,

I have to say that while the procedure described leads to correct result, it seems to be lacking certain ingenuity so often found in the articles here. In my opinion,...

Steve,

I think this is language issue... what the poster (probably) wants to know is not theoretical capacity of a cursor, but how many rows currently are in the cursor that...

bhaumik,

I still have problem to see through your data structure.

What means "id" column in table MaterialInventory? From your example with "web1" it seems, that "id" in table MaterialInventory is just...

Use something along these lines (no guarantee, since you didn't post table structure - but it should give you idea how to strip time from datetime value):

SELECT DATEADD(d, DATEDIFF(d, 0,...

The problem in your query is, that...

Maybe it would be better not to use cursor at all... in most cases, it is possible to find a set-based solution which performs much better than cursor. Could...

To avoid correlated subqueries and gain better performance, you might try this:

As a basis, you need to have a query, which finds the correct date for each ID.

SELECT id, MAX(date)

FROM...

I am not sure whether I understood what you want... I'm not even sure about relations between the tables. Can all three tables be joined on ID column?

If you want...

I'm returning back to the original question... although there is not a rule that would apply always, IMHO "rule of the thumb" means something different - a rule that can...