Copying column to another column in another table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Copying column to another column in another table

Author

Topic

jszulc
Yak Posting Veteran

66 Posts

Posted - 2008-12-19 : 14:53:39

Does anyone know how can I can copy the contents of Comments column of KPItbl to corresponding CommentsTbl and Comment column? I am attaching definitions from both tables. Assume CommentsTBl is empty. TaskID is primary key. After copying there should be only 1 record for TaskID in CommentsTbl. Noy all Tasks in KPITBl have comments, some of them are NULL. If they are null I would prefer not to transfer anything.
Greatly appreciated and Happy Holidays!

CREATE TABLE [dbo].[KPITbl](
[TaskID] [int] IDENTITY(1,1) NOT NULL,
[Lead] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WRM] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PTDB] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PAR] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PMO] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RequestingLOB] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LOB] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FinishLocation] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProjectType] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ServerName] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ServerType] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TechAnalyst] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RAG] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StartDates] [smalldatetime] NULL,
[EstimatedCompletionDate] [smalldatetime] NULL,
[TreeorDomainImpacted] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NumOfSites] [int] NULL,
[NumOfUsers] [int] NULL,
[GBdatamoved] [int] NULL,
[GBdatadeleted] [int] NULL,
[NumOfSrvrsAdded] [int] NULL,
[NumOfAppsDeployed] [int] NULL,
[EUTEngineeringConsult] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Comments] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TimeSpend] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Complexity] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastUpdated] [smalldatetime] NULL,
[DCOorSTANDALONE] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ECM] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StatusCompletedDate] [smalldatetime] NULL,
[StatusCancelledDate] [smalldatetime] NULL,
[CreatedDate] [smalldatetime] NULL,
[PropertyIDStartLoc] [nvarchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PropertyIDFinishLoc] [nvarchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TspanID] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SDMSRec] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RequestID] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RequestType] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ActualCompletionDate] [smalldatetime] NULL,
[TspanStatus] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Activity] [nvarchar](80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Manager] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_Sheet1a] PRIMARY KEY CLUSTERED
(
[TaskID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
==================================================
USE [KPI]
GO
/****** Object: Table [dbo].[CommentsTbl] Script Date: 12/19/2008 13:47:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CommentsTbl](
[TaskID] [int] NULL,
[LoginName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Comment] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Date] [datetime] NULL
) ON [PRIMARY]

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2008-12-19 : 15:32:58

Something like this?

UPDATE comm
SET Comments = kpi.Comments
FROM
CommentsTbl comm
INNER JOIN
KPITble kpi
ON
comm.TaskID = kpi.TaskID

Jim

jszulc
Yak Posting Veteran

66 Posts

Posted - 2008-12-20 : 07:23:45

I tried this just now. Got (0 row(s) affected)

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2008-12-21 : 18:01:21

Then comm.taskID never = kpi.taskid. I guessed at how your tables joined since you didn't provide that info. Join the tables how they are related and you should get a result.

jim

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources