I used a slightly different approach.  First, I totally agree with Phil.  It is much, MUCH easier to work with dates.  Days and Months are cyclical and it's very hard...

I assume that you are using SSRS, since you reference pulldowns.  Check out the following link on how to Add Cascading Parameters to a Report.

Drew

This is a problem with data type precedence.  Numbers have a higher precedence than strings so your strings are being converted to numbers (specifically -0 or 0), so you're doing...

SSMS doesn't have built-in OCR, so a picture is worthless.  You should post consumable sample data like below.

DROP TABLE IF EXISTS #YourTable;

CREATE TABLE #YourTable
(
DateKeyINTPRIMARY KEY
,Property_KeyINT
,Property_Status_KeyBIT
);

INSERT #YourTable (DateKey,...

Are you aware that this thread is a decade old and the original poster may not...

Thanks for your response Drew, the current image is not the actual sheet in question, added quickly as an example …  Couldn't we order by AssignedTo? thus SELECT  AssignedTo, UserSoftware...

You've heard the phrase "A picture is worth a thousand words"?  Well, data is worth a thousand pictures.  You're much more likely to get response if you provide consumable data. ...

Solving this in T-SQL requires a column to order by.  You don't have such a column in your data.

Drew

PS: "Assigned" is misspelled.

• This reply was modified 6 years, 1 month ago by drew.allen.

I do a lot of ad hoc update, insert, delete statements and was wondering if I should encapsulate using BEGIN... ROLLBACK... COMMIT to give me an out if something...

Are you looking for a T-SQL solution or a Dynamics 365 solution?  It's probably easiest to do it in Dynamics 365, but I am not at all familiar with that...

I'm with Jeff.  This looks like a JSON document.

Drew

Hey

I'm  looking for a smart idea on how to populate a field Priority with values H/M/L based on Column 1 (Activity type) and criticality

So e.g. for Activity type '207-recertify'...

Best practice is to set up a shared data source which is external to the SSRS report.  In the UAT environment, the shared data source would be set up to...

That is so great, thank you!  It works perfectly.  I am going to study it to wrap my head around what is happening here.

I am assuming that I can...

Try posting your question in English rather than whatever computer programming language this is.  Be sure to include sample data and expected results.

Drew