What if more than one dept wants access to the same report?
SSRS can become quite crowded as reports are added. Creating folders for departments can help organise and group reports for business use. Then setting get up security for each folder to restrict users if that's how the business operates.
Creating a linked report from the source report is straight forward and allows groups of users to utilise the report from different folders. When on the web site for your reports, Manage the report and go to Properties the click Create Linked Report. Follow the simple instructions to place the linked report into a target folder.
The Description window in job properties is not overly text rich, like notepad you can't format text which is fine because this purely for brief information on what the job does etc.
The one thing I found really useful is using the keyboard shortcut CTRL - ENTER. This adds a carriage return and creates a new line for text, nice.
I discovered today that you cannot do a UNION in conjunction with If Statements in a SELECT.
If you know different please post it HERE!
I use this product and it's pretty good. It struggles sometimes with dealing with multiple servers but you can break those down to more manageable jobs so that it does not error during processing. On the whole, its a great piece of software which describes and documents your databases using the extended properties as the descriptors.
Tip: It's a very good idea when using SQL Server Extended Properties to decide what you are going to use use as a label i.e. 'MS_Description' and then use this label all the way through your descriptions for Tables, Fields etc. The reason for this is that Apex SQL Doc can only use one label so if you have different labels sprinkled throughout your database you won't see them all when you carry out your database documentation.
I have been using this tool for a few years now and can tell you it saves me a lot of time from re-writing T-SQL. I also love the new History tab so all those SSMS Queries you closed down thinking you didn't need them and then discover in fact you did? Well the history tab remebers what you typed and allows you to reteive your work, no more lost work!
The SQL Format function is brilliant, no more messy code!
Enjoy!!
SQL Assistant equips database developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy. SQL Assistant can boost your SQL coding productivity by 300%. SQL Assistant supports all major databases. It is shipped pre-configured with support for Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, Sybase ASE and SQL Anywhere. The product also offers a full-featured source control interface that supports the Subversion and Microsoft Team Foundation Server code repositories. Many users have stated they don't know how they can code and manage their databases without SQL Assistant. To get a better idea of what it can do for you, download the trial and check it for yourself.
I'll start the list, but feel free to add to it or give me your thoughts. I think someone ought to be able to understand these items and write code to solve problems that involve:
finding duplicate rows (grouping, joins)
returning aggregates of single or multiple columns (MAX, MIN, SUM, COUNT)
return aggregates in groups, or islands. (grouping and aggregates, windowing)
join multiple tables together on matching, multiple columns (joins)
find data in one table that doesn't have matches in another (outer joins)
filtering data (WHERE) subqueries and complex CTE joins of data
create row numbers and join back to a table without numbers (APPLY)
pivoting data from rows to columns
