No announcements
Found 2652764 threads
-
1 Votes
selecting consecutive records from a table based on a column value
> I need to select a group of 4 records [sic] where the first record’s [sic] binary number ends with 00, the assignment_status = 'F' and the beta_value must have ...Answered | 24 Replies | 4919 Views | Created by mnmhema - Thursday, October 17, 2013 7:44 AM | Last reply by HimanshuSharma - Tuesday, November 5, 2013 10:25 AM -
1 Votes
Select a set of four consecutive records based on a search string
How can I grab the four consecutive records, or multiple sets of four if there have been multiple backup ...Answered | 2 Replies | 644 Views | Created by District9 - Wednesday, October 31, 2018 7:16 AM | Last reply by Will_Kong - Thursday, November 1, 2018 6:49 AM -
4 Votes
How to capture consecutive records in a table
i want one more change which i just found out couple mins back, then i think i am good after that I only want to count first 5 consecutive days not all ...Answered | 15 Replies | 912 Views | Created by smtest - Wednesday, January 29, 2014 4:25 AM | Last reply by smtest - Wednesday, January 29, 2014 4:38 PM -
0 Votes
How to search for a set of string in a column
0 begin set @likeThis = @likeThis + 'color+breed like ''%'+left(@searchString,charindex(' ',@searchString)-1)+'%'' or ' set @searchString = ...Answered | 5 Replies | 819 Views | Created by wakefun - Friday, May 23, 2014 10:30 AM | Last reply by Patrick Hurst - Friday, May 23, 2014 2:16 PM -
0 Votes
Regex to validate a string contiaining consecutive periods
consecutive periods would be \.{2,} This regex means there must be a minimum of 2 periods and no max.Answered | 4 Replies | 7862 Views | Created by RK Naik - Friday, March 4, 2011 3:22 PM | Last reply by RK Naik - Monday, March 7, 2011 3:25 PM -
0 Votes
Search by Last Four Character in Encrypted Data.
If there are any other columns that can limit the result set use them in any joins you have between this table and the next.Answered | 4 Replies | 1804 Views | Created by Vijay Kalaiselvan - Monday, November 5, 2012 7:17 PM | Last reply by Vijay Kalaiselvan - Thursday, November 15, 2012 8:48 AM -
2 Votes
Need to Open a form based on selection to a specific record
To open a form to a specific record, you can use the Where clause like you're doing but make sure the form is set up correctly.Answered | 11 Replies | 816 Views | Created by seebert - Tuesday, October 13, 2015 12:33 PM | Last reply by Edward8520 - Thursday, October 22, 2015 5:11 AM -
3 Votes
Selection of a record based on an id
SELECT ID, 'Same' as Status FROM myTable GROUP BY ID HAVING MIN(ParticularField) = MAX(ParticularField) UNION ALL SELECT ID, 'Different' as ...Answered | 2 Replies | 2064 Views | Created by thekind78 - Friday, May 4, 2012 1:09 PM | Last reply by Naomi N - Friday, May 4, 2012 1:19 PM -
1 Votes
Searching INI files - to select-string or not to select-string?
I'm looking for a means of reviewing remote INI files to verify settings within certain sections.Answered | 2 Replies | 2094 Views | Created by BAWrites - Thursday, January 14, 2016 9:33 PM | Last reply by BAWrites - Friday, January 15, 2016 1:48 PM -
0 Votes
SELECTING record based on condition
Yes we can have numerous records for the same date with 'ON','OFF' but i need to consider state with 'ON' (single row for multiple entries same date) And if all are 'OFF' ...Answered | 3 Replies | 726 Views | Created by Priya Bange - Wednesday, March 4, 2015 8:53 AM | Last reply by Jingyang Li - Wednesday, March 4, 2015 2:01 PM -
0 Votes
How to find consecutive records below a certain value?
I'm polling (every 10 minutes or so) and recording state changes in a 'service' with a reason for the change.Answered | 2 Replies | 8156 Views | Created by mdblackadder - Tuesday, December 6, 2011 4:20 PM | Last reply by sekhara shiris chinta - Tuesday, December 20, 2011 1:39 PM -
2 Votes
Select next available consecutive range
I also see that a similar idea to mine was used, but we filtered the bad records on the first step and then grouped consecutive ranges together.Answered | 14 Replies | 2760 Views | Created by Jacques Laurin - Monday, December 5, 2011 10:14 PM | Last reply by Naomi N - Tuesday, December 6, 2011 4:39 PM -
0 Votes
SELECT record based on time frames
I have two data sets I am trying to match up, but NOT based on some type of relational key.Answered | 2 Replies | 4540 Views | Created by David in Fort Myers - Wednesday, January 5, 2011 8:17 PM | Last reply by David in Fort Myers - Friday, January 7, 2011 4:01 PM -
1 Votes
check that string is four charachers and numeric
;--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL ...Answered | 6 Replies | 697 Views | Created by jschroeder - Friday, June 29, 2018 4:09 PM | Last reply by --CELKO-- - Sunday, July 1, 2018 5:33 PM -
0 Votes
Flagging consecutive weeks with a bit more complexity
> I want to flag [sic] each record [sic] if the worker has worked ABOVE 12 consecutive weeks.Answered | 3 Replies | 728 Views | Created by Kenmack - Friday, July 22, 2016 7:25 PM | Last reply by --CELKO-- - Saturday, July 23, 2016 9:33 PM -
5 Votes
Consecutive days - Best way
Does he want a boolean indicating that they're "consecutive" in the sense that he means or does he want a list of all consecutive ones back, given a starting date ...Answered | 25 Replies | 4856 Views | Created by Vik B - Thursday, April 5, 2012 3:17 AM | Last reply by SJWhiteley - Thursday, April 5, 2012 8:10 PM -
1 Votes
SELECT a String record from a table
Hi SQL_Gun, When running the query like below As you can see on the screenshot, there a question mark at the ...Answered | 8 Replies | 710 Views | Created by SQL_Gun - Tuesday, March 3, 2015 5:24 AM | Last reply by Charlie Liao - Thursday, March 5, 2015 8:51 AM -
0 Votes
Access form to delete the records based on combobox selection
Private Sub cmdDelete_Click() Dim strWhere As String Dim strSQL As String If Not IsNull(Me.cbxNumberField1) Then strWhere = ...Answered | 1 Replies | 1858 Views | Created by zaveri cc - Friday, January 3, 2014 6:20 PM | Last reply by Hans Vogelaar MVP - Friday, January 3, 2014 9:14 PM -
0 Votes
searching for set of strings in a string using Excel VBA
You need to use RegEx and expression to look for a set of characters.Answered | 2 Replies | 595 Views | Created by SJ3007 - Wednesday, February 10, 2016 8:16 AM | Last reply by Cor Ligthert - Wednesday, February 10, 2016 10:29 AM -
0 Votes
Find out unique counts based on consecutive days
Declare @Test TABLE (id int,[Date] date) INSERT INTO @Test ...Answered | 4 Replies | 826 Views | Created by app087 - Thursday, July 9, 2015 9:13 PM | Last reply by app087 - Friday, July 10, 2015 12:27 PM - Items 1 to 20 of 2652764 Next ›
No announcements