Is there an article somewhere that explains how to make VS Code work like Azure Data Studio?

Either I'm doing it completely backwards or I'll just stick with some antiquated software...

• This reply was modified 8 months, 3 weeks ago by pietlinden.

They're not going to update it anymore I read... kind of a bummer because it's great for documenting / explaining a series of queries.

(or for your exploration of a dataset/database)......

• This reply was modified 8 months, 3 weeks ago by pietlinden.

Yeah, I know... day late and a dollar short since ADS is going away. Is there a good tutorial on creating graphs that aren't absurd in ADS? (I'm just graphing...

Only a 17 year old thread... should be graduating from high school this year.

LOL. With what?

Post the code that's causing the problem. And while you're at it, you may want to post the table definitions for all the tables involved.

I think you're looking for CROSS APPLY.  Something like this will work:

/* create the dummy Assessment table with the repeating fields  (UM#) */
CREATE TABLE Assessments(recordID INT,...

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 10 months ago by pietlinden.