SQL Server: Using CASE statement in Order By clause
http://munishbansal.wordpress.com/2008/04/27/sql-server-using-case-statement-in-order-by-clause/Inserting
Modifying the Data Type of a column having data:
http://munishbansal.wordpress.com/2008/09/11/modifying-the-data-type-of-a-column-having-data/
Yield Statement in C#
http://munishbansal.wordpress.com/2008/09/12/yield-statement-in-c-useful-linq-statement/
Explicitly Inserting values to Identity Column
http://munishbansal.wordpress.com/2008/10/03/explicitly-adding-values-to-idenetity-column/
Static Class versus Static members (C#)
http://munishbansal.wordpress.com/2008/10/04/static-class-versus-static-members-c/
Implicit versus Explicit Interface implementation (C#)
http://munishbansal.wordpress.com/2008/10/06/implicit-versus-explicit-interface-implementation-c/
Detecting ASP.NET (C#) Browser Refresh
http://munishbansal.wordpress.com/2008/10/11/detecting-aspnet-browser-refresh/
Passing more than 9 parameters to a batch file
http://munishbansal.wordpress.com/2008/12/21/passing-more-than-9-parameters-to-a-batch-file/
Customizing ‘Subtotal’ feature by using Inscope function in Matrix Reports (SSRS):
“OnVariableValueChanged” Event Handler in SSIS Package
http://munishbansal.wordpress.com/2009/02/04/onvariablevaluechanged-event-handler-in-ssis-package/
Hi Munish,
Commendable work done..
Recently while Workin on SQL Server’05 I could not change the table name using T-SQL.
Finally I had to do it manually…
Is there a way we can do the same using TSQL??
Hey Amar,
Thanks for the compliments…
Regarding your question..we have a system SP used to rename the table name, column name etc
It takes three params (@objname, @newname, @objtype)
like:
Execute sp_rename ‘Old tablename’, ‘New tablename’, ‘object’
Note: @objtype can have values like ‘column’ ‘database’ ‘index’ ‘object’ ‘userdatatype’
-Munish
Thanks!!
Hey hi munish,
i just wanted to know how we can use a user defined functions in our reports in SSRS?
Munish,
What is the best approach for placing text at a particular (x,y) coordinate. I am doing fine with the left right, but I can’t seem to get the top to bottom alignment correct. Do you have any suggestions/examples that might help with this issue. I have to print my report on a preprinted form and the data I print has to go in specific locations on the page.
Let me know any ideas that you might have.
Thanks,
Charles
Keep up the good work on this blog!
Good points
Thank you for a great post.
Great article: “Passing multi-value parameter in stored procedure (SSRS report)”
Can you please explain how to get this workinging 2008R2?
Thank you
retha