Search results for query: *

hi george, YES IT MAKE SENSE NOW! (and i accomplished to modify your code for my real data) in germany we would say "HUT AB!" ("HATS OFF!") for that cool code! ok, it is really slow with many rows (i've tried with ~3000 rows -> ~15min on a Quad Xeon with 8192 gig RAM), but... who cares ;) so i...

oh fu... you're right, the times should be different, my mistake, but i've tested it with correct times and... it works!! :-D cool, big thanks for your code! now the only thing for me to do is... how could i understand your code!?! ;-)

hey, your query seems to be nice, but the last 2 rows (05:33 and 06:34) are not in the result, but they have to... (the last both lines)

hi george, thanks for your afford i will try it out.. to your question: time Name Value 15.09.2006 01:10:00 Win-RT_Kreda_15561 0 15.09.2006 01:11:00 Win-RT_Kreda_13725 100 15.09.2006 01:20:00 Win-RT_Ebila_15561 0 15.09.2006 01:40:00...

great, big thx to you vbkris

uhh, i think i coulnd't explain it excatly, it's similar to these post: http://www.tek-tips.com/viewthread.cfm?qid=934648 (but i don't understand these complex sp) example with only one name: time Name Value 15.09.2006 01:10:00 Win-RT_Kreda_15561 0...

we are on the way... ;) the code: SELECT tab1.time,tab1.Name, tab1.value FROM tab1 INNER JOIN ( SELECT [NAME],count(VALUE) as count1 FROM tab1 WHERE tab1.VALUE=0 GROUP BY [NAME] HAVING count(VALUE)>2 ) AS DuplicateTab1 ON Tab1.[Name]=DuplicateTab1.[Name] WHERE value=0...

thx for your fast answer, but your query won't work: original table: time Name Value 15.09.2006 01:10:00 Win-RT_Kreda_15561 0 15.09.2006 01:11:00 Win-RT_Kreda_13725 100 15.09.2006 01:20:00 Win-RT_Ebila_15561 0 15.09.2006 01:40:00 Win-RT_Kreda_15561 0 15.09.2006...

hi, i have many troubles with a stored procedure which should select lines that have 3 or more times the same result value. the table is a logfile table and the structure coulnd't be edited by me: TIME NAME VALUE 0000 Smith 100 0013 Josh 100 0014 Smith 0 0320 Smith 0...

hi, that isn't really difficult: select TOP 10 * from xyz order by [Name] cya andy

no that isn't possible for us, because the citrix logoff timeout is globally set for all users to 2 hours and cannot be changed for single users (at least this is what our citrix admin says..)! we need the logoff from the CLIENTSIDE (and it seems that only the fu** PNAgent could do that via...

hi, it doesn't seems to be a really big problem but it is: how could i script to LOGOFF a citrix user from the client side?? - the pnagent.exe doesn't seem to have command line options.. - wfcrun32.exe could only start a session... - vbs or wsh scripts (icaclient API) works only if i do the...