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

    Return record(s) that produced error

    This is going to be far-fetched, I know, but my immediate supervisor has asked if it would be possible to return any record(s) that causes an error. I told him I would investigate, but I didn't think it was possible. For example, if we have an INSERT statement to move 100,000 records into a...
  2. naxy

    Problem with Begin/Commit/Rollback Transaction

    I'm trying to work in some rollback procedures into a few stored procedures. I've set up the following code. However, when I set it up to fail on purpose, the rollback does not appear to be working (the USP_Write_To_Log is not firing). What am I doing wrong? Thanks! DECLARE @err INT BEGIN...
  3. naxy

    Comparing possible NULLS

    Hi all, I'm trying to write a data validating query in which existing data is checked against new data coming come. I'm then determining if I need to insert a new record or simply update one already existing. The insert records are good to go, but I can't get the update comparison to go. Here's...
  4. naxy

    SQL Srv 2000 - Apply Permissions via a Parameter

    I have a set of permissions which can potentially apply to about 15 different tables. What I want to do is be able to call these permissions dynamically so that I don't have to split a block of logic into two Stored Procedures. Basically, I have a block of logic in which a "working" table is...
  5. naxy

    Check Flat File's Existance via DTS Package

    Hi all, Preliminaries: 1) This is in a SQL Server 2000 DTS Package 2) The flat file is on the server itself (duh) 3) The flat file always has a date stamp appended to the end 4) The date stamp isn't always the date the file was FTP'd to the server Question: I need to be able to check for the...
  6. naxy

    Trying to use SELECT TOP @Sample_Size within an INSERT INTO block

    UPDATE manual_audits SET manual_audit_system = ( case when transaction_number in ('10', '14', '9292') then 'G' when transaction_number in ('401', '202', '8258', '8282', '8217', '6060', '6061') then 'M' end) WHERE claims_id = cast(@mclaims_id as nvarchar(10)
  7. naxy

    Update data in one table from data in another table

    Hi all!!! I have a main table (itof_operator) and a working table (#itoftemp). I want to update a field on the main table (itof_operator.operator_state) with a field on the temp table (#itoftemp.cost_center_number) where a field on both tables match (itof_operator.operator_id =...
  8. naxy

    Update one table with data from another?

    Hi all!!! I have a main table (itof_operator) and a working table (#itoftemp). I want to update a field on the main table (itof_operator.operator_state) with a field on the temp table (#itoftemp.cost_center_number) where a field on both tables match (itof_operator.operator_id =...

Part and Inventory Search

Back
Top