Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.
--this temp table created on the fly in the SP. 2 users run the SP --sametime is causing it to fail or should i do check if table(&PK) --exists at first place and then create table.. Let me know. Create table #tempMain ( SrOfferID Int NOT NULL CONSTRAINT [DF_#tempMain_SrOfferID] DEFAULT (0), SrOfferScheduleID Int NOT NULL CONSTRAINT [DF_#tempMain_SrOfferScheduleID] DEFAULT (0), FacultyID Int NOT NULL CONSTRAINT [DF_#tempMain_FacultyID] DEFAULT (0), StartDate Datetime, EndDate Datetime, OfferDays char(10), ShowDay char(3000), ShowMonth char(3000) CONSTRAINT [PK_#tempMain] PRIMARY KEY CLUSTERED ( [SrOfferID] ASC, [SrOfferScheduleID] ASC, [FacultyID] ASC ) ON [PRIMARY] ) ON [PRIMARY]
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.