Viewing 15 posts - 1,906 through 1,920 (of 5,109 total)
I realise this isn't an answer to your question, however, why are you using the nolock query hint on every table? Also, please learn how to Alias objects in a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 21, 2018 at 9:33 am
Also, I noticed you haven't responded on my comment in regards to NOLOCK. What's your reasoning for using it?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 21, 2018 at 7:18 am
When ever I run the statement again the "duplicate key value" just goes up...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 21, 2018 at 7:10 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 21, 2018 at 7:03 am
Something a bit more readable (again):USE [campus_reporting];
GO
CREATE TABLE [dbo].[CmEvent] ([StartDate] [datetime] NULL,
[EndDate] [datetime] NULL,
[RemindDate] [datetime] NULL,
[DueDate] [datetime] NULL,
[Comments] [text] NOT NULL,
[Subject]...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 21, 2018 at 6:59 am
Ideally, you need to change your data set up. Is that something you're open to?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 21, 2018 at 6:50 am
Have you checked the "Keep together on one page if possible" checkbox?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 21, 2018 at 5:30 am
Query that is a (little more) readable (white space remove courtesy of SSC's broken text editor) and with the syntax errors removed:WITH
#ExList AS
(SELECT DISTINCT
st.SystudentID,
CASE...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 21, 2018 at 5:20 am
also this query had run few minutes in sql 2012 and now run hours in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 20, 2018 at 7:01 am
Perhapsyyou mean can you use SSMS to connect to 2 (or more) servers at the same time? If so, then yes.
Like Phil said, however , this question is...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 20, 2018 at 6:50 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 20, 2018 at 6:39 am
Thanks for your reply. My requirement is like some thing like support system. From...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 20, 2018 at 6:05 am
What do you mean by editting? As in, someone in an application is viewing the record? You'll need to implement your own "locked" system. For example, add a column (maybe...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 20, 2018 at 5:47 am
"disturbing" is an odd choice of word. 🙂
Have you considered using the Dark Theme?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 19, 2018 at 1:13 pm
And what do the error and event logs say?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 19, 2018 at 11:32 am
Viewing 15 posts - 1,906 through 1,920 (of 5,109 total)