T O P

End user Transfer variable to SQL to get results in a Excel file? MS SQL

End user Transfer variable to SQL to get results in a Excel file? MS SQL

hasanyoneseenmymom

Another user suggested SSRS, that's probably the easiest way to do this. Another option is to create a simple website, perform some validation on the input (to prevent sql injection and bad values) and then use a sql tool to run either the raw sql or a stored procedure on the database. If you go with a .net/core approach, you could knock this out in an afternoon with entity framework. I'm sure there's angular and node approaches too but I'm not a fan of javascript so I don't know the options there.


Clear-is-a-Color

If your dataset isn’t too large and the user input/filtering is minimal, could you pull all of the data in to a refreshable spreadsheet and let them use filters on the columns? I may be oversimplify your question.


mikeyd85

SSRS can do this. It's not the fastest thing in the world when it comes to generating large datasets in a spreadsheet, but it'll do the job. Look in to that. Suspect its the easiest thing you can do without exposing end users to any SQL at all.