Oh, sorry... left out a bit of critical information/part of a step. If you want to allow the parameter to be null, do this:

With the report in design mode, right-click...

Assuming you cannot modify the stored procedure, and you want to be able to filter out all records WHERE CaseCompleted IS NULL, you can add a filter to your report...

Is there helpful documentation on the PATINDEX function somewhere? the stuff on the MSFT site is useless.

Don't you have to use Contains for that?

https://docs.microsoft.com/en-us/sql/xquery/functions-on-string-values-contains?view=sql-server-ver15

--method of the xml data type. Inside the exit method,  
--the XQuery contains()function is used to  
--determine whether...

This is ugly, but appears to work. (Someone who knows how to do this better than I will undoubtedly chime in and show a much better way of doing it,...

The short answer to your question is to use the LAG function to get the value from the previous record. Something like this...

LAG([LoginTime],1) OVER (PARTITION BY EmpID ORDER BY [LoginTime])

Oh...

• This reply was modified 6 years, 1 months ago by pietlinden.
• This reply was modified 6 years, 1 months ago by pietlinden.

Maybe use SSIS and a For Each file loop, and dump them all into a single table?

Or use Excel... put all the files in a single folder, use a folder...

1 lakh = 100,000

This place is really quiet compared to the normal before COVID.  Makes me wonder if all the SQL folks got laid off.

If EffectiveDate indexed? What does the new execution plan look like for the updated query?

Read that maybe 20 times before I understood. LOL Let me see if I have this right... If this were a "normal" table of component parts...

CREATE TABLE Component(ComponentID INT IDENTITY...

If you have a Calendar table that's similar to one you would use for a Date dimension in DAX/SSAS Tabular, you could just specify the start and end dates of...

https://www.sqlshack.com/get-details-of-sql-server-database-growth-and-shrink-events/

AutoShrink = True?

No. Just No.

progress! I created a Table-valued function to do the BOM stuff, then used CROSS APPLY to join it to OrderDetails, and it worked. (It's an approximation of a Work Order...