How to close all child windows on closing/logout of Main page/window (Asp.net web application)

In many web portal applications, there are lots of popup windows get opened when users navigate to some links or there may be some popups window providing some relevant information. These popups may get opened when some specific events occur on the site or may be opened by user’s click. In this flow of site, at a [...]

Read Full Post »

Passing multi-value parameter in stored procedure (SSRS report)

In SSRS reports we can have multi valued paremeters, which means we can select multiple values for that parameter and based on all those selected values result in the report is shown. We can write the SQL query to pass those parameter’s values and populate the data set, but sometimes it is required or to [...]

Read Full Post »

Using/Creating an alias for SQL Server 2005

Scenarios of Use: We may want to redirect the connection of an existing application to a different database server without modifying the connection string which might be needed if the database has been moved to a different server and previously used server is no more there. We don’t want to expose the actual server name [...]

Read Full Post »

Customizing ‘Subtotal’ expression by using Inscope function in Matrix Reports (SSRS)

In SSRS Matrix reports there is an inbuilt functionality to have the Subtotal of columns/row fields depending upon the scope of the group in which subtotal is defined. If it is defined in the scope of any row group it will sum up all the values across all the column groups but taking the specified [...]

Read Full Post »

SELECT list ‘alias’ in the WHERE or GROUP BY clause

While executing the SELECT queries in SQL server, many times we need the desired output column aliases and for that we end up writing the TSQL queries like this: SELECT Col1 AS MyColumn FROM Table1  This works fine also for any number of columns. But at the same time we may require to put some [...]

Read Full Post »

Passing more than 9 parameters to a batch file

It is of a common practice to write a batch file to execute the commands using some command line utilities like OSQL. And to provide the required parameters to that command line utility, we just set some variable in the command file and pass them as parameters to the batch file containing the commad to [...]

Read Full Post »