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!

Recent content by techipa

  1. techipa

    Validate the data from last row to first row

    Thanks for the reply Alex.
  2. techipa

    Validate the data from last row to first row

    Hello All, I have a following table: Name New Version P001 New P001 V1 P001 V1 P001 V2 P001 V2 P001 V3 P001 V3 P001 V4 P001 V4 B001 New If the new name is added to the table then I should be able to add the new Name (B001 New) If the new version to the name is added then update the...
  3. techipa

    Help with Cursor

    Will do, thanks to you and SQLSister -techiPA
  4. techipa

    Help with Cursor

    Paul, No, it does not work either way. It goes in the loop I guess. I tried to put the select statements after FETCH DECLARE NewCur CURSOR FOR SELECT Code, Name, Category FROM #AddNew OPEN NewCur FETCH NewCur INTO @Code, @Name, @Category select 'Test1' select @Code...
  5. techipa

    Help with Cursor

    Paul, I changed the cursor syntax as per your suggestion. Why are not you fetching next record in the last fetch?
  6. techipa

    Help with Cursor

    SQLSister, I did not make PK field as identity because at my work place they do not prefer PK being an Identity column. Secondly, this is going to be a scheduled batch job. The user will never add rows to this table except updating the rows. techiPA
  7. techipa

    Help with Cursor

    Hello All, I have to insert the rows from the #table to the user table. I have written a cursor to implement this process. The #table has two rows which shoule be inserted in the user table. While inserting records, I have to insert the PK column as well. So I get the max(col) from the table...
  8. techipa

    Parsing the string

    Thank you George, Paul and Alex. Friday was holiday so got delayed on reply. Paul, I implemented your suggestioned SQL and it ran like charm. The query returned the expected results. Thanks again SQL GURUs, -techiPA
  9. techipa

    Parsing the string

    Thanks Paul for the reply. George, would you know how to write single sql statement for ' ' and '-'? Thanks in advace, -techiPA
  10. techipa

    Parsing the string

    Thanks Paul and Alex, I will have to pull the data from Access to SQL and then parse it. Paul, I used your sample and added one more OR condition for ' ' but I got error? How would I check for ' ' and '-' at a time?
  11. techipa

    Parsing the string

    Thanks Paul, The SQL server does not like sql finctions like substring, charindex etc.. because I am trying to get the data from MS Access server which I linked to sql server and am using openquery. For example: Select * from OpenQuery(DB2000, 'Select SUBSTRING([Col1],1,5) from table1') This...
  12. techipa

    Parsing the string

    Hello All, There is a column in sql table which contains the data like: RA-100 R1 RA-200.02.01 ORIGINAL RA-200.02 R1 GSOP 2709 ORIG GSOP 2703A ORIGINAL SOP 112 R 13 SOP 117A R1 There is some uniformity in the data but not a lot. I need to parse the data in three columns as: (First column -...
  13. techipa

    DB detach-attach

    Thanks for the reply Denny.
  14. techipa

    DB detach-attach

    Mrdenny, Since the files are big to copy from one server to another after detach will the users loose permissions by the time the DB attaches.
  15. techipa

    DB detach-attach

    Hello All, Can I detach the database from one server and attach it to other server in SQL 2000? -techiPA
See more

Part and Inventory Search

Back
Top