We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
CREATE PROCEDURE [dbo].[sp_LeaverProcess] AS /* Set user status to Leaver for Intranet */ UPDATE NEMESIS_LINKED.intranet.dbo.tblusers set status = 2, LeaveDate = GetDate() FROM NEMESIS_LINKED.Intranet.dbo.tblUsers tblUsers_1 JOIN dbo.view_SelectTodaysLeavers LEAV ON tblUsers_1.EmployeeID = LEAV.LoginID /*Revoke Worksite login access */ update ws set ws.login='N' from MINOS_LINKED.docs.mhgroup.docusers ws, view_SelectTodaysLeavers TODL where ws.userid = TODL.LoginID collate Latin1_General_CI_AS
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|I need to "lookback" and pull all data from 5pm and prior based on a date time field. Is there a getdatetime funcion?||4||30|
|SQL - Creating Pivot with all the possible columns||7||33|
|SQL: Default Database Integrity Jobs Failing||6||27|
|SSIS Package Not Running in Batch File||3||17|
Join the community of 500,000 technology professionals and ask your questions.