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!

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

    simple incrementing?

    I have a table with 4 rows.. id..xx..yy..zz.. now out of the 4000 rows, some data has been taken out in the middle..eg: 220 shares money casino 221 shares2 penny dollar 225 stock hello moto 229 sucks help me 230 etc eg iou I am slightly confused as to how I would go about sorting the...
  2. Lahorem

    how to see structure of a view

    As a newbie to sql, this question may be very basic but I have a view called 'config' and I would like to see which fields it is pulling out without running it (i.e Select * from config) Additionally I don't know where the .sql files are stored for this view. Lastly, i have tried sp_help...
  3. Lahorem

    EMACS not loading - error msg provided

    Hi a newbie user to unix and have tried to load emacs using emm 'emacs' command I get this error and have no idea what it means Any ideas? Error msg: Error: 0EXEC cannot find executable for 'emacs' version '20.3.0.0' thanks in advance
  4. Lahorem

    cursor syntax - whats wrong?

    Hi - The cursor below is suppose to copy data from a perm. table into a temp. table then make changes to the data and copy it back into the perm. table Once in this temp table, I am trying to get the cursor to fill all gaps of column points as this column must be consecutive numbers. Currently...
  5. Lahorem

    keeping ids consecutive after removing data

    I currently have a table where I have to remove the type1 data (see below) id type 1 type1 2 type1 3 type1 5 type1 7 type1 8 type2 11 type3 14 type2 15 type2 16 type2 17 type2 ... ..... Now I have removed the type1 data using update table statements but I need to have the...
  6. Lahorem

    .dat file row swap

    I have a .dat file that Iam accessing using unix / SQL: File format is: Row 1 Row2 Row3 Row4 x y w d x t w d x y w 5 I need to swap the data in row4 and row1 with each other .. the fields are defined as digits but of...

Part and Inventory Search

Back
Top