If you want to build dynamic rolling dates, consider building and joining to a date dimension (as in a data warehouse).

The date dimension would have an integer datekey and a...

You should be able to build a .bat file based on the following help page:

https://help.tableau.com/current/online/en-us/to_refresh_extract_commandline.htm

Ah okay.

Another option: a scheduled task that runs on SQL Server agent and checks for a file existing on a shared area (users put the config file there).

It takes the...

Check what the default database is for the two users. If it is different, it could explain the difference in performance (he says, based on bitter experience....).

Two options as I see it (along the lines of what Phil mentioned):

Create a view that unions the header, body and footer rows as a single column output.

Create a dtsx...

If the package is on a server and the person has SSMS installed, couldn't you just create a SQL Server Agent Job that runs the package and give the person...

Example approach based on what you've asked for.

If you want something else, as the others have said, ask a better question next time.

WITH tblStudentMarksOriginal
AS (SELECT CAST(101 AS...

Based on the image, it looks like the number of hyphens in front of the number determines the order of the numbers to be concatenated.

The desired output looks to be

FIRSTNUMBER-SECONDNUMBER-THIRDNUMBER----

If...

Scott, won't you include all times between 6 and 7 with that? 06:32 for example?

I'd propose something like:

DATEDIFF(SECOND,CAST(date_col AS DATE),date_col) < 21600

where you return all rows where...

I'm confused.  It thought "BI" tools, like the all powerful, wonderous, "can't-live-without-it" Power BI,  were supposed to make such things easy without having to write SQL for them.

Also, it's...

Will row_number() serve your purpose?

In the data flow, right-click on the succession arrow and choose Enable Data Viewer

Is there a business rule for which of the three values are cancelled out by the two 853.95 entries?

Just curious because the solution from Des may not be bulletproof without...

Sure. Instead of IN (your dates here)

Use BETWEEN VARIABLEA AND VARIABLEB

Declare your variables at the start.

DECLARE @StartDate DATE = '2020-01-01';
DECLARE @EndDate DATE = '2022-10-05';

SELECT ID, TRANSACTION_DATE, ...

Is there a problem with doing it in one query?

For example,

SELECT ID, TRANSACTION_DATE, COUNT(*)
FROM
XYZ
WHERE TRANSACTION_DATE IN (your dates here*)
GROUP BY ID, TRANSACTION_DATE

* The your dates here section...