SELECT count(name), objectId, date

FROM tbl_objects

INNER JOIN tbl_commands ON tbl_objects.id = tbl_commands.objectId

WHERE name = 'name1'

GROUP BY name, date

HAVING count(commandId) > 5

UNION

SELECT count(name), objectId, date

FROM tbl_objects

INNER JOIN tbl_commands ON tbl_objects.id =...

> Probably more efficient

Did you compare?

Why you need CONVERT?

Just to avoid using index and make this query heavy?

I see it everyday in all projects I designed.

Probably there is no need to tell you that everything is set based.

Don't know about high-speed. You tell me. 1 second to...

I'm just trying to get back to live the DB built on SCOPE_IDENTITY apprach.

You know, it's very good while it's in developer's sandbox.

But when it goes to production, it ends...

There is a topic "CREATE FUNCTION" in BOL.

There are some examples down there.

What's not clear for you in this topic?

Open BOL and find the difference between variables and identifiers.

I use IDENTITY column, of course.

But I never use SCOPE_IDENTITY() to get CustId for table Order.

Because probably this Customer has been inserted when I processed previous order from the same...

I have asked many people and still got no answer:

Why on the earth you would need to insert a row into a table if there is already one with exactly...

Yes, too many to mention.

Start from the flow. Where do you enter the loop, what will get you out of there?

Then why do you need 2 cursors?

Status of which one...

And I better kep silence about the rest of your code.

I can only guarantee that you could not pass even entry level test on any programming course presenting this kind...

You have @dbname inside of your dynamic script.

I don't see where you have it declared in this script.

You have MAX() and MIN() for some columns, and you are definetely not allowed (and probably don't intend) to group you text notes.

I could help you with this query if...

I'm afraid, to enable dirty reads you need to rewrite all SP's (and ad-hoc queries from application?) accessing this table.

That's not what I'd like to do.

Just open topic "Triggers" or "Create Trigger".

It's highlighted there.