I did use SQL String manipulations a lot this year. I want to show an example of how to use CHAR. Open your Management Studio – and paste the following in your Query Window SELECT CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15) + CHAR(15) + CHAR(15) + CHAR(15) + CHAR(13) + CHAR(72) + CHAR(65) + CHAR(80) + CHAR(80)+ CHAR(89) + ‘ [...]
One good feature in SQL server Reporting Services is ToolTip . It is a simple feature but has more advantages if you want to show the complete information in a report. Its a great way of saving some Reporting space.I use it when Designing Dashboards or if you want add the redundant columns like the [...]
Problem: A Business User wants to update/insert/delete the values in a table that sits in the metadata of the Datawarehouse on a regular basis. Based on these values numerous calculations will be done in the warehouse which generates a data driven Report on a weekly basis. Initially I got the following Solutions 1. Create a [...]
