If you want the default value  that you declared to be considered into the Case statement then this is work around in case expression 

DECLARE @Client...

Thanks to all of you who responded and yes, welcome to my daily routine of job application process and interview process! It starts with job advertisement for Entry level developer...

I see, okay! I know the logic interpretation changes how and what you use in On clause vs where clause when Outer join is in place. I guess I...

Just to be clear, Step 1 is like pre-set up (One time only configuration)

Step 2 goes into your Inner job : "D_reports"

Step 3 goes into your "outer job" which calls...

SQL server agent jobs has an option to run SSIS package as step

very straight forward, if you can google you get loads of blogs but this is the closest I...

So, looks like you want to execute same job for different report IDs one after another is that right?

I had similar issue once, here is how I handled.

Step 1:...

This could work too !

Delete P

from @Policy P

left join

(

select Download, AccountNum, RootPolicyNum

from @Policy

Group by Download, AccountNum,RootPolicyNum

Having count(distinct CurrentStatus)=1

and max(CurrentStatus)='Renewed'

) Q

on P.Download=Q.Download

and P.AccountNum=Q.AccountNum

and P.RootPolicyNum=Q.RootPolicyNum

where Q.AccountNum is null

select *

from @Policy

Me too, missed the duplicate rows ! Too distracted by other elements in the logic !

Thanks for the question, I did not know sign() function before. Today I learned something...

I don't think you need offset and I am not sure if it is reliable for all the data. Let's say if they don't have any data last year Jan...

Not sure if it helps but I had similar experience and thought I could share my ideas and you may already tried them but just in case..

Clustered indexes on SourceTable...

Hey, this looks challenging for my level and I am trying to follow the whole thread but I am not clear on exact request.

So, let me first confirm if this...

I see, got it! Thanks for all the info and your time! 🙂

Very interesting! Good to know! Thanks for the sample and I will definitely keep this in mind from moving forward!

Btw, the technique that I provided, do not use the concatenate...

Thank you so much for the response! About the concatenate strings with Order by clause technique,

I am not aware of any cases where this might not be reliable. I...

Thank you so much for sharing, this is great! As I am new to XML in SSMS, I was able to understand it but I am not sure if I...