devxlogo

Tip Bank

Enumerate Treeview Nodes Recursively

Trying to parse a set of TreeView nodes and their children’s nodes and their children’s nodes can be confusing. This algorithm makes the process easier. Recursion describes an algorithm that

Representation of Floating Point Numbers

People sometimes complain about the inaccuracy of floating point arithmetic. To demonstrate the level of floating pint inaccuracy, consider the following program: #include using namespace std; int main() { float

Default Date Format

Question: I have an issue with date formats. I have a VB client piece of software that generates a select based on a particular date. However it only works on

Access CGI Environment Variables

Question: Can JavaScript access CGI environment variables? Once a user has logged into my site, I would like to retrieve the user name from the “REMOTE_USER” variable. Answer: No, there

Integration of Replication and DTS Steps

Question: I am trying to build a warehouse. The steps involved are: Make a snapshot replication of the OLTP onto the staging area. Run a DTS package that makes transformations

Deleting Duplicate Rows

Question: I have this table: declare tbl1 (x int,y int,z int); I don’t have a column I could use as a unique key. There are some duplicate rows (not just