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 Manna

  1. Manna

    Copying rows from one table to another

    It works with Print. Thanks. Manna
  2. Manna

    Copying rows from one table to another

    Now I get the "Insert into" part of the query in the Results pane. And "Sele". Why is the select statement being truncated? Manna
  3. Manna

    Copying rows from one table to another

    Under the Query menu / Current Connection Options, I do NOT have "no execute" checked. Further, the other queries that I run produce results in the Results pane. Using Select @sql2, I get results . . . sort of. A blank header row, then NULL and "(1 row(s) affected)". Manna
  4. Manna

    Copying rows from one table to another

    tlbroadbent, I find a Results tab in Query Analyzer, which is ordinarily where the output from my T-SQL queries ends up. I'm running SQL Server 7.00.623. If I switch from Results in Text to Results in Grid, then the Messages display in a separate tab from the results. But I still find...
  5. Manna

    Copying rows from one table to another

    The needed rows have been successfully transferred to the target table. I used a Query in the DTS Wizard. Manna
  6. Manna

    Copying rows from one table to another

    No, the script doesn't output an SQL statement. It doesn't output anything at all. I'm executing it via Query Analyzer. Is that the correct thing to do? I just paste the code in, parse it, and execute it. Manna
  7. Manna

    Copying rows from one table to another

    tlbroadbent, This version doesn't appear to work for me, either. Nothing gets loaded into my target table, and the results pane doesn't show any activity. But it parses okay :-) Maybe I'll just bite the bullet and list out all the fields. It can't be THAT time consuming, after all. Manna
  8. Manna

    Copying rows from one table to another

    tlbroadbent, I'm finally back to the original project. I've modified the script you offered to read as follows: ======================= use DOL go declare @sql1 nvarchar(4000), @sql2 nvarchar(4000) select @sql1=@sql1+c.name+', ' from syscolumns c inner join sysobjects o on c.id=o.id where...
  9. Manna

    Need to Import from a Fox cursor into SQL db

    Thanks, tlbroadbent and foxdev! I shared my difficulty with my husband over the weekend, and he and I worked out the solution to the part that I was "stuck" on. It was a "DBF" FoxPro cursor/file/free-table that I was trying to import into SQL Server. (Although I could have...
  10. Manna

    Need to Import from a Fox cursor into SQL db

    We have a database with a FoxPro 6.0 front end and a SQL Server 7.0 SP6 back end. I'm running a Fox prg script that gives me a cursor or a file. I can output the file in FoxPro, Excel, and other formats. I need to import the data, which already has the correct field names and format, into...
  11. Manna

    Copying rows from one table to another

    TL, Thanks again. That looks simple enough. I'll test it out when I get done with this morning's urgent project. Manna
  12. Manna

    Copying rows from one table to another

    It worked on the test database, but on the live database I encounter the following error message: Server: Msg 273, Level 16, State 1, Line 3 Cannot insert a non-null value into a timestamp column. Use INSERT with a column list or with a default of NULL for the timestamp column. Is there an...
  13. Manna

    Copying rows from one table to another

    It worked! Thank you both very much! Believe it or not, our DBA and I were both stumped on this one. He has the excuse that he's sick, though. Manna
  14. Manna

    Copying rows from one table to another

    I have two tables in my SQL Server 7.0 database that are identical in format. I want to use T-SQL to find certain rows from the first table and load them into the second table. How do I do that? Manna
See more

Part and Inventory Search

Back
Top