--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]
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.Get Access
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.