Implementing Multilevel Ranking in T-SQL
You might have a table with different PEOs for each Company ID. For example: Table name : tblRankingCid peo———– ———–1 200003311 200006301 200009301 200012312 200003312 200006302 200009302 20001231 To give
You might have a table with different PEOs for each Company ID. For example: Table name : tblRankingCid peo———– ———–1 200003311 200006301 200009301 200012312 200003312 200006302 200009302 20001231 To give
This is a SQL trick for spreading out data across months on a single row. It also works with Sybase TSQL. The 1-ABS(SIGN()) function will evaluate to zero for all
The JavaScript Array intrinsic object (and others) can be extended to include user-defined functions in the object definition. These extensions can be placed in a .js file and included in
C++ smart pointers are the idea of using a selector to access a class. This gives the class writer an option to control access to class members and function. For
Creating dynamic Microsoft documents may be useful. The problem is that creating Word documents in ASP will result in an error saying that IIS cannot run out of process components.
This code shows how to get value from the control irrespective of the control type used in the client side Javascript. function GetValue(ControlName,FormName){var Control=document.forms[FormName].elements[ControlName]alert(Control.type) switch(Control.type) { case “select-one”: case “select-multiple”:
Using Count(*) is generally better than using Count() with a specific column name, because it gives the query engine the flexibility to find out the row count any way it
You can make a privately inherited member public by specifying its access modifier in the derived class. For example: #include class base{ public: int a; int b; base() { a=10;
When initializing parameters in a constructor, the order of initialization will not be the same as the order in which you typed them. The order of initializing parameters is ‘as