Viewing 15 posts - 3,286 through 3,300 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 15, 2017 at 7:21 am
PSB - Tuesday, August 15, 2017 5:35 AMYes, sure . I will calculate the field in the SP for better performance .Thanks,
PSB
Ok,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 15, 2017 at 5:46 am
This doesn't sound like you need a CASE statement. As you only want to return results which don't conform then you just need to use a WHERE clause:
[code...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 15, 2017 at 2:54 am
PSB - Monday, August 14, 2017 4:31 PMAny updates will be greatly appreciated.
You haven't answered the questions previously asked. For example, Phil...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 15, 2017 at 1:42 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 14, 2017 at 8:42 am
Triggers can cause a lot of overhead. Emphasis on can. It all depends on what the trigger is doing, and how well it was designed. A poorly designed trigger is...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 14, 2017 at 8:33 am
A secondary question: why not use SQL Server 2016 rather than 2012?
Couse some of...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 14, 2017 at 7:45 am
RPSQL - Friday, August 11, 2017 11:47 AMNo They are running the same operating system (Windows 2012 R2)
Then this only, unfortunately, cements...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 14, 2017 at 2:11 am
If there is a value for 2018 in the table, what are you expecting to return; the 2018 year? If you are always going to be returning the most recent...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 14, 2017 at 2:04 am
Duplicate of https://www.sqlservercentral.com/Forums/1891681/Excel-file-load-in-Temp-table-in-SQL-Server-2008, however, considering that the OP states 2012 and 2008 in their subject header, not sure what version they are actually using.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 14, 2017 at 1:50 am
You've posted this question in both the SQL Server 2008 Forum and SQL Server 2012. Which are you using?
You don't explain what you're problem is here. You...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 14, 2017 at 1:49 am
PSB - Friday, August 11, 2017 9:58 AMComputed column based on the sort the conditions 1 and 2
As John as pointed out,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 10:10 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 8:59 am
Did you have problems with any older versions of SSMS? Personally, I have no problems connecting to a SQL Server 2008 via SSMS 2017, however, that server is running on...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 8:45 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 8:36 am
Viewing 15 posts - 3,286 through 3,300 (of 5,109 total)