The below query will produce your desired result:

select *
from #OutputTable
where coalesce(SeasonalAddressID, -1) = case 
when (@SeasonalAddressFlag = 1)
then SeasonalAddressID
else coalesce(SeasonalAddressID, -1)
end

Glad I could help

Try to execute this query with BCP instead of querying the sys.syscomments table:

SELECT OBJECT_DEFINITION(object_id) FROM sys.objects WHERE type = 'P' AND name = 'sp_ic9av0_dx_length'

There is a huge difference between image back-up and a database back-up. It's a long story to explain everything of a database back-up, so I suggest you first read articles/blogs...

• This reply was modified 4 years, 4 months ago by  HanShi.

You can use the script to run on each instance. It will show the last back-up (full, diff, log) taken of each database. You can use sp_send_dbmail to send the...

Take a look at these links:

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/prereqs-migrating-log-shipping-to-always-on-availability-groups?view=sql-server-2014

https://social.technet.microsoft.com/wiki/contents/articles/33173.sql-server-alwayson-combined-with-log-shipping-automatic.aspx

Sounds like an implicit conversion somewhere along the way. Do you alter the contents of that field between the SELECT and the INSERT?

For debugging purpose: store the final result into...

Agree with Grant, but also check (just to be sure) that the query isn't blocked! Query the sys.dm_exec_requests DMV and check the "blocking_sessions_id" column (should be 0).

select...

Here's a script to display all indexes including the defined columns within the current database. You can easily adjust the script to filter on the required table(s) and to generate...

Get the query that is behind each dataset from each report. See if these queries run slow when executing directly from Management Studio (using the same parameter values as when...

Is the linked server itself correct defined? Test this from SQL with stored procedure

exec sp_testlinkedserver 'ExcelLinkSrv2';

I'm sorry. I don't understand what you are trying to accomplish. Can you provide some sample data (DDL and DML), the sample code of your stored procedure(s) and a display...

No need to run it multiple times. You can join it with a table that holds the months (or use some sort of a calendar table and extract the monthnumber...

Perhaps this code will get you started. It will extract the current month and calculate the last day of the previous month. In a CASE statement it will determine if...