Copy data between rows in the same table

So here was my issue. I needed to copy some <binary data> from one row in a table to another row. I tried using the SQL Server Managment Studio but it does not allow you to copy and past binary information. Instead I used a UPDATE... FROM SQL statement.

Here is an example:

UPDATE LoadTestRun
SET LoadTest = b. LoadTest
FROM LoadTestRun, LoadTestRun b
WHERE LoadTestRun.LoadTestRunID = 4 AND b.LoadTestRunID = 1

Here is the generic format:

UPDATE table
SET field = b.field
FROM table, table b
WHERE table.PirmaryKeyID = "Copy To ID" AND b.PrimaryKeyID = "Copy From ID"

Comments

  1. lilyjamesMay 10, 2026 at 1:05 AM

    VidMate App is a powerful video and music downloader that allows users to save content from popular platforms like YouTube, Facebook, Instagram, and TikTok. The app supports HD and 4K downloads, offline playback, and fast downloading speeds with a simple user-friendly interface.

    ReplyDelete

Post a Comment

Popular posts from this blog

Add User As Local Administrator On Domain Controller

I recently was settting up a new Microsoft SharePoint 2010 machine and had promoted the machine to a domain controller before creating my SharePoint admin accounts.  I needed to add several of my accounts to the local Administrators group.  Unfortunately after you promote a server to a domain controller you can no longer access the GUI for Local Users and Groups.  Instead I had to use the command line to add the users. Open a command promt using the "Run as administrator" function and then run the following command. net localgroup Administrators /add {domain}\{user} Note: do not include the {} brackets.
Read more

An error occurred while applying security information to

While attempting to move files from a hard drive I recovered I kept getting the following error on a specific set of files. An error occurred while applying security information to {G:\Folder} Failed to enumerate objects in the container. Access is denied. In order to fix it did the following. -Open a Command Prompt "As Administrator" -Run the following commands: takeown /f "G:\folder" /r /d y icacls "G:\folder" /grant administrators:F /T
Read more

Install/Configure Power Apps Mobile for U.S. Government and DoD User

Image
For those working in the U.S. Government or DoD/Military space needing the Power Apps mobile application on your phone, an additional step of selecting a region must be taken before you attempt to sign-in. Microsoft has three separate regions listed below where U.S. Government information is stored, for additional information click here . US Government GCC US Government CGG High US Government DoD NOTE: Before attempting the video or written instructions below, contact your system administrator to determine which U.S. Government region you belong to. Video Tutorial Click the image below to open the YouTube video. Instructions Here are the instruction on how to install the Power Apps mobile application and change the region setting before you log in. Android : Open Google Play / iPhone : Open App Store Search for “powerapps” Install the Power Apps mobile app Open the Power Apps mobile app Click the gear icon in the lower right hand corner of the app. Select “Region se...
Read more