No announcements
Found 4065611 threads
-
1 VotesDuplicate first row of result set
Not to remove the duplicate, but to create it for the first row.Answered | 6 Replies | 628 Views | Created by Alex Vary - Thursday, May 19, 2016 6:57 AM | Last reply by Alex Vary - Thursday, May 26, 2016 10:51 AM
-
0 Votes
DELETE first 'n' rows created!
Hi McAvelli, If you don't know what column can be used to find the 50 oldest rows, then how should SQL Server know?Answered | 5 Replies | 7542 Views | Created by McAvelli - Wednesday, December 29, 2010 5:11 AM | Last reply by Rick Byham, Microsoft - Thursday, December 30, 2010 5:16 PM -
0 Votes
Why only the first record shows in the Row Group?
Your link refers to SQL Server 2008 R2 I, however, am using VS 2005 ~ Business Intelligence Projects ~ our version of SQL Server is ...Answered | 6 Replies | 4261 Views | Created by wind07 - Monday, November 29, 2010 7:15 PM | Last reply by Challen Fu - Friday, December 3, 2010 2:27 AM -
0 Votes
BindingNavigatorDeleteItem_Click always deletes the first row and the selected row.
When this setting was changed from DeleteItem = BindingNavigatorDeleteItem to DeleteItem = None, the first row is no longer deleted.Answered | 2 Replies | 932 Views | Created by bswanson27 - Wednesday, July 19, 2017 8:38 PM | Last reply by bswanson27 - Thursday, July 20, 2017 1:22 PM -
0 Votes
Row versioing why only update
UPDATE and DELETE statements create a row version in tempdb bit INSERT statements do not.Answered | 4 Replies | 3627 Views | Created by Manu_vmr - Sunday, September 4, 2011 2:05 AM | Last reply by Manu_vmr - Monday, September 5, 2011 1:28 AM -
0 Votes
Why are deletes not done first?
I have a list of items with a length that can change depending on a value in the parent.Answered | 2 Replies | 2924 Views | Created by Joe Farlow - Thursday, August 27, 2009 7:24 PM | Last reply by Joe Farlow - Friday, August 28, 2009 12:20 AM -
0 Votes
Get results on a second row only?
But always same order until no insert/update/delete operations executed..Answered | 4 Replies | 3757 Views | Created by Rudy68 - Saturday, September 25, 2010 6:12 PM | Last reply by ramireddy - Sunday, September 26, 2010 5:47 AM -
0 Votes
deleting rows
This code snippet tries to delete the first row in the data table regardless of whether or not one exists.Answered | 5 Replies | 1115 Views | Created by Ron399 - Sunday, May 26, 2013 11:50 AM | Last reply by Dan Guzman - Sunday, May 26, 2013 12:42 PM -
2 Votes
How do I delete the first row in a Range Object
To delete the first row of the range, but leave cells to the left and/or right unchanged: MyRange.Rows(1).Delete ...Answered | 1 Replies | 3954 Views | Created by kjljlkjjkjl - Friday, April 19, 2013 9:15 PM | Last reply by Hans Vogelaar MVP - Friday, April 19, 2013 9:27 PM -
2 Votes
[Bug] Get unexpected result from: ORDER BY [ColumnName] ASC OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY
The order of the rows returned is determined only based on the order by clause.Answered | 5 Replies | 1620 Views | Created by Hung.Doan - Saturday, April 4, 2015 10:02 AM | Last reply by Dan Guzman - Saturday, April 4, 2015 7:51 PM -
3 Votes
Only Display First 3 Rows of Tablix
http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/0551e3c4-7e0a-417c-aa99-514f5fb4be13 After you add a sorting to your tablix, then ...Answered | 4 Replies | 13616 Views | Created by stoneb1965 - Sunday, September 23, 2012 11:49 AM | Last reply by Charlie Liao - Wednesday, September 26, 2012 7:40 AM -
4 Votes
Can't delete the row that i want ??
Ya i set Dim intCurrentIndex As Integer = 0 but if i set to 1 it will delete first 2 rows let me ASK you, are ...Answered | 9 Replies | 3273 Views | Created by KaNiMaKi - Wednesday, December 30, 2009 3:33 AM | Last reply by KaNi-MaKi - Monday, January 4, 2010 8:31 AM -
0 Votes
DELETE row and show previous row.
Problem you have mentioned could be occur when first row is deleted.Answered | 12 Replies | 3177 Views | Created by Vital_Parsley705 - Saturday, September 19, 2009 4:57 PM | Last reply by Vital_Parsley705 - Monday, September 21, 2009 5:38 AM -
0 Votes
Code Coverage only works on first attempt... why?
Can you explain why we need to stop the ASP.Net Development Server each time explicitly?Answered | 18 Replies | 2941 Views | Created by Cranky Coder - Wednesday, August 29, 2012 6:25 PM | Last reply by Cranky Coder - Thursday, September 13, 2012 1:23 PM -
0 Votes
How can i know a row is deleted successfully
Check value of @@rowcount if it is greater than 0, it means deleted successfully.....Answered | 1 Replies | 5046 Views | Created by irmorteza - Friday, September 24, 2010 8:58 AM | Last reply by ramireddy - Friday, September 24, 2010 9:06 AM -
0 Votes
Delete is only deleting every other row
This can be beneficial to other community members reading this thread.Answered | 2 Replies | 350 Views | Created by ReptileMikael - Wednesday, February 6, 2019 7:14 PM | Last reply by Alex-KSGZ - Tuesday, February 12, 2019 7:42 AM -
0 Votes
delete a row from a table
It is when I delete the current row and then try to display the table again that I get the error.Answered | 3 Replies | 4638 Views | Created by CanAnn - Tuesday, July 5, 2011 4:44 PM | Last reply by Neddy Ren - Friday, July 8, 2011 9:01 AM -
1 Votes
Why rows are duplicated for a Table?
Strategically adding these constrains can eliminate duplicates (well, after you remove the dups first, since the constraints won't allow you to add them) 2.Answered | 1 Replies | 7742 Views | Created by Wonjartran - Friday, March 5, 2010 7:10 PM | Last reply by Louis Davidson - Friday, March 5, 2010 10:54 PM -
0 Votes
Delete first two rows in a csv file
Hi Daniel, In the flat file connection manager editor window, you can find an option "Header Rows to skip".Answered | 2 Replies | 3289 Views | Created by Daniel Dahl - Wednesday, August 27, 2014 8:41 AM | Last reply by Ch. Rajen Singh - Wednesday, August 27, 2014 9:37 AM -
0 Votes
Rows deleted
The only possible exception may be the case when the number of affected rows is more than 2 billion (!)Answered | 4 Replies | 3680 Views | Created by Andy Fordyce - Friday, September 4, 2009 4:46 AM | Last reply by Varsham Papikian - Friday, September 4, 2009 5:43 AM - Items 1 to 20 of 4065611 Next ›
No announcements
