Viewing 15 posts - 736 through 750 (of 6,678 total)
If all you want is the ability to lookup and access your queries - then you might consider Azure Data Studio instead of SSMS. That does allow you to define...
November 15, 2021 at 4:00 pm
What is the expected result? How do you want the data returned?
November 10, 2021 at 6:38 pm
https://docs.microsoft.com/en-us/power-bi/guidance/migrate-ssrs-reports-to-power-bi
That is the first article I found searching - so it looks like it is possible.
November 9, 2021 at 10:50 pm
Along with what Grant has stated and since they said it did "regular" SQL Backups, have them do a test restore using native tools only to prove...
November 9, 2021 at 10:37 pm
This is not going to allow index usage in the join: AND KeyValue = (co.co_num + '-' + CAST(coitem.co_line AS VARCHAR(10)) + '-0' )
Further to @JeffModen's idea - create a...
November 5, 2021 at 8:01 pm
Too bad you didn't migrate to the catalog - that would take care of these kinds of issues as well as provide additional features that are not available for package...
November 5, 2021 at 7:43 pm
Not sure how to help then - the choices are pretty clear for SSRS related reporting. You can build a wrapper in your application around the reporting server - with...
November 5, 2021 at 6:31 pm
Understood but that's not my question. To be more clear, you stated that...
I'd rather write components in a project written in C# that yield the results that...
November 5, 2021 at 4:57 pm
First comment - make sure you use the table aliases in your sub-queries. This not only helps identify what you are comparing - but if you reference a column that...
November 4, 2021 at 10:16 pm
That is not an error - it is a warning. When you delete a login - if that login is associated with a user in any database that user will...
November 4, 2021 at 10:05 pm
GROUP BY or DISTINCT or ROW_NUMBER() or RANK() or DENSE_RANK() - or maybe a CROSSTAB/PIVOT.
Any of those might be the right solution, but without sample data and expected results -...
November 4, 2021 at 7:52 pm
Not sure if you were asking for more details - seems you found the answer. For earlier version of the ACE drive - the parameter was /passive vs /quiet for...
November 4, 2021 at 7:47 pm
It really comes down to how you want to architect your reporting solution. If you need to embed the reports into your application - then using RDLC reports is a...
November 4, 2021 at 6:00 pm
I think you are looking for RDLC reports - which are standalone Reporting Services reports. Here are a couple of links to get you started:
https://www.c-sharpcorner.com/article/beginners-guide-for-creating-standalone-rdlc-reports-with-s/
If you search: ssrs 2019 rdlc...
November 3, 2021 at 6:50 pm
SQL Server Management Studio is a 32-bit application - and therefore requires the 32-bit version of the drivers for Office based applications. However, many are now installing the 64-bit version...
November 3, 2021 at 6:42 pm
Viewing 15 posts - 736 through 750 (of 6,678 total)