User Profile

Collapse

Profile Sidebar

Collapse
GabeM
GabeM
Last Activity: Jun 30 '09, 04:02 AM
Joined: Apr 6 '09
Location: Okinawa
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • GabeM
    replied to Inserting concatenated data with while construct
    in SQL Server
    I will try to convert it, but I don't think it will work. Thanks for replying.

    -Gabe
    See more | Go to post

      Leave a comment:

    • GabeM
      replied to Inserting concatenated data with while construct
      in SQL Server
      I don't understand by what you mean by Identity. What does the Identity have to do with the concatenated string?
      See more | Go to post

        Leave a comment:

      • GabeM
        started a topic Inserting concatenated data with while construct
        in SQL Server

        Inserting concatenated data with while construct

        I am trying to insert records from one table to another using the WHILE construct, I have managed to move all of the data with the exception of one concatenated field. I can't figure out how to concatenate 'GSA' and the @N into GSAOrderNo column in the TempWebOrders table. The @N is incrementing. If anyone can help, please assist. See code below:

        -TIA

        -Gabe

        Use SMS
        Declare @N as nvarchar(10)...
        See more | Go to post
        • GabeM
          replied to Sql insert cursor
          in SQL Server
          Iburyak, I think I got a solution. Thank you for replying!

          -Gabe
          See more | Go to post

            Leave a comment:

          • GabeM
            started a topic Sql insert cursor
            in SQL Server

            Sql insert cursor

            Here is my situation that I am presenting.

            I have a table "WebOrders" that is located in a database called SC and I want to insert the data into another table called CustomerOrder located in a database called SMS. The WebOrders must be inserted into the SMS.CustomerOrd er table but incremented starting by the last entry in a column called Order_No. Order_No is in the following format GSA7667 NVARCHAR(10). How can I do this...
            See more | Go to post
            • GabeM
              replied to Exporting data with Stored Procedures
              in SQL Server
              I took your instructions and did as you recommended. It works great! Much Thanks!

              -Gabe
              See more | Go to post

                Leave a comment:

              • GabeM
                started a topic Exporting data with Stored Procedures
                in SQL Server

                Exporting data with Stored Procedures

                I have a table on one SQL Server that receives data every day at differant times. I want to export the data from this table to another table in another SQL server. I figure I could use a Stored Procedure to run periodically and move the data. Is it possible to perform such a task with a Stored Procedure?

                -GabeM
                See more | Go to post
                No activity results to display
                Show More
                Working...