Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
100% Quality Score
Upvotes Received
1
Posts with Upvotes
1
Upvoting Members
1
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
0 Endorsements
Ranked #72.8K
~3K People Reached
Favorite Forums
Favorite Tags

2 Posted Topics

Member Avatar for batuzai04123

SELECT CASE WHEN NVL(a.id, '') = '' THEN b.id ELSE a.id as ID , NVL(b.firstName, '-') as [First Name] , NVL(b.lastName, '-') as [Last Name] , NVL(b.midInitial, '') as [Middle Iniital] , NVL(a.project, '-') as [Current Project] , NVL(a.manager, '-') as [Assigned Manager] FROM table1 a FULL OUTER JOIN table2 …

Member Avatar for batuzai04123
0
333
Member Avatar for richjohn.bulante

*Refer this link* [http://itdeveloperzone.blogspot.in/2012/04/auto-generate-employee-id.html](http://itdeveloperzone.blogspot.in/2012/04/auto-generate-employee-id.html)

Member Avatar for sandeepmittal11
0
3K

The End.