Generation Cross tab results without using PIVOT in all versions of Sql server One of my friends asked me to write a query to get the cross tabs(displaying one of the Column’s Values as columns of a result set /Pivot). Here are the inputs. CREATE TABLE .( NOT NULL, NOT NULL, NOT NULL, NOT NULL,…
read morePaypal – Its a name vaguely familiar to almost everyone with a Credit Card & the zeal to e-burn some of mummy’s hard earned money. From the user point of view (POV), its all fun provided it doesn’t get you grounded. From the developer POV, its not always sunny in California. For a newbie, its…
read moreWhen we want to add a custom button to a list toolbar we can add it by using a feature.But when we are activating the feature it will be apply to the scope secified, so all the lists present inside the scope will have a button added to it’s toolbar. But if we want to…
read moreA common requirement that every Sharepoint developer is asked for today is customization of the SharePoint site based on various customer specific requirements. Most often customers have requirements where they want to add some additional features to action menus like Site action menu, ECB menu or List/library Action menu, etc. To achieve this, we have…
read moreWhat is GAE ( google app engine )? 1. GAE is a platform provided by google to develop and host your web application. 2. For that you need to develop your application in specific way suggested by GAE i.e. you need to use google datastore to store your data and also there are some limitations…
read moreOpenInviter is an open source free import contact script to get email contacts of the particular user from almost all major email service providers like aol, gmail, yahoo mail, msn hotmail etc. The script is written in PHP and can be downloaded from here. The pre-requirements are common but important. The server will need to…
read moreIn this tip I’m going to share two things, one is how to add your favorite Google products to your website and also how to use Netsuite portlet to add such features on your Netsuite dashboard. Google Web Elements:- This is a feature provided by Google to embed most of its products onto your website.…
read moreTo create a resource in InDesign one has to write a coding lines, be very calculative to give left ,top , right , bottom of the resource correctly so that the resource appears correctly in the UI. To make the things easier we can have the InDesign Plug-in Editor this is a Eclipse plugin through…
read moreWhat is -dry-run? The -dry-run is a method that is used to figure out what are the files that would get actaully updated when you update your svn repository. When and how it is useful? case 1: This is mainly used when you are working in a big team, and before you commit the day’s…
read moreThere are two ways to create MDB database using VBScript. 1. Create MDB by ADO (ADOX): The following code is for creating a new Access2000 database by ADO and for the code to execute MDAC2.0 is required to be installed in the machine. const jet4x = 5 DoCreateNewMDB "F:\MyAccessDB2000.MDB", Jet4x Sub DoCreateNewMDB(FileName, Format) Dim Catalog…
read more