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 3 years, 9 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...

Oh, you've GOT to be kidding. I'm not downloading that. Post your CREATE TABLE statements, and maybe a handful of INSERTs for each table to show the relationship. Foreign keys...

What I want to do is to exit the while loop after it finds the top record for each tank.

How would one determine that programmatically? TOP doesn't mean anything without...

Different how? Different filters? different columns?

IF @Selection = 1

BEGIN

SELECT...

END

IF @Selection = 2

BEGIN

<other> SELECT...

END

Different filters would be a whole lot easier. Maybe use COALESCE() to ignore some empty parameter values and...

Why not put all the views you want to expose in a single schema, and then just grant rights to the schema?

Sorry for the roundabout answer, but I'd check with Chrissy LeMaire and Rob Sewell, because they literally wrote a book about manipulating SQL Server objects with PowerShell.

Learn DBATools in...