What happens if you remove the settings file from that folder and put it elsewhere? (Don't delete it, just move it.) then restart SSMS? Maybe the settings file is corrupted.

If you want the standard deviation for each record, then just use the non-windowing version of the function.

Do you already have a data source and dataset defined for your report,...

Why are you using a windowing function then? Why not just use a regular aggregate version of the function?

I think I found an answer. It's just a total hack, but I'll test it out.

you basically wrap an insert statement in a  try catch block and then refer to...

Where's the explanation of the pattern? One option might be a cross join and then filter it.

FWIW:

I forced the CAST on the text date, so in the outer query, the date values are real dates, so I can order and filter them.

CREATE TABLE...

If you look up CURSOR on the MSFT site, you'll find examples.

Once you open a cursor (a recordset in Access-speak), you have to loop through it, and once inside the...

Could you not use SSIS to do the import and then delete the files afterward? (or move them to some other directory)

Odd, CONVERT didn't work for me. So I tried it with CAST

CREATE TABLE textDates(textDate char(10) not null);
go

INSERT INTO textDates(textdate) values ('10/01/2022'),('09/02/2022'),('01/03/2024');

SELECT *
FROM (
SELECT textDate, testDate = CAST(textDate...

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

You can download any of the MSFT databases (AdventureWorks etc) from Github.

See this article: https://learn.microsoft.com/en-us/sql/samples/sql-samples-where-are?view=sql-server-ver16

I'd go the backup file (.bak) route. Super easy.

A thousand years ago, I tried doing this in SSIS, but the PowerQuery source works like... well, not at all. =(

Here's the beginning of the conversation: SSIS task that...

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

I was basically just playing with DAX Studio when I discovered it could export the result of my PowerQuery.

I suppose I could just copy and paste my PowerQuery into Excel...

Okay, just a quick update... I got the PowerQuery working (Text.Combine in PowerQuery is my new best friend!!!) Here's the PowerQuery:

let
    Source = Folder.Files("C:\Users\User\OneDrive\Documents"),
...

Sounds like a hideous design.

Why not just put all the data in the same database with a foreign key column to the server name? Then you don't need any dynamic...

Okay. The other way I was thinking of doing it was to write a query to find changed prices each week (since he only sells cnce a week) and then...