Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
--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.