How To Create A Copy Of A Specefic Record

Sep 1, 2006

Hi
I have a table with a user column and other columns. User column id the primary key.

I want to create a copy of the record where the user="user1" and insert that copy in the same table in a new created record. But I want the new record to have a value of "user2" in the user column instead of "user1" since it's a primary key

Thanks.

View 6 Replies


ADVERTISEMENT

How To Create An Copy Of A Certain Record Except One Specific Column That Must Be Different && Insert The New Record In The Table

Sep 1, 2006

Hi
I have a table with a user column and other columns. User column id the primary key.

I want to create a copy of the record where the user="user1" and insert that copy in the same table in a new created record. But I want the new record to have a value of "user2" in the user column instead of "user1" since it's a primary key

Thanks.

View 6 Replies View Related

TOUGH INSERT: Copy Sale Record/Line Items For Duplicate Record

Jul 20, 2005

I have a client who needs to copy an existing sale. The problem isthe Sale is made up of three tables: Sale, SaleEquipment, SaleParts.Each sale can have multiple pieces of equipment with correspondingparts, or parts without equipment. My problem in copying is when I goto copy the parts, how do I get the NEW sale equipment ids updatedcorrectly on their corresponding parts?I can provide more information if necessary.Thank you!!Maria

View 6 Replies View Related

Copy A Record Using A Sp

Oct 6, 2005

In a sp I want to select a record from my sql table and copy it to a new record in the same table, changing the value of one of the fields. The value of this field will come from my web page. Is this possible ?

View 3 Replies View Related

Copy A Record From One Table To Another?

Mar 17, 2004

Hello,

Is there a way of copying/moving a record from one table to another identical table on the same database using ADO.NET
I can obviously do it the long way (retrieving a record, then pushing it up using a second SQL command)
I was just wondering if there is a way to do it in one database hit using some kind of cool SQL function.

View 2 Replies View Related

How To Copy One Of The Record Into Another Table

Jul 9, 2012

so i have a table which has at least 2 records that are almost similar except for 2 or 3 columns. i want to copy one of the records(just one) into another table. NB the table has 11million plus records with the above mentioned discription. e. g

col 1 col2 col3 col4
a b c d
a b n d

View 2 Replies View Related

Would SQL Prohibt Copy Record

Mar 26, 2008

Good Day,

I have an SQL 2005 Server running with a table called
Active and a linked table called Recall.

In my .net APP I wrote a VB code that will copy an
existing record and create a duplicate with a new PK ID.

Now here is the problem, The copy record works perfect if
I create a new record and then copy that record. I can
press my copy button and it will make as many copies as
I want. When I try to copy a record that is pre-existing
from an import I did about 6 months ago it looks like it
works but the record is never copied.

My question come down to, Is their something within SQL that
would prohibt a record from being copied ?

If the answer is yes, Can anyone advise where to look to
change setting in SQL or what type of correction I should
pursue.

I am new to SQL and coming from a foxpro arena, Which is also
where the imported data came from..

Any advice would be great.

Thank You..

View 5 Replies View Related

Help With A Record Copy Problem

Apr 22, 2008

I need help with a simple problem in a Stored Procedure.

I have two tables. One with some records of any sort with an ordinary autoincreased PK. and one table that stores relations between records in the first table - it mainly has two columns (ParentID, ChildID) which both references the PK in the first table. Nothing odd there I think.

These items are revisioned through a third table (thats not important here). I want to create a copy of these records in the same tables for a new revision of an item in this nonimportant table.


Table 1
1 Record 1
2 Record 2
3 Record 3


Table 2
1 2
2 3

After the operation:

Table 1
1 Record 1
2 Record 2
3 Record 3
4 Record 1
5 Record 2
6 Record 3

Table 2
1 2
2 3
4 5
5 6

Of course this is only a simple example - in reality its a bit more complex but this is enough to present my problem.

The only way I can find to solve this is to use a cursor to loop through the records in the first table, insert them into the same table and use @@scope_identity to create a temporary table with the old and the new values stored together and then use this temp table to copy (and translate) the records from Table 2 to create a copy of them. But it will be rather slow I think since there are lots of items in this table.

First I did it by creating a temporary column in Table1 to store the old ID together with the new ID but as it turns out Im not able to solve it this way:


insert into Table1 (
Name,
TmpOldID )

select

Name,
PKID

from Table1
where ...

Please help - there must be a simpler and faster way of doing this.

thanks

View 8 Replies View Related

