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 TouchToneTommy 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: mjuell
  • Content: Threads
  • Order by date
  1. mjuell

    Group by case

    How do i group by a case in oracle. ? In sybase my statement looks like this. select case when c.cust_unit_number is null then 'private' else 'business' end,count(distinct a.cust_id_resp) from cm.account a, cm.customer c where a.info_is_deleted = 'N' and a.foreign_account is not null and...
  2. mjuell

    Sed question!

    Can someone help me with a command for deleting lines ending with tab ?..
  3. mjuell

    Using parameter in sed script file ?.

    I have this file... insert.sed 10i"Hello" It inserts a Hello on line 10.. if i export a variable $line_num I cant use $line_numi"Hello" Any ideas ?
  4. mjuell

    My cursor suddenly stops ?. @@sqls

    My cursor suddenly stops ?. @@sqlstatus = 2 when it stops even though there are more rows to be fetched... Anybody have an idea why ?.. set nocount on go declare tell cursor for select driver_id, avtale_nr from GRUNNLAG_DRIVERFILER_AVTALE where info_is_deleted = 'N'...
  5. mjuell

    How do i remove the office bar?

    How the f... do i remove the office bar in windows 2000.. Im tired of closing it manually every time i restart. I hate it......
  6. mjuell

    I Need help deleting lines from file where column1=xxx

    I want do delete the lines from a file where column 1 matches an exact pattern. ( I want to delete the lines where column 1=123, not the lines where its 21234 ) Please Help!....

Part and Inventory Search

Back
Top