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')
Hi, Complete newbie to logparser... I had an exchange 5.5 site lose WAN connectivity recently. Their inbound mail sat in the MTA queue for two days, then they all got NDR'd (something timed out i assume). Now the connection is back, the users want their email! I've told them they can't, but that I should...
Mowser
