Conversion of SQL server query to teradata query

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Conversion of SQL server query to teradata...

Rate Topic

Display Mode

Topic Options

Author

Message

RahulG

Posted 5/8/2008 4:45:28 AM

Forum Newbie

Group: Forum Members
Last Login: 6/13/2008 6:08:05 AM
Posts: 1, Visits: 13

Hi,

If anyone can help me in conversion of query to teradata

1.

isnull(ACC_DET.user_name,' ') as usr

2.

isnull(MAX(isnull(ACCESS_DATE,'')),' ') as max_access

3.

datediff(day, access_date , (select max(access_date) from cess_details )) < 90

Thanks and Regards
Rahul

Post #11381

dnoeth

Posted 5/9/2008 7:22:59 AM

Supreme Being

Group: Forum Members
Last Login: 6/25/2008 7:26:06 AM
Posts: 474, Visits: 202

Hi Rahul,
ISNULL is proprietary, replace it with COALESCE, which is also supported by MS SQL Server. There are some minor differences, but you don't have to care about it in that case:

COALESCE(ACC_DET.user_name,' ') as usr

COALESCE(MAX(COALESCE(ACCESS_DATE,'')),' ') as max_access
Is access_date really a string and not a datetime?

DATEDIFF might be replaced by Standard SQL interval calculation, if it's in DAYs then it's even easier:
access_date > (select max(access_date) from cess_details ) - 90

Dieter

Post #11403

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 4:53pm