Month: April 2006

April 26, 2006

I work in a company that has alot of headstrong people. really intelligent one’s if i may add. and in this kind of environment… trust me, you dont want to get caught in an arguement with this guys because they wont fizzle down… everybody has his on take an everything making its really challenging to raise […]

Continue Reading
April 18, 2006

Here is some samples on how to use cursors in SQL to do updates and deletes on records. Nothing fancy, just pure t-sql code. 🙂 Updating records using cursors SET NOCOUNT ONDeclare @AccountNumber varchar(20)DECLARE AccountNumbers CURSOR FOR (    select AccountNumber from OldAccountsTable    where AccountNumber between ‘0807200’ and ‘0807999’)OPEN AccountNumbers    FETCH NEXT FROM AccountNumbers INTO @AccountId    WHILE @@FETCH_STATUS = 0        BEGIN            UPDATE […]

Continue Reading
April 3, 2006

Working in the financial industry is a tough job, specially if you are in the IT department. There are alot of factors that you need to consider whenever you build an application.. theres those State Laws that you need to follow.. corporate guidelines… And at the end of the day after you have followed all these […]

Continue Reading
April 2, 2006

Here’s a short code that checks to see if the current application is already running. using System;using System.Collections.Generic;using System.Text;using System.Diagnostics;namespace KeithRull.CS.Windows.CheckIfAppIsAlreadyRunning{   class Program   {      static void Main(string[] args)      {         if (IsAppAlreadyRunning())         {            Console.WriteLine(“This application is already running… Press any key to exit.”);         }         else         {            Console.WriteLine(“App now running!”);            // … do whatever you want to do here.         }         Console.ReadLine();      }      public static bool IsAppAlreadyRunning()      {         bool isAlreadyRunning = false;         Process currentProcess = Process.GetCurrentProcess();         Process[] processes […]

Continue Reading