When you define your CTE, you have to specify the column names...

WITH cteExample (FirstName, LastName, IDNo)
AS
(
SELECT fName, LName, NotMySSN
FROM tableX
)
SELECT FirstName, LastName
FROM cteExample
WHERE IDNo > 10;

If you...

• This reply was modified 7 months ago by pietlinden.

Use SUM() instead of ROW_NUMBER()?

https://codingsight.com/calculating-running-total-with-over-clause-and-partition-by-clause-in-sql-server/

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

You don't have anybody building databases in Access do you? That's where I'd look.  My guess is that someone has permissions on your Master Data Services instance that he shouldn't....

the  sp_foreachdb  part?

This may give you an idea... I dumped the result of the query into a temporary table. (Not sure how to parameterize the object name, for some reason.)

            
March 16, 2025 at 7:37 pm
            
#4560844

            
            
                                                
        

This may give you an idea... I dumped the result of the query into a temporary table. (Not sure how to parameterize the object name, for some reason.)

            
March 16, 2025 at 7:37 pm
            
#4560843

            
            
                                                
        

Oh riiiiiiight! (silly me!) ... RedGate has such a tool. (It's a good thing that nobody that works for Red Gate is on here... you know, like Grant or Steve!)

A...

Welcome!  Getting a useful answer can be tricky. So Jeff Moden wrote a great article that explains how to ask a question in such a way that it gets answered....

• This reply was modified 8 months ago by pietlinden.

Oh, like thaaaaaaat! Thanks!  Proof that I almost never write table-valued functions... mostly just lots of Common Table Expressions. Come to think of it, is there a good article that...

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

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...