custom query
-
hi i have a table with following schema
MsgID SystemID Msg Date(YYYY-MM-DD)
1 1 "" 2009/01/02
2 1 "" 2009/04/03
3 1 "" 2009/05/02
4 2 "" 2009/01/01I want to identify the SystemIDs which has messages (column : Msg) generated with a Time difference greater than 3 months In the given table its systemID "1" . ( logged first message on 2009/01/02 and after 3 months 2009/04/03). please help to get a proper query
My small attempt...
-
hi i have a table with following schema
MsgID SystemID Msg Date(YYYY-MM-DD)
1 1 "" 2009/01/02
2 1 "" 2009/04/03
3 1 "" 2009/05/02
4 2 "" 2009/01/01I want to identify the SystemIDs which has messages (column : Msg) generated with a Time difference greater than 3 months In the given table its systemID "1" . ( logged first message on 2009/01/02 and after 3 months 2009/04/03). please help to get a proper query
My small attempt...
And what have you tried so far, or are you expecting someone to write the query for you. Some hints. Select top #n datetime dateadd datediff row_number() partition over
Never underestimate the power of human stupidity RAH
-
And what have you tried so far, or are you expecting someone to write the query for you. Some hints. Select top #n datetime dateadd datediff row_number() partition over
Never underestimate the power of human stupidity RAH
don't understand. plz send codez ASAP to lazy@yahoo.in :)
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.