Click here to Skip to main content
15,891,423 members
Home / Discussions / C#
   

C#

 
QuestionLog when windows starta and shuts down Pin
Mc_Topaz4-May-09 2:09
Mc_Topaz4-May-09 2:09 
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 
sorry for posting the same question in two places.

I tried your solution as the following:

declare @operator bit;
set @operator = 1;
(
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 = '20090405') AND (CASE WHEN @operator = 1 THEN T.VOLUME_TRADED >= 500 ELSE T.VOLUME_TRADED <= 500 END)
AND (T.TICKET_NUMBER IS NOT NULL) AND (O.SYMBOL_CODE= 'BOP')
ORDER BY ActTime DESC
)
but this did not work , it gives me an error :
Msg 102, Level 15, State 1, Line 10
Incorrect syntax near '>'.

Kind Regards
OBarahmeh

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 
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 

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.