|
|
-
|
|
To format number to two decimal point into SSRS (Reporting Services),
1. goto Properties, in **Format** enter **n2**...
|
|
-
|
|
I was watching today's [Mar 7 2012] launch event sessions, when in one of the session on Powerview, the speaker mentioned that one can export PowerView reports to powerpoint (ppt) - Not only that, There's a **"click to interact"** button on slides that ...
|
|
-
10
Liked
| 10
Learned
| 2
Comments
|
|
Set `ARITHABOBRT` and `ANSI_WARNINGS` as OFF to handle division by Zero error
SET ARITHABORT OFF
SET ANSI_WARNINGS OFF
SELECT 1/0
This will not throw an error. Result will be NULL
...
|
|
-
|
|
Step:1 Open Visual Studio 2010.
Step 2 – Go to Tools -> Options -> Text Editor -> All Languages. Then, unchecked the Auto list members check-box.
Thank You
Kirti Darji...
|
|
-
|
|
Reporting Services has a system database called "ReportServer" (default) which it uses to store the information related to reports, data sources, report execution etc. stored/accessed on the Report Server.
A table called "Catalog" stores the informatio...
|
|
-
10
Liked
| 11
Learned
| 0
Comments
|
|
C# team members Shon Katzenberger, Scott Wiltamuth, Todd Proebsting, Erik Meijer, Peter Hallam, Anders Hejlsberg, and Peter Sollich were awarded a Technical Recognition Award for Outstanding Technical Achievement for their work on the C# language. This ......
|
|
-
|
|
Here is 3 shortcuts in visual studio, that today i learned, which increases productivity.
F9 - To set a break point, Clicking again on that will remove that break point.
Ctrl + K, d - To format the page
Shift + Del - To cut the current line, wit......
|
|
-
|
|
I just went through the SQLCMD command line utility to perform database backup in sql server where it does not have sql agent. Below is the command which i placed in batch file and schedule with windows task scheduler.
[CODE]
Sqlcmd -UUserName -PPas......
|
|
-
|
|
I would like to brush up one of the basic concept.
We can use SELECT column alias in ORDER BY clause. But we can't use in GROUP BY clause.
The reason is, ORDER BY clause is processed after the SELECT statement; GROUP BY clause is processed before the ......
|
|
-
|
|
LEAD() and LAG() are interesting functions introduced in SQL Server 2011 CTP3, which will be used to get previous and subsequent rows values
1. LEAD() : Used to access data from a subsequent row in the same result set without the use of a self-join.......
|
|