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: *

  1. christine1

    Dynamic SQL Help Again

    ...NEXT FROM tables_cursor INTO @tablename WHILE @@fetch_status <> -1 BEGIN SELECT @report_type = 'SELECT &quot;' + @table_name + '&quot;, COUNT(*) FROM ' + @table_name EXEC (@string2) fetch next from table_cursor into @string1 END INSERT INTO #tmp_et (site_phys_piece, ebs_code...
  2. christine1

    Update with a WHERE clause

    Put the word SET in front of all columns you want to update. Don't forget to declare your variables. Good Luck! Christine1
  3. christine1

    Update with a WHERE clause

    I'm not clear on your question, but I have a few of my own. Which column of which tables are you updating? In other words is this what you want to do, if so you were only missing your SET clause: UPDATE Contents SET Font = 'Arial' WHERE Contents.Entity_ID IN (SELECT...
  4. christine1

    Synchronising databases automatically

    Sure would appreciate taht waggers. Good luck to you in your endeavor and keep us posted. By the way I too have to use the back up and retore method which weighs down the network tremendously anytime I have to copy a file across it. See ya, Christine1
  5. christine1

    Synchronising databases automatically

    waggers, how are you going to go about it? I don't have nearly as many servers but enough that we really need synchronising across the board. I don't know where to begin. Let me know how it turns out. Christine1
  6. christine1

    Dynamic SQL Help

    Thanks Tom. Now where in the statement do I enter the EXEC command and where do I address the variable (see statement above)? Christine
  7. christine1

    Synchronising databases automatically

    Robert, I'm still using 6.5. I've heard and had nothing but bad experiences on replication in 6.5. Any insight/advice on this? Christine
  8. christine1

    Synchronising databases automatically

    I too want to know the answer to this one. I currently use the back up and retoring method across 4 servers. I wish there was an easier and quicker way. It takes up production time and valuable network resources. Any advice out there? Christine
  9. christine1

    I want your SQL upgrade opinion. 6.5 to 7 or 2000?

    Scott, I cannot offer any insight however, I also am in the same situation. I want to know if it is feasible to go from 6.5 to 2000? Is it recommended? Are there known conversion issues. And finally the one I most have issues with, how to configure SQL Server on NT 4.0 to run and optimal...
  10. christine1

    Dynamic SQL Help

    Okay, Tom In my haste to post this problem I'm having I crossed the comment block ***/ instead of /*** If my statement is longer than a line I use 3 asterisk, but that's not my issue. I have only commented them out for this posting. Again the question is HOW TO WRITE a table reference as a...
  11. christine1

    Dynamic SQL Help

    Yes. I guess I did offer more than I actually needed to. But the scenario is this, Depending on the report, it may need one of three tables. Never all the tables at once. i.e. The apple report needs to pull from the apple table, red report from red table. I wanted to use dynamic SQL rather...
  12. christine1

    Dynamic SQL Help

    ...varchar(60), site_hrs float NULL, site_cnt int NULL, site_avg_hrs float NULL) TRUNCATE TABLE #tmp_et TRUNCATE TABLE #tmp_et_site ***/SELECT @command_str = 'cube_unit_sched_events_scp' SELECT @report_type = 'sched' EXEC (@command_str)/*** INSERT INTO #tmp_et (site_id_piece...
  13. christine1

    Creating Triggers

    Okay, so you are saying declarations should go first (move that select statement)? Yes, cube_control is the table not cube_control_tbl (sorry about that) You are correct about the IF UPDATE that's why I cannot get that to work, but it has the concept I'm looking for. I still cannot get it to...
  14. christine1

    Creating Triggers

    ...have to have this by noon. Signed brain fried CREATE TRIGGER manual_control_trig ON dbo.CUBE_CONTROL FOR INSERT,UPDATE AS IF UPDATE (select * from header_view hi, inserted i where hi.phys_piece = i.phys_piece) DECLARE @company company, @site site, @plant plant, @design...
  15. christine1

    HELP-Is my dB corrupt?

    I keep getting syntax errors. I'm sure I am leaving off something. Here's what I've got: dbcc dbrepair DBNAME error dbcc dbrepair_rebuild DBNAME error Do I need to add a dropdb? Please help as this db is mission critical to the company and I am holding up process. P.S. The database is 6.5.
  16. christine1

    HELP-Is my dB corrupt?

    Okay, this is not happening. I recieved the following error message: Msg 625, Level 20, State 1 Couuld not retrieve row from logical page 3855464 via RID because the entry in the offset table (=0) for that RID (=9) is less than 0. The SQL Server is terminting this process. If in...
  17. christine1

    How to transfer Database

    You can try to do a data transfer also. I assume you already have created the dB on the remote server, so transfer all the data. (sometimes has errors) Or you could back it(data) up to a back up device then copy it into the backup folder in MSSQL on the remote servers hard drive then go to...
  18. christine1

    Stored Procedure Statistics

    ...task scheduler if the sproc's are automated and there's always the error and transaction logs. Here's the code for the table: set nocount on */this is optional/* DECLARE @start_time datetime @end_time datetime @s_time datetime...
  19. christine1

    Manner of logins/connections to SQLS 7 in Enterprise Mgr

    GAM, I agree with FoxDev. If you are using an ODBC connection and using NT security, a user should be able to log into the network and have acess to the database(s)you have granted them permission to. When they open a connection to a database server, if you have set up the SQL server to use...
  20. christine1

    Opening cursor in stored procedure

    Thanks for the advive. I agree with you both, first, that cursors will hender SQL performance and secondly, programmers often come from a sequential progamming background, hence the creation of the cursed cursor :-). I have a lot of work in front of me as I have over 100 sproc's that need to...

Part and Inventory Search

Back
Top