User Comment: I looked at both the http://www.asp.net and the http://www.instantasp.co.uk forums and I like the one at http://www.instantasp.co.uk best. It...

It's been a while since I used this but I think if you manually update the sysdatabases table and set the status field to 32768 (emergency mode) you will be...

Here's the final post in the thread that Jonathan referenced.

quote:

---

For us it is a dead issue now. The developers are...

quote:

---

I have a table and all records have a date.

I want to select all records between two given months/years.

For example, all...

Eagles fly. Turkeys skydive.

Do the input parameters to the stored procedure cover all fields in the table? If not, you would need to use the following snippet to replace the UPDATE statement:

--...

Just wanted to clarify how DATEDIFF actually works. All DATEDIFF does is count the number of boundries crossed between the given dates.

DATEDIFF(yy, '12/31/2000', '1/1/2001') = ...

Same as NP but this will return only those members that have another member in their ZipCode.

SELECT p.PKCol, COUNT(m.PKCol)

FROM tbMembers m JOIN tbMembers p ON m.ZipCode = p.ZipCode

GROUP BY...

Since isNumeric returns a 1 for any REAL number and the original question was "how do I test for an INTEGER" you would need to use the following test

where isnumeric(substring(testField,...

You can do as a5xo3z1 suggested. Create an Active-X DLL in VB then use the sp_OAxxx procedures to execute it's method(s). I've done it several times and it...