OH YAH...I UNDERSTOOD.

THANKS A LOT GUYS FOR YOUR TIME

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2...

IN THE COMPATIBILITY LEVEL DROPDOWN LIST I COULD SEE ONLY TWO VALUES

SQL SERVER 7.0 (70)

SQL SERVER 2000 (80)

I AM USING SQL SERVER 2005

IM USING SQLSERVER 2005

YES,DATABASE COMPATIBILITY IS SET TO 80

THERE ARE ONLY TWO VALUES 70 AND 80

HOW TO MAKE IT 90?

ITS SAYING INCORRECT SYNTAX NEAR "TRY"

ALTER PROCEDURE [dbo].[TestingTrans]

@TEMPVAL VARCHARr(255)

AS

BEGIN

SET NOCOUNT ON

BEGIN TRY

BEGIN TRAN

DECLARE @rc VARCHAR(25)

SET @rc=(SELECT RC FROM RootCause...

if the sample data is like the following

custid custname dateofpur

1abc02/25/2008 12:00:00 AM

2jkl02/26/2008 12:00:00 AM

3abc03/01/2008 12:00:00 AM

4xyz03/03/2008 12:00:00 AM

5jkl04/03/2008 12:00:00 AM

6xyz04/05/2008 12:00:00 AM

7sss04/05/2008 12:00:00 AM

8abc01/02/2008 12:00:00 AM

9sss03/12/2008...

Thanks a lot Jack...with some little modifications i was able to get the required results

select a.*,b.f3 from t1 a

inner join t2 b on a.f1=b.f1

where datediff(day,(select b.f2 from t2 where b.f3=2),(select b.f2 from t2 where b.f3 =1)) <5

i want the days comparision