No announcements
Found 3631596 threads
-
0 Voteshelp with query - update from 2 tables
Hmm, it is SQL Server forum, I do not know if it is exact syntax MERGE t1 USING t2 ON t1.id = t2.id WHEN ...Answered | 3 Replies | 4160 Views | Created by E_gold - Wednesday, September 15, 2010 8:45 AM | Last reply by Uri Dimant - Wednesday, September 15, 2010 9:33 AM
-
0 Votes
Query need for 2 table update
It would be nice and helpful , if somebody could help me to get a proc or query for this.Answered | 3 Replies | 3910 Views | Created by NSG12 - Thursday, January 22, 2009 5:56 PM | Last reply by Mark Steinberg - Thursday, January 22, 2009 10:47 PM -
0 Votes
Query Help Merging 2 Tables
I was most definitely appreciated and helpful.Answered | 16 Replies | 2002 Views | Created by TammySutherland - Friday, July 26, 2013 7:27 PM | Last reply by Lorena Maria - Friday, August 2, 2013 5:28 PM -
1 Votes
Querying data from 2 tables
= A.StartID AND 3 <= A.EndID AND 3 >= B.StartID AND 3Answered | 3 Replies | 800 Views | Created by Jackson.C - Wednesday, January 28, 2015 2:57 PM | Last reply by Arbi Baghdanian - Wednesday, January 28, 2015 4:03 PM -
0 Votes
Updating 2 tables from DataGridView
See the below ...Answered | 2 Replies | 1420 Views | Created by zbiebu - Thursday, June 21, 2012 12:39 PM | Last reply by Cor Ligthert - Thursday, June 21, 2012 3:04 PM -
0 Votes
how update table from query
Instead of this approach, you could consider using a Calendar table.Answered | 4 Replies | 4988 Views | Created by Alex Q8 - Thursday, March 24, 2011 7:55 AM | Last reply by Gert-Jan Strik - Thursday, March 24, 2011 7:42 PM -
0 Votes
Updating table from complex query
A virtual table is just as much a table as anything else in SQL.Answered | 4 Replies | 566 Views | Created by Y a h y a - Monday, August 29, 2016 5:35 PM | Last reply by --CELKO-- - Monday, August 29, 2016 7:35 PM -
0 Votes
Updating 2 tables in a view
A view based on multiple base tables must use an INSTEAD OF trigger to support inserts, updates, and deletes that reference data in more than one table.Answered | 12 Replies | 865 Views | Created by Nonabona - Thursday, October 16, 2014 6:20 PM | Last reply by Nonabona - Thursday, October 16, 2014 8:36 PM -
1 Votes
How to update the data of the table with the help of a single query.
OR, Update @user set gender = ( Case when gender ='M' then 'F' ...Answered | 2 Replies | 1644 Views | Created by Beenal Trivedi - Saturday, August 10, 2013 9:34 AM | Last reply by Chongtham Rajen Singh - Sunday, August 11, 2013 7:31 AM -
0 Votes
Update query help?
Hello CoolMind, No your last query doesn't give me my expected output, check out the o/p print by Hunchback in his last reply it is the same I want it, but now I have to ...Answered | 14 Replies | 3036 Views | Created by gk1393 - Wednesday, August 18, 2010 7:46 PM | Last reply by gk1393 - Thursday, August 19, 2010 12:05 AM -
0 Votes
Insert Query from unleated 2 tables
Actually 2 columns in table 3.Answered | 11 Replies | 1497 Views | Created by akhilrajau - Thursday, May 9, 2013 12:30 PM | Last reply by akhilrajau - Thursday, May 9, 2013 2:07 PM -
0 Votes
SQL Update joining 2 tables
Hi ddee, Do the answers above help you?Answered | 5 Replies | 1545 Views | Created by ddee - Friday, June 5, 2020 8:54 PM | Last reply by Lily Lii - Tuesday, June 9, 2020 6:14 AM -
4 Votes
Help in update query
update d set depdesc = RTRIM(d.depdesc) + ' (' + left(d.depname, 4) + ')' from #dep d If still issue then try ...Answered | 5 Replies | 474 Views | Created by Kevin Ruth - Wednesday, May 24, 2017 7:09 PM | Last reply by Bharath Thamilarasan - Wednesday, May 24, 2017 9:17 PM -
4 Votes
How to Update table query
One way is to insert into a #temp table after deleting, truncate the dbo.student (to reseed the identity), then insert into dbo.student from the #temp table.Answered | 8 Replies | 1897 Views | Created by Ajay Singh Rawat - Thursday, November 1, 2012 7:03 AM | Last reply by Kapil.Kumawat - Thursday, November 1, 2012 1:50 PM -
1 Votes
Help: Update Query
I need to update ~5000 entries in a specific field from a 6-digit number to a 7-digit number, just adding a 0 to the front of the ...Answered | 2 Replies | 740 Views | Created by janna lane - Thursday, April 3, 2014 4:26 PM | Last reply by Henry Habermacher - Friday, April 4, 2014 10:34 AM -
3 Votes
updating power query tables
The tables that power query grabs from (not inside power query).Answered | 3 Replies | 1064 Views | Created by AlexMartini - Friday, November 4, 2016 6:33 PM | Last reply by Angelia Zhang - Tuesday, November 8, 2016 9:27 AM -
0 Votes
Query tables from 2 different servers
Use linked server to connect both servers and write query as you want.Answered | 9 Replies | 4993 Views | Created by collie12 - Sunday, June 13, 2010 12:05 PM | Last reply by Sorna Kumar Muthuraj - Monday, June 14, 2010 7:26 AM -
1 Votes
Need sql query from 2 tables
What good would it do you if we posted the screen shot of the query?Answered | 9 Replies | 1488 Views | Created by Kris_sp2013 - Saturday, March 30, 2013 3:25 PM | Last reply by Josh Ashwood - Tuesday, April 2, 2013 4:13 AM -
1 Votes
Query for the table update
but exactly I am looking for, lets say there is a table called employee and this table is associated with the application (say employee asset). so if somebody will insert or ...Answered | 3 Replies | 640 Views | Created by Ashu_T - Thursday, September 25, 2014 11:30 AM | Last reply by pituach - Thursday, September 25, 2014 12:17 PM -
1 Votes
help with update query
If code1 is a unique field then you can do an update on a table join like this: UPDATE tableA t1 INNER JOIN tableB t2 ON ...Answered | 2 Replies | 629 Views | Created by E_gold - Monday, December 23, 2013 6:25 PM | Last reply by Rich P123 - Monday, December 23, 2013 6:42 PM - Items 1 to 20 of 3631596 Next ›
No announcements
