We have a very large email account where all spam email is stored. Before I delete these emails I'd like to try to find out if any were erroneously filtered as spam by checking the sender address against a list of email addresses from our CRM system. These email addresses are stored in a Microsoft...
Yes, I know that, it was more how syntax-wise to make the IF statement.. i'm not sure how exactly to put it up. It must be something about asking how long the string is (of number), and accordingly adding needed zeros.. It's more like.. how? :)
Okei, thanks for the verification =), i think this is really close to the best way i can get it.. The only thing what would make it even greater, was if i could somehow make further grouping by TitleID.. I've once done it by mistake (other query example).. .but it, like, created several "outputtables...
Yes, that is exactly what I would have suggested to you. For further education, read the part of the help file on Aggregate Functions. When you group your results in a GROUP BY, any fields that are not part of the group by can be displayed by using aggregate functions to "sum them up".
Hi guys, i'm having a little trouble with this one... To get it right , i think i have explain my case properly. I need to find out how much time users are spending on specific pages, and due to technical issues on the frontend, the webapplication will send a time-"tick" every 10 secs or so.. I want...
Yes, LP doesn't support that type of sub-query. You'll have to do it in two passes.
Hello, I'm trying to extract the unique users using Windows Mobile devices. However the below sql statement isn't working in the logparser GUI. Does anyone know what is wrong with this query? Select Count(*) From (Select cs(User-Agent), cs-username FROM 'c:\ex070322.log' where cs(User-Agent) like 'MSFT...
[QUOTE User="LogParser User : juasebsto"]Quote: Hey.. i dont tknow if this is what u need, but it works for me: WHERE date >= TIMESTAMP( '2006-09-28 00:00:00', 'yyyy-MM-dd hh:mm:ss' ) AND date <= TIMESTAMP( '2006-10-28 00:0...[/QUOTE] Hi there, Thanks very much for your answers. You may be think...
Hey.. i dont tknow if this is what u need, but it works for me: WHERE date >= TIMESTAMP( '2006-09-28 00:00:00', 'yyyy-MM-dd hh:mm:ss' ) AND date <= TIMESTAMP( '2006-10-28 00:00:00', 'yyyy-MM-dd hh:mm:ss' ) Cheers
this should work: WHERE TO_TIMESTAMP(Date,'yyyy-MM-dd') = TO_TIMESTAMP('2007-02-10', 'yyyy-MM-dd')
Mowser