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 Wanet Telecoms Ltd 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: *

  • Users: stwi1974
  • Content: Threads
  • Order by date
  1. 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...
  2. stwi1974

    function bin_to_num with sql-server

    Hi, is there any equivalent to bin_to_num with sql-server? thanks in advance
  3. 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'...
  4. 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...
  5. 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...
  6. 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
  7. stwi1974

    Error on Api-Call "LogOnUser"

    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 "CreateProcessAsUser": The declaration is: Public Declare Function LogonUser Lib "kernel32&quot...
  8. 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 "CreateProcessAsUser": The declaration is: Public Declare Function LogonUser Lib "kernel32&quot...
  9. 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...
  10. 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...

Part and Inventory Search

Back
Top