Click here to Skip to main content
15,902,908 members
Home / Discussions / C#
   

C#

 
AnswerRe: Log when windows starta and shuts down Pin
Mc_Topaz4-May-09 2:12
Mc_Topaz4-May-09 2:12 
QuestionDetect mouse click event Pin
Member Ártemis4-May-09 1:34
Member Ártemis4-May-09 1:34 
AnswerRe: Detect mouse click event Pin
Reyals4-May-09 1:48
Reyals4-May-09 1:48 
GeneralRe: Detect mouse click event Pin
Member Ártemis4-May-09 2:32
Member Ártemis4-May-09 2:32 
Questionhow to pass Comparison Operators as parameter to query in C#? Pin
obarahmeh4-May-09 0:20
obarahmeh4-May-09 0:20 
AnswerRe: how to pass Comparison Operators as parameter to query in C#? Pin
Eddy Vluggen4-May-09 0:31
professionalEddy Vluggen4-May-09 0:31 
GeneralRe: how to pass Comparison Operators as parameter to query in C#? Pin
obarahmeh4-May-09 1:26
obarahmeh4-May-09 1:26 
GeneralRe: how to pass Comparison Operators as parameter to query in C#? Pin
Eddy Vluggen4-May-09 7:09
professionalEddy Vluggen4-May-09 7:09 
My apologies, I didn't mean to refer to a CASE statement. What you're looking for is a simpeler IF statement;
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
You can make this stored procedure even simpeler by splitting the query into;
* a view that does the selection of the fields and the joins
* put the filter- and order-statements in a select-query that you run against the aforementioned view Smile | :)

I hope this helps Thumbs Up | :thumbsup:

I are troll Smile | :)

GeneralRe: how to pass Comparison Operators as parameter to query in C#? Pin
obarahmeh4-May-09 22:31
obarahmeh4-May-09 22:31 
QuestionA simple question... please help Pin
Reyals4-May-09 0:08
Reyals4-May-09 0:08 
AnswerRe: A simple question... please help Pin
SeMartens4-May-09 0:16
SeMartens4-May-09 0:16 
AnswerRe: A simple question... please help Pin
OriginalGriff4-May-09 0:18
mveOriginalGriff4-May-09 0:18 
AnswerRe: A simple question... please help Pin
Reyals4-May-09 0:42
Reyals4-May-09 0:42 
AnswerRe: A simple question... please help Pin
OriginalGriff4-May-09 1:02
mveOriginalGriff4-May-09 1:02 
GeneralRe: A simple question... please help Pin
Reyals4-May-09 1:37
Reyals4-May-09 1:37 
JokeRe: A simple question... please help Pin
OriginalGriff4-May-09 1:52
mveOriginalGriff4-May-09 1:52 
QuestionFire enter key Pin
rmedo3-May-09 23:55
rmedo3-May-09 23:55 
AnswerRe: Fire enter key Pin
stancrm4-May-09 0:37
stancrm4-May-09 0:37 
AnswerRe: Fire enter key Pin
Member 44703544-May-09 0:50
Member 44703544-May-09 0:50 
GeneralRe: Fire enter key Pin
rmedo4-May-09 2:46
rmedo4-May-09 2:46 
QuestionSQL SCRIPT Pin
kibromg3-May-09 23:20
kibromg3-May-09 23:20 
AnswerRe: SQL SCRIPT - cross post Pin
Mycroft Holmes3-May-09 23:25
professionalMycroft Holmes3-May-09 23:25 
QuestionCtrl+A short key in listview Box Pin
S K Y3-May-09 23:11
S K Y3-May-09 23:11 
AnswerRe: Ctrl+A short key in listview Box Pin
Christian Graus3-May-09 23:14
protectorChristian Graus3-May-09 23:14 
AnswerRe: Ctrl+A short key in listview Box Pin
sbscb3-May-09 23:23
sbscb3-May-09 23:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.