With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
--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.
|How to query LOCK_ESCALATION||4||42|
|Selection from table2 where criteria for table1||10||60|
|How can I exclude some wording in a like statement?||39||78|
|Need to merge 3 large tables into one Table in SQL server||2||26|