No announcements
Found 2648979 threads
-
0 Votesupdate value of current table to other table
I think you probably meant: update Prisoner set Picture = P.Photo_Num from Prisoner inner join dbo.Personal P on Prisoner = ...Answered | 2 Replies | 6211 Views | Created by KhaLeeL ZoURoB - Saturday, January 1, 2011 8:11 PM | Last reply by Naomi N - Sunday, January 2, 2011 1:07 AM
-
0 Votes
Update value of the Table by inserting value from the other value of another Table
The following page has multi-table UPDATE ...Answered | 3 Replies | 4025 Views | Created by KhaLeeL ZoURoB - Wednesday, December 8, 2010 5:30 PM | Last reply by Kalman Toth - Monday, December 13, 2010 7:31 AM -
0 Votes
CTE to update one table value with other table value
[Table1]( [ID1] [int] PRIMARY KEY NOT NULL, [Value] [varchar](50) NULL ) INSERT INTO Table1 (ID1,Value) VALUES (1, null) , (2, null) , (3, ...Answered | 4 Replies | 1300 Views | Created by sql9 - Sunday, March 2, 2014 8:55 PM | Last reply by Jingyang Li - Monday, March 3, 2014 4:10 AM -
0 Votes
Update Other Tables?
That is the direction I went but couldn't quite figure out how call entites updates, passing in the values I wanted to update.Answered | 4 Replies | 2750 Views | Created by NamoGuy - Saturday, December 11, 2010 3:40 AM | Last reply by NamoGuy - Saturday, December 18, 2010 6:52 PM -
0 Votes
Show current values in table
i.e. same table as before, but this time, serial 1235 is purchased, sold and then purchased again?Answered | 6 Replies | 710 Views | Created by SilverArrows - Friday, September 9, 2016 3:25 AM | Last reply by SilverArrows - Tuesday, September 20, 2016 2:46 AM -
0 Votes
update table on a current flag
along with the MAX(id) join it with ur original table to update ...Answered | 8 Replies | 4430 Views | Created by MSGupta - Tuesday, April 5, 2011 3:38 AM | Last reply by MSGupta - Tuesday, April 5, 2011 3:07 PM -
0 Votes
Update table values with itself
DROP TABLE IF EXISTS #mytable; CREATE TABLE #mytable( id INTEGER NOT NULL PRIMARY KEY ,A1 VARCHAR(1) NULL ,Type VARCHAR(5) NULL ,A VARCHAR(4) ...Answered | 3 Replies | 501 Views | Created by Papil1 - Tuesday, March 19, 2019 2:47 PM | Last reply by Jingyang Li - Tuesday, March 19, 2019 4:15 PM -
0 Votes
best way to update a table from other table
Hi, Try this, if exists (select active from table1 t2 inner join table1 t1 on t1.id=t2.id and t2.active ='A') begin update t1 set ...Answered | 3 Replies | 4245 Views | Created by Rajendra Kumbar - Thursday, February 4, 2010 9:45 AM | Last reply by Sach Vaidya - Thursday, February 4, 2010 10:24 AM -
2 Votes
update one table with the max value of another table
This updated all the records in the table which wouldn't work for me.Answered | 11 Replies | 1340 Views | Created by gardner358 - Friday, February 14, 2014 12:22 PM | Last reply by Jingyang Li - Friday, February 14, 2014 1:16 PM -
1 Votes
Update with case and join other table
>> 02/01/2017 10:00:00 */ ,(123 , '01/01/2017 10:00:00' , '12/31/9000 12:00:00') /* .Answered | 8 Replies | 606 Views | Created by rommy08 - Thursday, March 30, 2017 6:20 AM | Last reply by rommy08 - Sunday, April 2, 2017 8:08 PM -
0 Votes
Using Query to Update Table - No Current record!!
You can only update tables.Answered | 3 Replies | 922 Views | Created by AngRuiz1 - Friday, October 4, 2013 5:58 PM | Last reply by Dirk Goldgar - Friday, October 4, 2013 7:02 PM -
0 Votes
update table
The original Sybase statement would do multiple updates of the target table when the source table was in a many-to-one relationship with the base table being ...Answered | 4 Replies | 710 Views | Created by Ajay Singh Rawat - Monday, November 23, 2015 4:52 PM | Last reply by --CELKO-- - Tuesday, November 24, 2015 3:05 AM -
1 Votes
Updating a table taking value from another table
create table product (id int, type varchar(50), cat int) Insert into product values (1,'suit', NULL),(2,'suit', NULL),(3,'suit', NULL),(4,'casual', NULL),(5,'casual', ...Answered | 2 Replies | 1682 Views | Created by DIEGOCTN - Thursday, September 12, 2013 11:05 AM | Last reply by Jingyang Li - Thursday, September 12, 2013 3:16 PM -
3 Votes
Creating and updating a dynamic table based on two other tables
On the other hand, many report tools include a pivoting functionality.Answered | 4 Replies | 663 Views | Created by MattyD318 - Monday, October 29, 2018 2:27 PM | Last reply by Erland Sommarskog - Tuesday, October 30, 2018 10:17 PM -
0 Votes
update table with values from another table
i have to tables; where: table ...Answered | 1 Replies | 6879 Views | Created by praetorean.nomad - Tuesday, September 2, 2008 9:16 AM | Last reply by Bill Wesse MSFT - Tuesday, September 2, 2008 2:12 PM -
2 Votes
update a table from table
create table t11_a (Grade float,id int) create table t22_b (grade nvarchar(255),id int) insert into t22_b (Grade,ID) values ...Answered | 6 Replies | 1301 Views | Created by Unwind_1 - Tuesday, April 9, 2013 8:09 PM | Last reply by Stan210 - Wednesday, April 10, 2013 12:46 PM -
2 Votes
Updating table records based on the other table
These look like they should have been done with positive and negative values on a single column with a more meaningful name.Answered | 6 Replies | 680 Views | Created by Sid Williams - Monday, August 1, 2016 12:54 PM | Last reply by --CELKO-- - Wednesday, August 3, 2016 5:37 PM -
0 Votes
Update value in one table with value from looping through another table
Assuming Claims table has unique PK you will join that temp table with your actual table into cte and thus it will work.Answered | 19 Replies | 3594 Views | Created by Stacie M - Thursday, April 17, 2014 3:01 PM | Last reply by Naomi N - Monday, May 26, 2014 7:46 PM -
0 Votes
Update Table With Values From Same Table
update t set t.boss = (select MAX(f.boss) from #Firefly f where f.name = t.name) from #Firefly t where t.boss is nullSam Zha TechNet ...Answered | 4 Replies | 788 Views | Created by AfraidToGetDirty - Monday, November 30, 2015 4:12 PM | Last reply by Uri Dimant - Tuesday, December 1, 2015 8:48 AM -
0 Votes
SQL -Update One Table based on Other Table ID & Date
CREATE TABLE Foobar_History (foo_id CHAR(9) NOT NULL, start_date DATE NOT NULL, end_date DATETIME, ...Answered | 4 Replies | 2057 Views | Created by Rihan8585 - Friday, January 25, 2013 11:59 AM | Last reply by Erland Sommarskog - Friday, January 25, 2013 11:04 PM - Items 1 to 20 of 2648979 Next ›
No announcements
