No announcements
Found 3301239 threads
-
0 VotesMerge Replication - My Required Scenrio
I just need to replicate Clients Side Table Data and merge into single Server Table.Answered | 5 Replies | 6082 Views | Created by -Haseeb Ahmad- - Monday, January 11, 2010 12:01 PM | Last reply by Hilary Cotter - Tuesday, January 12, 2010 10:53 AM
-
0 Votes
Need Update Query Based On My Scenrio
Query: update fruit_data set qty = (CASE WHEN ref_no = 'A1' and type='Fruit' and ...Answered | 2 Replies | 45 Views | Created by Anonymous - Thursday, September 7, 2017 7:47 AM | Last reply by Anonymous - Thursday, September 7, 2017 9:01 AM -
2 Votes
Need a query to update data fastly
Please provide details on your SQL Server environment such as version and edition, also DDL statements for tables when posting T-SQL ...Answered | 3 Replies | 1746 Views | Created by Jibzz - Monday, March 4, 2013 5:59 AM | Last reply by Richard Douglas - Tuesday, March 5, 2013 9:50 AM -
0 Votes
Spatial Query update based on STIntersects SLOW!
You just need the xml of the execution plan?Answered | 8 Replies | 7035 Views | Created by BTIDoug - Monday, September 17, 2012 5:54 PM | Last reply by Bob Beauchemin - Monday, September 17, 2012 10:08 PM -
1 Votes
PREEMPTIVE_OLEDBOPS when I run my update query having linked server hence need help in framing the update query
Your pointers were enough to build the query .Answered | 5 Replies | 9341 Views | Created by MLTC - Thursday, May 24, 2012 7:25 AM | Last reply by MLTC - Thursday, May 24, 2012 12:25 PM -
0 Votes
Update Problem on my Query
The old 1970's Sybase UPDATE..Answered | 2 Replies | 1081 Views | Created by Barlet Hamzai - Monday, April 1, 2013 10:53 PM | Last reply by --CELKO-- - Tuesday, April 2, 2013 12:12 AM -
0 Votes
Please correct my update query
DECLARE @CFQ_Referrals TABLE (RecID INT, value INT, quoteType CHAR(5), quoteDate datetime) INSERT INTO @CFQ_Referrals (RecID, value, quoteType, quoteDate) VALUES ...Answered | 1 Replies | 680 Views | Created by SQL_SSIS_Dev - Thursday, November 20, 2014 9:40 PM | Last reply by Patrick Hurst - Thursday, November 20, 2014 9:51 PM -
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 | 3908 Views | Created by NSG12 - Thursday, January 22, 2009 5:56 PM | Last reply by Mark Steinberg - Thursday, January 22, 2009 10:47 PM -
2 Votes
Need help with Update Join Query
create table #parent (PID varchar(10), lastname varchar(50), firstname varchar(50)) insert into #parent values ('100','Josheph','Sumali') insert into #parent values ...Answered | 4 Replies | 727 Views | Created by Kevin Ruth - Wednesday, December 3, 2014 4:15 AM | Last reply by Kevin Ruth - Wednesday, December 3, 2014 4:43 AM -
0 Votes
Need to Sql Query to Update Category
0 THEN 'Not Repeated' ELSE 'Repeated' END AS YourSTatus FROM CTE c1 LEFT JOIN ( SELECT DBName,Category,COUNT(*) AS Cnt FROMAnswered | 5 Replies | 603 Views | Created by harikiran2010 - Wednesday, January 3, 2018 7:58 AM | Last reply by Visakh16 - Wednesday, January 3, 2018 11:42 AM -
0 Votes
VBA command needed to run update query
In your update query, go to SQL view.Answered | 8 Replies | 56331 Views | Created by fandahill - Friday, June 17, 2011 6:48 PM | Last reply by dhargis - Wednesday, September 11, 2013 8:52 PM -
1 Votes
[Q] Need help for my Query
query.Answered | 14 Replies | 1467 Views | Created by Indra Hermawan - Friday, September 6, 2013 3:39 AM | Last reply by SQLZealots - Friday, September 6, 2013 12:28 PM -
1 Votes
Need help to create an update query
And F1.Item08Name = F2.EngName) Or (F1.Item09 = 'X' And F1.Item09Name = F2.EngName); With ComputedFRChoice As (Select s.recid, (Select ', ' + s2.FrenchName From ...Answered | 2 Replies | 4017 Views | Created by ICW - Saturday, August 14, 2010 5:35 AM | Last reply by ICW - Saturday, August 14, 2010 3:53 PM -
0 Votes
Need a query for my requirement...
My blogAnswered | 19 Replies | 3527 Views | Created by Muthukumar Rajendran - Thursday, April 15, 2010 1:41 PM | Last reply by Naomi N - Friday, April 16, 2010 1:23 PM -
5 Votes
Help with an update based on a query's output
Also, I don't think you need () in your statement.Answered | 8 Replies | 6769 Views | Created by Spektre - Tuesday, February 8, 2011 8:09 PM | Last reply by Naomi N - Sunday, February 13, 2011 11:36 PM -
0 Votes
i need to merge the two query for my sp
> there is no dependent relation between the two tables,now my need is to join the following queries and then to create as Stored Procedure....Answered | 4 Replies | 4005 Views | Created by Muthukumar Rajendran - Tuesday, February 23, 2010 11:30 AM | Last reply by Nai-dong Jin - MSFT - Friday, February 26, 2010 3:07 AM -
3 Votes
Need help with my query
My blogAnswered | 13 Replies | 3399 Views | Created by wondergoat777 - Monday, March 26, 2012 7:12 PM | Last reply by Naomi N - Monday, March 26, 2012 8:15 PM -
0 Votes
know what query updated my table
To track who and what performed changes to a table, you need to cater for this yourself.Answered | 2 Replies | 951 Views | Created by rama rose - Thursday, January 2, 2014 9:30 PM | Last reply by Erland Sommarskog - Thursday, January 2, 2014 10:42 PM -
1 Votes
Need help optimizing my query
We can not read minds; what would we need to know to do your job for you?Answered | 6 Replies | 3229 Views | Created by mr JT - Thursday, August 11, 2011 2:13 PM | Last reply by --CELKO-- - Thursday, August 11, 2011 3:53 PM -
0 Votes
update query
thank for replying I think u r updating all the record but i want to update only one record which is greater than the quantity. if u look at my ...Answered | 7 Replies | 4016 Views | Created by luckyforu2006 - Monday, November 29, 2010 1:12 PM | Last reply by Badii Gharbi - Tuesday, November 30, 2010 8:30 AM - Items 1 to 20 of 3301239 Next ›
No announcements
