This is a temporary post that was not deleted. Please delete this manually. (25ec04e2-73de-4660-bbb1-fc47490525cb - 3bfe001a-32de-4114-a6b4-4005b770f6d7)

I came around a report, where i need to export the report to Excel in such a way that when it gets exported every Group comes on a different sheet dynamically with the corresponding Group name. This requirement seems difficult at first, however its pretty...

Sometimes when you import data from other system, you may need to clean the data by removing unwanted data. Consider you import data where you want to keep only those which are purely alphanumerals. Here is a way to find out declare @table table(data...

As your SSAS cube gets bigger, cube processing time will become a problem. This is especially true as more and more companies want cube processing during the day instead of the usual off-hours time when no one is using the cube. Partitioning the cube...

To copy a table from another SQL Server Instance is easy. Create a Linked Server on the destination server and reference the Linked Server in the SELECT statement. 1) C reate linked server /****** Object: LinkedServer [SERVER1\SQL_SERVER_INSTANCE_1] Script...

In earlier post we have seen how the email input tag work in the browser. HTML5 comes with lots of new goodies and today we are going to see one of another new html5 input types URL. In most of the sites once you fill your contact and personal information...

You can look up any error message from the command line with "db2 ? sqlxxxx" (where xxxx is the SQLCODE with no sign and leading 0 to make it 4 digits long) You can also use db2 “? SQLxxxx” | more The Linux command – more –...

The challenge is to create a query for a report that shows expiring material. http://beyondrelational.com/puzzles/challenges/108/find-the-expiring-quantity-of-material.aspx