Okay, let me try that again.

Since you're new... one thing that's extremely helpful to know is in Jeff Moden's article about how to ask a question so that it gets...

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

I don't know, but the first place I would look is at Rob Sewell & Chrissy LeMaire's dbaTools (using PowerShell). I'd be surprised if it weren't built in.

Is this a for real question or a homework assignment?

You could import the data to another table, and join the two on ColumnA from your sheet and show the value...

running total of 1 divided by ROW_NUMBER() over some partition?  That's what the sequence {1, 0.5, 0.33, 0.25, 0.2} implies. Where's the problem? If you really had to, you could...

look up STRING_AGG()

Use DATEFROMPARTS ( year, month, day ) and EOMONTH ( start_date [, month_to_add ] ) to get the first day and the last day of a month and then use...

Do you mean doing running totals and dividing by some value in the current record?

Use a windowing function to do a running total, then divide.

PowerQuery can get data from your database. then merge. Depends on what tools you have available.

Looks like you can drop a rectangle onto your report canvas and then put the two textboxes from the parent and then a tablix based on the child table inside...

You'd have to check for zero in the divisor first. There's no DIVIDE() function in T-SQL.

IF(divisorColumn = 0, NULL, NumeratorColumn/DivisorColumn)

Reporting Services? Depends on what you're trying to do.

if you want fully interactive charts, that's more PowerBI/Excel

if what you're doing is purely financial stuff, Metastock may be just what you need. I would wager that there's been a ton of thought and expertise built into the...

I would look at PowerBI and Excel. You can use stored procedures and views as data sources if you want. What kinds of graphs etc did you want to create...

See what kind of data? From where?

"I want to know what kind of car or truck I should buy, but I can't tell you how I'm going to use it."

Excel...

Here's one post by Erland answering a similar question.

Then you'd have to do something like create a cursor (I think) to pass the values from

SELECT DISTINCT header1 FROM tableMain...