Copy A Record To A Table When Change

Aug 21, 2007

Hi,

I was wondering if there is a easy way to do this.
I got Table Customers, and when a row is changed, deleted, i want to copy the original row to a backup table, so i have the whole history.

tnx a lot,

Mike

View 4 Replies View Related

T-SQL (SS2K8) :: Copy Master Record And Its Detail Records

Aug 26, 2014

I have been asked to give the users the ability to copy a set of records within the database. The current setup is

Master Table: JSA1
JSAID: (PK, int, not null)
JOBTITLE(nvarchar(200), null)
PlantNumber(int, not null)

Detail Table: tblSteps
STEPID (PK, int, not null)
JSAID (FK, int, not null)
StepNo (int, null)
BasicSteps (nvarchar(200), null)
DBPhoto(varbinary(max), null)

The plant number field is a location based field that the application uses to filter/select data on for the end users. What they want to be able to do is to select a record, select another location from a dropdown list and then click a button that duplicates the master record and the detail records to the new location.

I am thinking that a stored procedure passing the JSAID and new Location number to do it, I am just not sure how to get the new ID when I go to copy the detail records.

View 4 Replies View Related

Copy VS Create

Mar 20, 2006

Hello,

We are building a smart client that ships with it an offline db - Sql Express.

I wanted to check if there is a preferred/recommended approach to deploy the database ? I'm essentially asking between

1. Copying a database file and

2. Creating the database file by connecting to Master and issueing create database etc and then running the scripts as we need it.

Any help will be great,

Thanks,

Avinash

PS: The app is a multi user app and may be used by multiple windows users on the same machine. So we currently use the Auto Attach feature in the connection string with database files in  the Special Application/User Data folder. So we isolate files b/w users.

 

 

 

 

 

View 5 Replies View Related

Create A Copy Of A SQL Db On A Laptop

Jun 29, 2001

We have a laptop that has SQL 7 installed on it, and we would like to copy an existing database to the laptop. The laptop does not have any connectivity to our network. I did backup the database on the network, and place the backup copy on a CD. I then was hoping that I could create a new DB on the laptop and restore the copy from the CD. But, I have not been able to figure this out. Can anyone help?

View 4 Replies View Related

Create A Test Copy Of The Database?

Feb 8, 2007

Hi,

I have a database on the server which is in production and I would like to create another copy and use it for testing purpose. so the application can point to the test database for testing purpose.

What is the best way to do? I guess I have to name the test one with different name right?

can I do it without detach the production one? or just copy the database - tables structures from the currnet one?

Thanks!

View 2 Replies View Related

Create A Copy Of A Table In Sql Server

Jul 20, 2005

I have a table I'd like to copy so I can edit it and play around withthe data. How do I create copy of a table in SQl Server?Thanks,Bill

View 5 Replies View Related

How Do I Create A Copy Of An Existing Database? Please Help

Aug 10, 2007

Hi,

How do I create a copy of an existing database using vb.net? I have not been able to find solutions to the problem using vb.net. Can someone please help me. Thanks

Thanks

View 3 Replies View Related

How Do I Create An Exact SQL 2000 DB Copy?

Oct 9, 2007

I want to create an exact copy of a system running SQL 2000.

I want to copy MDF and LDF, but I cannot bring server down cause it works 24x7. What can I do?

View 4 Replies View Related

Create Copy Of Database And Place On Different Server

Oct 26, 2004

All,
I am trying to create a copy of an existing database and place on a different sql server for testing purposes. Currently my method of doing this is to create a backup, then restore a database on my new sql server. But here is the problem I am running into. When I look in Enterprise manager I can see all of the stored procedures and tables and data just fine, which is how I would like it. But, when I open up Query Analyzer I am not able to run any queries because it says "invalid object name" error. I know that the object name is correct. I think that I am having a conflict between the users which were carried over from the source backup file and the users that are on my 2 new sql server. If anyone could help, I would really appreciate it. I am stuck at this point. I am guessing it is probably something simple I am just unaware that I need to do.

Thanks,
LinsLo

View 3 Replies View Related

Timestamping At Record Create

Jul 13, 2006

is there a way that when a record is entered into a table, that I can get it to timestamp itself?

Davids Learning

View 8 Replies View Related

How Can I Create A Clean Copy Of My DB And Keep Lookup Table Data

Nov 27, 2007

I have a database that I have been creating and testing. I have added some junk data and some data into lookup tables. Is there a way to create a clean copy of the db and keep the lookup table data? Also will I be able to create the db under a new name?

