Using a relational database would make things a lot more easier...

😉

Mike,

unfortunately there is no such thing as "CROSS APPLY" in MS SQL 2000.

Create a trace job which will secretly populate some secret table with data from master.dbo.sysprocesses where program_name = 'MS SQLEM ...

I did not dig into it but I noticed that DatabaseName and ObjectName don't work for some reason. Probably they don't work in some cases, I don't know, was never...

First of all - trigger is a stored procedure. It's just invoked in a different way.

Look in "CREATE TRIGGER" topic in BOL if you don't believe me.

🙂

"Trigger-less solution" means just...

As well as "Flag" columns, and most of those 25 columns, and that overnight job selecting records for emailing.

"Send...

Ronald,

look closer.

What we've got.

There are 3 "Flag" columns. And there is some job which updates those flags anyway.

And there is a trigger which captures updates and sends emails.

So, easiest and...

CREATE VIEW LargeOrderShippers

AS

SELECT S.CompanyName, O.OrderID, O.Freight

FROM Shippers AS S

INNER JOIN...

Yes, but not in SQL2000.

Table function approach is just wrong for this.

You need a value per line of...

Lowell (10/15/2007)

i disagree that a trigger is needed; part of the scheduled job should be doing a query like this:

select * from tbltest...

You need trigger to populate that table.

It's easy 😉 :

SELECT A1.DocID

FROM TableA A1

LEFT JOIN TableA A2 ON A1.DocID = A2.DocID AND A2.DocType = 'EmpID'

WHERE A2.DocID IS NULL

GROUP BY A1.DocID

And you can look for hints inside other system procedures.

Wisdom comes from there.

:Wow:

That script is not actually originated from that forum.

It's from the text of system procedure sp_change_users_login:

[font="Courier New"] -- HANDLE REPORT --

if upper(@Action) =...

What if procedure returns multiple recordsets? Which one you wanna see?

What if procedure does not return any recordset?

What if only result it returns is an output parameter?