quote:

---

When I go to run that code, I get an error saying "The day function requires 1 argument", any suggestions??

---

Yes.

--Jonathan

quote:

---

We're running SQL7 so we don't have the CONTEXT_INFO variable.

The DISABLE/ENABLE trigger looks like the tidiest one to implement since so many...

Looks like a misuse of a nonstandard extension.

http://support.microsoft.com/default.aspx?kbid=136699

It would be "easiest" to write:

SELECT cl.No

FROM v62.dbo.CL cl JOIN v62.dbo.CC cc ON cl.No = cc.No

--Jonathan

quote:

---

We may add a column to the table and then test within the trigger code the value in that column as to...

A little bell went off the first time I replied, and I finally remembered something new in SQL Server 2000. There is now a "free" column, context_info, in sysprocesses...

Something in another thread got me thinking about this. If you want no values passed to mean no update to that column, but allow NULLs to be passed, something...

quote:

---

Try this

e.g.

update customers set

outstanding=case when coalesce(outstanding,0)=0 then null else coalesce(outstanding,0) end

---

Isn't that equivalent...

No.

--Jonathan

quote:

---

I am a little new at this SQL Server stuff.

BCP works but isn't that for one table at a time?? ...

No. About the only workaround I can think of is to insert the SP's process ID (@@SPID)in a table and rewrite the trigger to check to see if its...

quote:

---

For the most part, you are right. This is mainly for presentation purposes. We do have Crystal Reports, however, due to the...

quote:

---

Well, that all depends. You can also make a UDF (User Defined Function) that will return a Table of the Strings...

quote:

---

Jonathan,

I think we post about the same time. As for your recommendation It works as well but I have never taken...

quote:

---

At a technical level, the datetime field is two separate integers. The first is the number of days starting from the...