Okay, so what's your plan in terms of SSRS (Reporting Services) as to how to tie your data source to your report control?   You can NOT run the report and...

Forgot to mention one other thing.   Why do you have a WHERE clause that checks that the value of the "segval" field is both equal to 1 AND is less...

I've run your query, and I just don't see what your objective is.   You say you want to pivot a row, but how, exactly?   What is the relationship between a...

If you are trying to update all your existing data to reflect that a unit of billable time is now 4 times longer than before, then the first task is...

As formulas require a fairly complex parsing methodology in order to allow much in the way of functionality, providing a solution here in a forum is just not a realistic...

The problem here is likely due to not properly understanding the relationships between the tables.   If you can accurately describe what a record in each of those tables actually represents,...


CASE WHEN Serv.Type = 'Assessment' THEN 'Assessment' + ISNULL(' - ' + CAST(Serv.ID AS varchar(10)),'') ELSE '' END

As to max memory that SQL Server will use, you can get that information easily enough and determine how it's configured.   There's also a minimum memory setting.   I've long forgotten...

There's an awful lot going on in that query.   There are a total of 10 values that end up being searched for, and based on your run time, you're getting...

When I write queries, I simply am NOT willing to code ANY query using any form of multiple joins prior to having an ON clause.   I have a number of...

Kind of hard to decide what constitutes slow when we have zero information beyond the amount of RAM allocated to the VM, and that you're using SQL 2016.   You haven't...