Recent content by stwi1974

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...