function not supported by sql 2000....so you'll write your own function...um...that is also not supported?

I think you mean simply not explicitly written by microsoft...technically all stored procs, functions, views, or...

curses on cursors! I am appropriately humbled. Thanks for putting me back on the path of enlightenment, Robert; I just couldn't "see" the subselect; nice solution.

eek I'm gonna say the words " only a cursor can solve this"; while I know cursor is the antithesis to all things SSC, sometimes you have to use the...

i'm assuming the procedures return the same number of rows? or it's the same proc with different paramters, or that they return a single value?

Hopefully this will get you started...

more than one way to do it, and lots of quick answers; that's why i love this site.

remember that a stored proc is really just a formula, just like A² + B^{2 =} C^2;

A,B and C would have a datatype you can discover, but they do not...

here's a procedure that you pass the tablename...it cursors thru every column in the table, and if any column is null, adds it to the results table, and finally returns...

also, check the actual values:

If rsLogin("UserType") = "user" OR rsLogin("UserType") = "cust" Then %>

if rsLogin("UserType")  is NULL, an error would occur. check the table that contains the column UserType and...

based on the error messge, it sounds like the function is calling a sotred proc in it's body; if you want to send me a priv message witht eh function...

I think it's because your server name has single quotes in it, which is invalid. i know you can use double quotes, but not single.

bad:  DRIVER={SQL Server};SERVER='ISERVER';UID=sql_dba_link;PWD=MyPwd;Initial Catalog=SQL_DBA

good:  DRIVER={SQL...

does this return a value? this should do the same thing you did when assigning it to the @x variable.

SELECT dbo.fnCalcBusHours( 1, 1, '8/31/2004 10:18:30 PM'

this might help: it shows each table, and what filegroup a table belongs to. if you only have ONE datafile per filegroup, then the table is contained in that datafile.

if...

i believe xdate1 is creation date, while xdate2 is last changed date?

this would list all users that havne't changed their pass in >60 days i think. yould probalby use this...

pretty much all functions have to be preceeded by the owner (usually dbo.)

this will work:

select Incident_Number, dbo.fnCalcBusHours(Cust_Id, Service_Id, open_time, close_time)