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
Web Development x 1
Databases x 1
2 Posted Topics
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 …
*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)
The End.
sandeepmittal11