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

Here's a post from Erland Sommarskog...

passing parameter to stored procedure in bcp command

then all you'd have to do is loop over the list of values to pass into the stored...

use BCP OUT with a parameterized stored procedure to get the data you want?

See Example G on this page: bcp Utility - SQL Server | Microsoft Docs

You could filter on TaqIndex... something like

WHERE TaqIndex % 30 = 0, and then you'd only pull a small fraction of the records. Instead of 30, try a larger number......

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

Why are you even setting the IDENTITY property on a temporary table that you're inserting data into that already has a PK? Are you going to insert data from another...

Are you basically trying to find the largest islands you can (contiguous sets of dates)? (Basically where you find the start date and end date for each "island".)

that's a Gaps...