You can use a subquery if you want

Select ClientId

Unitbalance,

Date

from Table

where Date =...

That user defined function fn_get_sql does not exist in the current version of SQL2000 I have installed, SP2 🙁 It would have been great cause then i could have...

There are other alternatives to using triggers.

http://www.mssqltips.com/tip.asp?tip=1381

If you have an index on the date column, then the Dateadd one should be better probably resulting in index seek, rather than index scan.

I think you can use any one of these 2...?

WHERE a.rundt > dateadd(month, -12, a.rundt )

GROUP BY SUBSTRING (ACCT, 1, 2), b.rpt_name

ORDER BY SUBSTRING (ACCT, 1, 2),...

Is it not possible to replace not in (1,2,3,4,5) with >= 6?

Also, the in is the same as the OR operator: =1 OR = 2 OR = 3 etc.

So you...

SELECT abs(Column_Name)

FROM Table_Name

will convert negative to positive and positive stays same

If you store datetime column, can do as follow as well

select * from TableName

where datediff(mi, getdate(), Columname) <= 30

Running on SQL 2000 - Answer is wrong

begin tran

create table stud_mast (dob datetime, aaa int)

insert into stud_mast values ('1 feb 2008', 1)

insert into stud_mast values ('1...