|
|
-
|
|
These properties are useful when you export reports to Excel workbooks. Use the **InitialPage** property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the **PageName** property to provide differ...
|
|
-
|
|
Set the following properties on group for reset page number.
1. Select the grouping pane and hit F4 to show the Properties window for the Tablix.
2. Expand the Group and the PageBreak properties.
3. Change the value for BreakLocation to break for...
|
|
-
|
|
The Regex functions are useful for changing the format of existing strings, for example, suppose you want to display Phone no in (ddd) ddd-dddd format instead of ddd-ddd-dddd. To do this, Right click on the required textbox --> click expression... and e...
|
|
-
|
|
Being into application support we check daily and weekly jobs schedule status that has been scheduled in SQL server in many servers for different projects. I wrote some queries to get the status as below.(if you have better solution please comment)
We ...
|
|
-
|
|
To format number to two decimal point into SSRS (Reporting Services),
1. goto Properties, in **Format** enter **n2**...
|
|
-
|
|
Just learned from Pinal's blog about right align the numeric value in output pane of SSMS.
Go to Tools -> Options -> Query Results -> Results to Text, Check the checkbox, "Right align numeric values"
Once this setting has been done, when the query is...
|
|
-
|
|
In profiler you may need to include RPC:Starting or RPC:Completed events. It will show dynamic query in **TextData** column like *****exec sp_executesql......etc.*****...
|
|
-
|
|
Both mean that an user could generate their own reports and they are shielded from underlying data infrastructure. This empowers end-users as they do not need to always ask IT for help..
A one-line statement about [powerview][1]: Delight users with an ...
|
|
-
|
|
If you ever add a default constraint on a table without giving it a name, SQL Server will give it a somewhat random name which you cannot guess.
To drop those constraints such a query might come in handy:
DECLARE @query NVARCHAR(MAX)
SET @query...
|
|
-
|
|
I was looking into some table creation scripts in source control today. I found that the developers used two ways to check if the table exists in the database.
Few scripts employed `information_schema.tables` vs `sys.objects`. I personally, have been ...
|
|