View 1 Replies View Related

What Function Can Create A Record Automatically

Nov 14, 2005

In the table, there is a record which has several field. every month, the function will create a same record. that means, the first month, one record. the secord month, two reocrds, ..... for a years. will have same 12 record. so what function can do this? Thanks.

View 2 Replies View Related

Create Record Based On Count

Nov 9, 2007

I have the following data,

CustomerID EngID EngCount
1 A11 2
2 B12 1
3 C10 3

I need to display it as,

CustomerID EngID EngCount
1 A11 1
1 A11 1
2 B12 1
3 C10 1
3 C10 1
3 C10 1

Create a record based on the EngCount. So CustomerID of 3 has 3 records as shown above.

How to do?

View 5 Replies View Related

Delete Record Where Values Exist, Else Create Them..

Oct 3, 2000

Dear friends,

I am thinkking there has to be away to do this in a SQL
statement.

can't you do some kind of...

Create Procedure sp_update_users
@User_Id Int,
@Title_Id Int

AS
UPDATE USERS
DELETE WHERE @User_ID = User_Id and @Title_Id = @Title_Id
ELSE
INSERT INTO USERS VALUES (@User_ID,@Title_Id;)

View 3 Replies View Related

Create Trigger Which Wil Do Event Before Delete A Record..

Jun 14, 2007

