In Sql Stored Procedure we can use 2 type of parameters 1) INPUT PARAMETERS 2) OUTPUT PARAMETERS. Input Parameter is only one way parameter while Output parameter is 2-way. Besides these two parameter  Stored Procedure also return an Integer value that is by default 0. This returning value is ... [More]

Once i had a requirement to exclude some columns when we export the SSRS report to excel. It was the business requirement to exclude those from excel as they only want the user to see some particular columns and rest of the columns were of no use for them as these columns were having having some link to other sub reports.

[More]