RE: ifs inside a select inside a Stored Procedure

inal Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 2:59 PM To: CF-Talk Subject: ifs inside a select inside a Stored Procedure I want to do this but can't seem to find the right syntax. I am sure Alter Procedure [_process Daily Page Views] As In

ifs inside a select inside a Stored Procedure

I want to do this but can't seem to find the right syntax. I am sure Alter Procedure [_process Daily Page Views] As Insert into [processPageViews] (CSTLogDate,CSTLogHour,TrafficOrigin) ( SELECT logdate as CSTlogdate, datepart(hour,logtime) as CSTLogHour, if [c-ip]='xxx.xxx.xxx.xxx' beg