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

    Convert Decimal to Int

    Hi, I want to format the data as below for a report. here is just a sample of what i am doing... create table #test (Header_1 varchar(20), Month_1 numeric(10,2)) ; insert into #test values('Sales',120) insert into #test values('Sales%',2.45) ; select case when charindex('%',[Header_1])=0...
  2. chamilz

    Select Min Values and Max Count

    Hi, I have a data table like below. From this table I want to "select the STORE that has highest item count AND minimum AvgScore". Store Item AvgScore 122 A001 10 122 A002 10 122 A007 10 121 A002 11 121 A001 11 121 A007 11 104 A007 5 104 A001 5 102 A002 7 102 A001 7 Result should be...
  3. chamilz

    Connection String

    I am very new to vb.net (2005). I developed a small application which retrives data from the SQL table and used the following connection string. my application works for user who have admin rights to access SQL server. Conn = New SqlClient.SqlConnection("Data Source=CA-TNET01;Initial...
  4. chamilz

    Update values

    I have data set in my working table as below. Code category 1500077 DEFLT 1500077 RELAX ------------------------------------ 1500078 DEFLT 1500078 OREX 1500078 LATIN ------------------------------------ 1500081 OCTAL 1500081 DEFLT I need to update DEFLT category from the primary Category...
  5. chamilz

    update sequence

    line_id action_type po_number po_line_number color_code nrf_code pack_code ----------- ----------- ----------- -------------- ---------- -------- --------- 0 A 1000124 1 215 080 NULL 1 A 1000124 1...
  6. chamilz

    Duplicating Records

    I have a table which has records like this, order_no line_no color size qty 888 1 202 900 20 888 2 202 910 10 888 3 202 930 6 888 4 405 900 8 888 5 405 910 21 888 6 405 930 40 Now i need to create a report using the above table and need the result set like below, order_no line_no...
  7. chamilz

    Export to TEXT file - Eliminate Blank spaces

    I have two tables which contain Header and Detail records. Header table has 12 columns with primary key and Detail table has 8 columns with secondary key. I need to join these tow tables in order to create TAB delimited TEXT file to feed another system. Final TEXT files always should contain...
  8. chamilz

    assign seuqnce numbers

    I have a Product_Table like below and need to assign Sequence(SEQ) numbers from a seperate_Table for each product group i.e. unique number for product/supp/color/size/qty. My sequence_table has sequence_id, Sequence_number. Product supp color size Qty SEQ 430500001 15351 200 900 1 1...
  9. chamilz

    update header and detail from master

    My processes described below extract data from a Master Table and manupulate as below.... Step-1: ---------------------- DTS process will import text files into Master_Table in following order. From the Master_table i have to create Header_Table and Details_Table to generate output text file...
  10. chamilz

    need some help to update a table

    I would greatly appriciate your suggestions and advice to find a sulution to following, I have a table which is maintain by current application comprising "pack code/style/vendor/size/qty". The pack code is automatically assign for the cobination of style/vendor/color/size/quantity.(exisitng...
  11. chamilz

    online degrees

    Hi I would like to hear your comments and suggestions in this regard, I got a Diploma in computer system designing and Bachelors in accounting. I have been working in IT industry more than 7 years specialized in ERP products and currently I am working for Retail Company as a system analyst...
  12. chamilz

    limiting bandwidth, user level

    Hi, I am really new to netwrking...I have a general question about limiting LAN bandwidth(TCP/IP). Can Network Administrator limits/controls bandwith for each users in the same LAN when accessing to applications running in a server? Thank you in advance...
  13. chamilz

    again to find MAX records-

    i am posting this questions again since i couldnt find a sulution....i better explain my question in detail my table has records set like below... and need a query like this.... select distinct(col1...col6) for max(col6) always (col1--col5)is considered as a unique set... /Thanks col1...
  14. chamilz

    need an urgent help to find max records

    i have data set like this... need to find col1,col2,col3...col8 for highest value of col8 i.e max(col8)..thanks in advance/ col1 col2 col3 col4 col5 col6 col7 col8 48019 459907989 308 1 920 250 11060 03259 48019 459907989 308 1 920 388 12239 03335 48019 459907989 308...
  15. chamilz

    Column to Row - concatente

    Hi, I really appreciate your help to find a solution for this. I have a product_table which has product details as below.. Pro_id attribute size_code 1 A 900 1 A 910 1 A 920 2 B 900 2...
  16. chamilz

    News for everyone

    I had a couple of questions earlier and I got perfect solutions by posting this forum. Not only that, I found lot of threads which are very useful, more advance and practical than BOL. Just wanted to thanks everyone for making others life happy with your knowledge.
  17. chamilz

    assigning rank number for same

    Hi...my reference table looks like this id prod_id color_code 1 100 20 2 100 30 3 105 20 4 105 30 5 105 40 6 120 20 i need to create a table assigning coulor counter as follow id prod_id color_code Countr 1 100 20 1 2 100 30...
  18. chamilz

    adding a new column

    Hi...my reference table looks like this id prod_id color_code 1 100 20 2 100 30 3 105 20 4 105 30 5 105 40 6 120 20 i need to create a table assigning coulor counter as follow id prod_id color_code Countr 1 100 20 1 2 100 30 2 3 105 20 1 4 105 30 2 5 105 40...
  19. chamilz

    Concatanating code

    I have a table which basically contain records like below part size 1 900 1 910 1 920 2 900 2 910 3 920 3 930 i need an output in a another table concatinating size code as follow.. eg. Part size 1 900910920 2 900910...

Part and Inventory Search

Back
Top