Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. stwi1974

    query-problem

    Yes, thanks alot!
  2. stwi1974

    query-problem

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

    function bin_to_num with sql-server

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

    function bin_to_num with sql-server

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

    query-problem: oracle to sql server

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

    query-problem: oracle to sql server

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

    rownum and order by to select only the second record

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

    SQL: get every day between two days

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

    SQL: get every day between two days

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

    SQL-Query

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

    table definition as select-result

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

    table definition as select-result

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

    Error on Api-Call &quot;LogOnUser&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...
  14. stwi1974

    Api-Call raises error

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

    starting a service under Win2k

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

    starting a service under win2k

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

    VB applet to assign network printer to LPT1

    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

Part and Inventory Search

Back
Top