No announcements
Found 1939701 threads
-
0 VotesInserting data from one table to another
SELECT * INTO Destination_Table FROM Source_Table this will ...Answered | 1 Replies | 6016 Views | Created by SQL_BOSS - Tuesday, March 15, 2011 9:12 PM | Last reply by Nishit Badani - Tuesday, March 15, 2011 9:20 PM
-
2 Votes
Copy table from one server to another server
hey Kunal if i linked the server then it degrades the performance... i want to fetch the data from different servers after each one week........Answered | 10 Replies | 5442 Views | Created by Pankaj K - Monday, November 16, 2009 9:48 AM | Last reply by Manish Sharma - ETL - Tuesday, November 17, 2009 7:26 AM -
2 Votes
standard SQL for updating from one table to another
Standard syntax for one column update will be: UPDATE Table1 SET Field1 = (select Field2 from Table2 where Table2.PK = ...Answered | 2 Replies | 2437 Views | Created by Phil Preen - Tuesday, August 9, 2011 1:25 PM | Last reply by Phil Preen - Tuesday, August 9, 2011 2:47 PM -
2 Votes
Copy data from one table to another
I simply need to copy the values contained in one column to another column in the SAME table so here is what I have: CREATE proc COPYDATA ...Answered | 6 Replies | 2622 Views | Created by HSSNE - Tuesday, November 20, 2012 2:21 PM | Last reply by JR1811 - Tuesday, November 20, 2012 5:03 PM -
0 Votes
IUD Trigger to insert from one table to another table
Yes, the lastupdate field is common in both the tablesAnswered | 9 Replies | 6448 Views | Created by Maverick008 - Friday, December 2, 2011 8:06 PM | Last reply by Kalman Toth - Thursday, December 8, 2011 8:58 PM -
3 Votes
Copying a table from one db to another DB
SSIS (SQL Server Integration Services) can move data fairly efficiently from one datase to another but can have issues from time-to-time with complex ...Answered | 5 Replies | 8971 Views | Created by harley1995fb - Thursday, February 11, 2010 5:15 PM | Last reply by William Vaughn - Thursday, April 1, 2010 6:54 PM -
0 Votes
copying table from one server to another
http://www.w3schools.com/sql/sql_insert_into_select.asp http://www.codeproject.com/Tips/664327/Copy-Table-Schema-and-Data-From-One-Dat ...Answered | 4 Replies | 1301 Views | Created by Danny2426 - Wednesday, October 1, 2014 4:47 PM | Last reply by ryguy72 - Wednesday, October 8, 2014 7:18 PM -
0 Votes
Move table from one database to another
Here are few approaches you may use depending on your case; 1) You may create a DTS Package , define the Source and Destination Connection(s) and identify the ...Answered | 3 Replies | 4608 Views | Created by banty1 - Thursday, July 7, 2011 1:58 PM | Last reply by Kalman Toth - Tuesday, July 12, 2011 11:39 PM -
0 Votes
Insert data from one table to another table.
If regular basis then I'm suggesting you think about merge statement to keep you table B synchronized with A.Answered | 5 Replies | 1484 Views | Created by Rajendra Lella - Thursday, July 30, 2015 6:25 AM | Last reply by Ahsan Kabir - Sunday, August 2, 2015 3:31 AM -
0 Votes
Copying records from one table to another with data containing carriage returns
Hi, If you are moving data from one SQL Database to another ON THE SAME SERVER, then you could not bother with SSIS.Answered | 6 Replies | 8195 Views | Created by johnr2000 - Friday, September 16, 2011 5:18 PM | Last reply by Peja Tao - Monday, September 19, 2011 7:23 AM -
1 Votes
How to fill table field with an arithmetical operation of fields from other two tables?
UDF computed column link: Computed Column from UDF Kalman Toth, SQL Server & Business Intelligence ...Answered | 1 Replies | 4961 Views | Created by r4ul90 - Saturday, November 13, 2010 9:42 PM | Last reply by Kalman Toth - Sunday, November 14, 2010 12:22 AM -
0 Votes
moving records from one table into another table
Also, as you mentioned that each of the tables have their own unique RequestIDs, there has to be a way to match the records from the 2 tables.Answered | 4 Replies | 1716 Views | Created by Jim03_Jim03 - Wednesday, May 1, 2013 8:52 PM | Last reply by Megha Barpande (MCSE-Business Intelligence) - Thursday, May 2, 2013 11:14 PM -
0 Votes
Table constraint one field unique while another field = certain value
SET NOCOUNT ON; USE tempdb; GO CREATE TABLE dbo.T ( sk int NOT NULL IDENTITY(1, 1) PRIMARY KEY, c1 int NOT NULL, c2 int NOT ...Answered | 2 Replies | 2558 Views | Created by Bruno_1 - Thursday, February 9, 2012 11:06 PM | Last reply by Hunchback - Friday, February 10, 2012 12:03 AM -
2 Votes
Delete rows from one table based on another table
row_number() Over(Partition by ColumnA Order by columnB DESC) rn FROM TABLE1) It's another way of sorting the table.Answered | 20 Replies | 2008 Views | Created by monde - Monday, August 8, 2016 4:44 PM | Last reply by Rocco Daniele Ciaravolo - Tuesday, August 9, 2016 5:42 AM -
0 Votes
Insert rows from one table into another table
If both tables have identical structures and you don't have identity columns, then you can use *.Answered | 2 Replies | 11030 Views | Created by Barucho1 - Monday, February 21, 2011 8:13 PM | Last reply by Naomi N - Monday, February 21, 2011 8:37 PM -
0 Votes
Copy table from one database to another
The easiest way I found to copy table schema in sql server- 1.in SSMS right click the database name from which you want to copy schema.Answered | 9 Replies | 68648 Views | Created by AGE81 - Thursday, November 29, 2007 1:52 PM | Last reply by elant - Wednesday, April 24, 2013 5:00 PM -
1 Votes
Update one table with records from another table
We need to know the data types, keys and constraints on the table.Answered | 4 Replies | 1084 Views | Created by open_door8 - Saturday, September 5, 2015 10:20 PM | Last reply by open_door8 - Sunday, September 6, 2015 5:51 PM -
0 Votes
Transferring Rows From One Table To Another
> This would likely be done one record [sic] at a time and I would delete the record [sic] from Temp_Sales as soon as I've successfully inserted it into the Sales table.Answered | 4 Replies | 987 Views | Created by Patrick Regis - Saturday, November 8, 2014 5:51 PM | Last reply by --CELKO-- - Saturday, November 8, 2014 10:27 PM -
0 Votes
Insert into and Row_Number() - From one table to another
I'm trying to Insert specific values from one table to another.Answered | 2 Replies | 2541 Views | Created by Jeannette_81 - Friday, March 25, 2016 7:52 PM | Last reply by Jeannette_81 - Friday, March 25, 2016 8:19 PM -
0 Votes
Insert record from one table to another
I have to insert the records from one table to another table after applying some calculation and formula's.Answered | 1 Replies | 5586 Views | Created by trumbooshafi - Tuesday, November 30, 2010 4:12 PM | Last reply by Alberto Morillo - Tuesday, November 30, 2010 7:47 PM
No announcements
