the thread above is one you created before with the particular csv file for treasury - I gave you a functional powershell example to download it for their site...

This is going to show how much of a rookie I am.  That code you helped with was...

You...

I think I found answer to my question

https://www.mssqltips.com/sql-server-tip-category/175/reporting-services-charts/

Looks like there IS a way to do it.  I saw the graphs and they look like the ones I am interested in.

SQL...

The problem with Metatstock is that it doesn't handle external data very well.  If I create a query in SQL Server 2019 then there is no easy way to have...

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

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

Excel is simple (or Sheets, etc.)

Power BI is free-ish. Are you looking for yourself or others? Often something I use might be simple and easy, but once I start...

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

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

Anyone able to help me with this?

I found this article online that looks like it does looping through column values.  Is this what I need to do?  I would replace the runningtotal with the bcp command

https://www.mssqltips.com/sqlservertip/6148/sql-server-loop-through-table-rows-without-cursor/

Just...

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

I have another question.  In my example I used header1 values to break up the main table into smaller tables.  If I use a parameterized stored procedure to process it...

that is looking promising.  They give an example:

bcp "SELECT FullName, PreferredName FROM WideWorldImporters.Application.People ORDER BY FullName" queryout D:\BCP\People.txt -t, -c -T

Can the file name "D:\BCP\people.txt" have a...

Thank you for the feedback.  I will definitely test it out to make sure it does what I hope it does.  Thanks again for your help!

I found this article on microsoft website.  Is this what I need to do?

https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqltransaction.rollback?view=dotnet-plat-ext-6.0

I am a rookie so I need some guidance to make sure I am doing the right...