Search results
-
K
Need to convert SQL Server statement to Progress SQL-92
Now I got the solution... thanks for not replying select a.User_PID as User_PID, a.Int_Data1 as Door_ID, a.Local_DT as TimeInOut, a.Int_Data2 as BadgeCd, 'Web Service' as CreateUserID, sysdate() as CreateDate from pub.journ as a inner join (select c.User_pid as userid, Max(c.Local_DT)as...- kamikazeniel
- Post #2
- Forum: SQL-92
-
K
Need to convert SQL Server statement to Progress SQL-92
Hi guys, i need to convert this SQL statement to SQL-92. select a.User_PID as User_PID, a.Int_Data1 as Door_ID, a.Local_DT as TimeInOut, a.Int_Data2 as BadgeCd, 'Web Service' as CreateUserID, getdate() as CreateDate from dbo.journ as a inner join (select...- kamikazeniel
- Thread
- Replies: 3
- Forum: SQL-92