C#

I am BATMAN wrote:

at most the assignment should be the next line down

IF @MyBIT = 0 THEN
BEGIN
  SELECT [..]
   WHERE >=
END
ELSE
BEGIN
  SELECT [..]
   WHERE <=
END

I are troll

DECLARE @operator BIT;
SET @operator = 1;

IF @operator = 1 THEN
BEGIN
    SELECT DISTINCT 
        T.TICKET_NUMBER AS TicketNum, 
        A.DESCRIPTION AS Action, 
        O.SYMBOL_CODE AS Symbol, 
        T.TRADE_PRICE AS Price, 
        T.VOLUME_TRADED AS FillVol, 
        T.EXTENDED_PRICE AS TotalValue, 
        T.SUBMITTED_TIME AS ActTime, 
        T.SUBMITTED_DATE AS TransDate
    FROM TSDETL AS T 
    INNER JOIN TSORDR 
        AS O ON O.SUBMITTED_DATE = T.SUBMITTED_DATE 
        AND O.TICKET_NUMBER = T.TICKET_NUMBER 
    INNER JOIN TSORDA 
        AS A ON O.ORDER_ACTION = A.ACTION_CODE
    WHERE (T.SUBMITTED_DATE = @SUBMIT_DATE) 
        AND (T.VOLUME_TRADED >= @Volume) 
        AND (T.TICKET_NUMBER IS NOT NULL) 
        AND (O.SYMBOL_CODE= @Symbol)
  ORDER BY ActTime DESC
END
ELSE
BEGIN
    SELECT DISTINCT 
        T.TICKET_NUMBER AS TicketNum, 
        A.DESCRIPTION AS Action, 
        O.SYMBOL_CODE AS Symbol, 
        T.TRADE_PRICE AS Price, 
        T.VOLUME_TRADED AS FillVol, 
        T.EXTENDED_PRICE AS TotalValue, 
        T.SUBMITTED_TIME AS ActTime, 
        T.SUBMITTED_DATE AS TransDate
    FROM TSDETL AS T 
    INNER JOIN TSORDR 
        AS O ON O.SUBMITTED_DATE = T.SUBMITTED_DATE 
        AND O.TICKET_NUMBER = T.TICKET_NUMBER 
    INNER JOIN TSORDA 
        AS A ON O.ORDER_ACTION = A.ACTION_CODE
    WHERE (T.SUBMITTED_DATE = @SUBMIT_DATE) 
        AND (T.VOLUME_TRADED <= @Volume) 
        AND (T.TICKET_NUMBER IS NOT NULL) 
        AND (O.SYMBOL_CODE= @Symbol)
  ORDER BY ActTime DESC
END

I are troll

public static void asdf() {
   String anotherstring;
   Class1 myObject = new Class1();  // here you create a object reference
   myObject.astring = anotherstring;
}

public void asdf() {   // don't use the static-keyword here
...
}

namespace WindowsFormsApplication3
   {
   class Class1
      {
      public String astring;
      public static void asdf()
         {
         String anotherstring;
         astring = anotherstring; //It doesn't like this
         }
      }
   }

Class1 c = new Classs1();
c.asfd();

public class Demo
    {
    public static string s1 = "Hello";
    public string s2 = "Goodbye";
    }

static void Main()
    {
    Console.WriteLine(Demo.s1);
    }

static void Main()
    {
    Console.WriteLine(Demo.s2);
    }

static void Main()
    {
    Demo d = new Demo();
    Console.WriteLine(d.s2);
    }

Demo d2 = new Demo();