Hi There, I have created a trigger which supposingly will do event before delete the record from its own table.unfortunately when i try delete the record to test it whether it will do the event (inserting some records to another table), i found that it was not doing the event like i wanted to be. :(the trigger is as below :=======================CREATE TRIGGER TG_D_AGENT ON dbo.AgentFOR DELETEASbegindeclare @vAgentID as numeric,@vAgency as varchar(50),@vUnit as varchar(50),@vAgentCode as varchar(50),@vName as varchar(50),@vIC as varchar(14),@vAddress as varchar(100),@vContactNumber as varchar(50),@vDownlink as varchar(50),@vGSM as varchar(10),@vAM as varchar(10),@vDeleted_date as datetime set @vDeleted_date = convert(datetime, convert(varchar(10) , getdate(),103),103)declare cur_policy_rec CURSOR forselect AgentID,Agency,Unit,AgentCode,[Name],IC,Address,ContactNumber,Downlink,GSM,AM from insertedopen cur_policy_recfetch from cur_policy_rec into @vAgentID,@vAgency,@vUnit,@vAgentCode,@vName,@vIC, @vAddress,@vContactNumber,@vDownlink,@vGSM,@vAM WHILE @@FETCH_STATUS=0BEGIN INSERT INTO [Agent_history] (AgentID,Agency,Unit,AgentCode,Name,IC,Address,Con tactNumber,Downlink,GSM,AM,Deleted_date) VALUES(@vAgentID,@vAgency,@vUnit,@vAgentCode,@vNam e,@vIC,@vAddress,@vContactNumber,@vDownlink,@vGSM, @vAM,@vDeleted_date)fetch from cur_policy_rec into @vAgentID,@vAgency,@vUnit,@vAgentCode,@vName,@vIC, @vAddress,@vContactNumber,@vDownlink,@vGSM,@vAM enddeallocate cur_policy_recend===============================in oracle , i normallly can do something like this...====================================CREATE TRIGGER TG_D_AGENT ON dbo.AgentBEFORE DELETE ON dbo.Agent FOR EACH ROWbeginIs that such thing function like 'BEFORE' in MS SQL SERVER 2000, coz in sql server im not sure they do have or not. Plz someone help me on this...realy appreciated if can!

View 1 Replies View Related

Create A Column In RecordSet With The Record Count...

Jan 15, 2007

Hello

I'm reading a XML file and the next operation need a column with the row count.

I don't want to know how many rows there is in the recordset, but, the row count of each record.

How can I implement this?

tkx in advance
Paulo Aboim Pinto
Odivelas - Portugal

View 1 Replies View Related

Create A Record Based On Date Range

Mar 25, 2008

I need to create records based on date range on monthly basis, please help.

Here is an example:
ID Startdate EndDate
1 20070301 20070522

and I need to create the following data set based on start and end date range
ID Startdate EndDate
1 20070301 20070331
1 20070301 20070430

1 20070301 20070522

View 8 Replies View Related

Create A Flat File For Each Record In A Table

Apr 20, 2006

I'm rather new to ssis and I've been reading and testing but didn't find a solution for this problem.Supose I've got a table Customer with some fields. One of the fields is CustID.I want to create as many flat files as there are Customers in the table with flat file name set to the CustID.If you could point me in a good direction, It would be nice.Greetings from Belgium

View 4 Replies View Related

T-SQL (SS2K8) :: Identify Columns Which Will Create Unique Record In A Table

Sep 15, 2014

I am looking to create a script that will go through a table a pick out the necessary columns to create a unique record. Some of the tables that I am working with have 200 plus columns and I am not sure if I would have to list every column name in the script or if they could be dynamically referenced. I am working with a SQL server that has little next to no documentation and everytime I type to mere some tables, I get too many rows back.

View 4 Replies View Related

How To Create A Copy Of SQL Server 2000 Database In SQL Server 2005 Express?

Jun 23, 2007

I have a database called 'DB1' in SQL Server 2000. I want to create the same database in SQL Server 2005 Express including the original data in tables.
How would I do that? I cannot find any option to do this upgrade in SQL Server Management Studio.

View 4 Replies View Related

The Remote Copy Of Database X Has Not Been Rolled Forward To A Point In Time That Is Encompassed In The Local Copy

May 11, 2006

Hi,

I set up DB mirror between a primary (SQL1) and a mirror (SQL2); no witness. I have a problem when I issue command:


alter database DBmirrorTest
Set Partner = N'TCP://SQL2.mycom.com:5022';
go


The error message is:

The remote copy of database "DBmirrorTest" has not been rolled forward to a point in time that is encompassed in the local copy of the database log.

I have the steps below prior to the command. (Note that both servers' service accounts use the same domain account. The domain account I login to do db mirror setup is a member of the local admin group.)

1. backup database DBmirrorTest on SQL1

2. backup database log

3. copy db and log backup files to SQL2

4. restore db with norecovery

5. restore log with norecovery

6. create endpoints on both SQL1 and SQL2

CREATE ENDPOINT [Mirroring]

STATE=STARTED

AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)

FOR DATA_MIRRORING (ROLE = PARTNER)

7. enable mirror on mirror server SQL2

:connect SQL2

alter database DBmirrorTest

Set Partner = N'TCP://SQL1.mycom.com:5022';

go

8. Enable mirror on primary server SQL1

:connect SQL1

alter database DBmirrorTest

Set Partner = N'TCP://SQL2.mycom.com:5022';

go

This is where I got the error.

The remote copy of database "DBmirrorTest" has not been rolled forward to a point in time that is encompassed in the local copy



Thanks for any help,

KT

View 8 Replies View Related

How To Basically Copy Tables With New Names Rather Than Create Similar Tables From Similar Manual Input.

May 26, 2007

I have a table that I am basically reduplicating a couple of times for each part of this database that I want to create.Each table basically has the same data: The tables will be called motherTable, fatherTable, sonTable, daughterTable and so on.I am pretty much using the following in each column: UserID, MotherID(or FatherID or SonID, etc., etc. and so on for each unique table), FirstName, LastName, MiddleName, BirthPlace, Photo, Age.I don't see an option to copy a table and just modify the second ID part and rename that table accordingly.How can I make this an easier way of creating these similar tables without retyping all these columns over and over again?Thanks in advance. 

View 4 Replies View Related

Detach-copy-attach: Can Not Copy Files - Getting Access Denied

Feb 28, 2008



Hi!
I did:
alter database mydb set single_user with rollback immediate;
exec sp_detach_db @dbname='mydb', @keepfulltextindexfile='true';

then I tried to copy files to new location on other drives, same server but got
>>Cannot copy <myfile>: Access is denied
Make sure the disk is not full or write-protected and that the file is not currently in use<<

I also tried rename of file without success.
I also tried with db service stoppet (not preferred) without success.

How to find out, which process locks the files?
Best regards

View 7 Replies View Related

Copy? Export? How To Copy Stored Procedures

Aug 30, 2005

How do I transfer/copy the stored procedures in my Test DB to my LIVE DB?  IT won't allow me to export keeps giving me an error. 

View 4 Replies View Related

Copy A Database With Copy The .mdf File And Attaching It With A New Name?

Nov 4, 2006

Hello,

if i have a given database (a model) and i want to copy this database in the same database instance. Is it ok to copy the mdf and ldf file and attach the files with a new database name in the same instance.

Or is the datebase name part of the .mdf file?

Regards
Markus





View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved