Search results for query: *

Yes, thanks alot!

I got the following query select t.id, pers1.name name1, pers1.firstname firstname1, pers2.name name2, pers2.firstname firstname2, t.discipline, t.number from team t join team_person tpers1 on tpers1.team_id=t.id join person pers1 on pers1.id=tpers1.person_id left join team_person...

Hey, thanks alot for your replies ^^ i'll have to check out if i can use a function though. I'm executing all the queries out of a framework and i don't know if there are some problems with functions yet.

Hi, is there any equivalent to bin_to_num with sql-server? thanks in advance

bin_to_num converts a binary vector to ist equivalent number: bin_to_num(0,0,1)=1, bin_to_num(0,1,0)=2

Hi, im used to oracle and i need the same with sql-server: select case bin_to_num(flag3, flag2, flag1) when 0 then 'no flag is set' when 1 then 'flag1 is set' when 2 then 'flag2 is set' when 3 then 'flag1 and flag2 is set' when 4 then 'flag3 is set'...

try this query select t1.field1, ... from table t1 join table t2 on t2.pk=t1.pk and t2.datum=(select min(datum) from table where pk=t1.kp and datum>(select...

Thanks alot for your help, Mufasa and ddrillich! now the statement looks like select primary_key, begin_dt+(rn-1) dt from table, (select rownum rn from smaller_table) where begin_dt+(rn-1) <= end_dt and primary_key=value order by dt Zerberus

Hi, i got begindate (01/01/2004) and enddate (01/01/2004) and i need a sql-statement which results 01/01/2004, field, ... 01/02/2004, field, ... 01/03/2004, field, ... . . . without using a statement like select d.date, a.field, ... from table_1 a join table_2 b on b.date between a.begin and...

Hi! I got a problem with a SQL-Query to create. I got this query: SELECT a.id FROM table1 a, table2 b, table3 c WHERE a.id=b.parentid AND b.id=c.id AND b.parentid IN (SELECT id FROM table2 WHERE parentid = 4711) AND c.name like '%smith%' I got table1 with foreign key of table2...

Thx for your hint, JediDan! but all_tab_columns doesnt recieves anything (isnt filled) but the result of all_views gave me all_tab_cols which is fits all i wanted :) zerberus

Hi! is there any possibility to get the table-definition as result from a select, like SQL-Plus' DESC? thx in advance

Hi all! I'm developing with VB6.4 SP4 on W2K. I'm trying to start a process with with different access as the current user logged in. I figured out the following previous api-call of &quot;CreateProcessAsUser&quot;: The declaration is: Public Declare Function LogonUser Lib &quot;kernel32&quot...

Hi all! I'm developing with VB6.4 SP4 on W2K. I'm trying to start a process with with different access as the current user logged in. I figured out the following previous api-call of &quot;CreateProcessAsUser&quot;: The declaration is: Public Declare Function LogonUser Lib &quot;kernel32&quot...

I have programmed a service running under win2k for updating our software. the service should be started manually when it needs to. while developping the service i was logged on with any possible rights so that i'm able to register, start, stop, pause, continue the service by code. all worked...

I have programmed a service running under win2k for updating our software. the service should be started manually when it needs to. while developping the service i was logged on with any possible rights so that i'm able to register, start, stop, pause, continue the service by code. all worked...

Hi, Alexsosa! Im trying to get an Applet with VB6.0 to control a service in Win2000. So have U solved your problem and how? Greetings Zerberus