Viewing 15 posts - 3,286 through 3,300 (of 5,111 total)
I have the below statement and when it runs it just makes the...
August 15, 2017 at 9:46 am
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,...
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...
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...
August 15, 2017 at 1:42 am
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...
August 14, 2017 at 8:33 am
A secondary question: why not use SQL Server 2016 rather than 2012?
Couse some of...
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...
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...
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.
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...
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,...
August 11, 2017 at 10:10 am
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...
August 11, 2017 at 8:45 am
Viewing 15 posts - 3,286 through 3,300 (of 5,111 total)