Steve,

Could you set up a project in VS Code and make it work like Azure Data Tools? Oh, and post a link to it here. (maybe post it on GitHub)...

Is there are good "Welcome to Visual Studio Code, ADT people!" article somewhere?

(So far, I'm not a fan of VSC... who moved my cheese??!)

Ask anything you want,. If you have a specific question about data, you might want to read this article, because asking a good question is key to getting a useful...

If you used Azure Data Tools for documenting or explaining what the data is saying, what do you use now? Can I cheat and use good old Jupyter Notebooks?

Could we at least have some CREATE TABLE scripts and some INSERT scripts? I'm not feeling that creative today.

What's wrong with the query you have? Does it not work? Or...

How do you get the charting to work at all in ADS? (or is that just laughable?)

I wanted to do a line graph of prices over time, but wow. Is...

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 1 week 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 1 week 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?