No announcements
Found 4093645 threads
-
1 VotesSelect a set of four consecutive records based on a search string
, I trigger a backup to fail by setting the destination to a non-existent drive letter. A failed backup generates a set of ...Answered | 2 Replies | 606 Views | Created by District9 - Wednesday, October 31, 2018 7:16 AM | Last reply by Will_Kong - Thursday, November 1, 2018 6:49 AM
-
0 Votes
comparing two string for four consecutive characters
) { //Create a collection of all of the 4-character substrings ...Answered | 3 Replies | 41 Views | Created by Anonymous - Thursday, February 7, 2013 5:18 PM | Last reply by Anonymous - Thursday, February 7, 2013 5:26 PM -
1 Votes
Search based on first alplabet of consecutive words
We have a table A with nvarchar column and store data like following: This is a TestEverything is great Now users want to ...Answered | 5 Replies | 3892 Views | Created by Harvinder Singh - Wednesday, February 13, 2013 9:37 PM | Last reply by SQLWork - Thursday, February 14, 2013 10:40 PM -
1 Votes
Select Top n records based on count of existing records
My dataset can have 4 distinct values . red green 1 orange 2 ...Answered | 3 Replies | 565 Views | Created by MLTC - Friday, June 24, 2016 8:14 PM | Last reply by pituach - Friday, June 24, 2016 10:28 PM -
0 Votes
Group By on Consecutive Records
) Select A.EntityName,A.LocationID,A.Timex as [StartTime], CASE WHEN A.Timex=a.c1 THEN DATEADD(HOUR,C2,a.Timex) ELSE a.c1 END AS [EndTime] from CTE A ...Answered | 2 Replies | 1654 Views | Created by Michael PRF - Saturday, April 4, 2015 11:18 PM | Last reply by Eric__Zhang - Monday, April 6, 2015 2:36 PM -
0 Votes
Select property based on string value
string value. I am using LINQ which automatically creates a class for each table. The actual columns in the table become properties of the class. I need ...Answered | 3 Replies | 13 Views | Created by Anonymous - Sunday, January 31, 2010 11:09 PM | Last reply by Anonymous - Tuesday, February 2, 2010 12:24 AM -
1 Votes
selecting consecutive records from a table based on a column value
Why not use a set based query rather than recursion? declare @temp2 table ( cola varchar(100), colb ...Answered | 24 Replies | 4713 Views | Created by mnmhema - Thursday, October 17, 2013 7:44 AM | Last reply by HimanshuSharma - Tuesday, November 5, 2013 10:25 AM -
0 Votes
set a treeview selected based on a query string.
querystring of the value of the XML file is matched , the tree node sets a setfocus or highlights on a particular node from the querystring passed ...Answered | 2 Replies | 5 Views | Created by Anonymous - Monday, June 21, 2010 12:32 PM | Last reply by Anonymous - Wednesday, June 23, 2010 11:26 PM -
0 Votes
genorating consecutive charicters as a string body:
string. for example set a textbox text to "aaaa" then a half a second later to "aaab" and "aaac" ...Answered | 2 Replies | 3918 Views | Created by jbbiz - Tuesday, June 7, 2011 8:19 PM | Last reply by Rod Stephens - Tuesday, June 21, 2011 3:11 PM -
0 Votes
Get records based on a string containing Special Character (γ)
You need to put a N before the unicode string like: select * from table where column = N'γ' select * from ...Answered | 7 Replies | 809 Views | Created by TRUNKASH - Wednesday, September 12, 2018 10:41 PM | Last reply by Visakh16 - Monday, September 17, 2018 1:44 PM -
4 Votes
Spliting String based on a string
/spliting-string-based-on-a-string?forum=transactsql&prof=required" rel="nofollow" title="About Ousama EL HOR" ...Answered | 8 Replies | 584 Views | Created by DM2017 - Thursday, November 30, 2017 9:04 AM | Last reply by Ousama EL HOR - Monday, December 4, 2017 10:19 AM -
0 Votes
Select a grid row based on query string data?
User337313793 posted Greetings! I need to know how can I select a gridview row based on a query string ...Answered | 1 Replies | 5 Views | Created by Anonymous - Wednesday, January 13, 2010 5:02 PM | Last reply by Anonymous - Wednesday, January 13, 2010 5:55 PM -
0 Votes
How get date differance from a single date of a single table on a consecutive records
,a.dt as dt1 ,b.dt as dt2 ,datediff(day,a.dt,b.dt) from cte a join cte b on a.id=b.id and ...Answered | 4 Replies | 3768 Views | Created by Jay033 - Wednesday, April 1, 2009 4:57 PM | Last reply by Jay033 - Thursday, April 2, 2009 9:12 PM -
0 Votes
Select records based on max date
',NULL,NULL DECLARE @USERID INT SET @USERID=1 DECLARE @MODULEID INT SET @MODULEID=1 ;WITH CTE1 ...Answered | 4 Replies | 8 Views | Created by Anonymous - Tuesday, December 15, 2009 7:09 AM | Last reply by Anonymous - Tuesday, December 15, 2009 5:21 PM -
0 Votes
How to set a variable based on Select result?
= '2014' SET @adate = CASE @datecode WHEN 'sWTD' THEN ( SELECT MIN(d.DateValue) FROM @dimDate d INNER JOIN @dimShowing s ON S.DateID = ...Answered | 4 Replies | 916 Views | Created by Developer life - Wednesday, August 6, 2014 11:04 PM | Last reply by Quest1234 - Thursday, August 7, 2014 8:59 AM -
0 Votes
Select a comlun based on a parameter
hey Ken, I tried to encapsulte the whole thing into the string, but the string has some parameters also and when we try to execute the string it says ...Answered | 6 Replies | 4404 Views | Created by SQLUser1979 - Wednesday, December 3, 2008 7:30 PM | Last reply by Ken Simmons - Wednesday, December 3, 2008 8:03 PM -
0 Votes
Set a field value based on query string
Hi, I have a list where I need to set field value based on the query string I have this field called ...Answered | 7 Replies | 5140 Views | Created by Praveen Teja - Tuesday, August 13, 2013 7:54 AM | Last reply by 19_KLC_15 - Thursday, August 29, 2013 9:23 PM -
2 Votes
removing three consecutive dots in a string "..."
For removing the string occurrences, you can utilize the string.Replace method. so you will be doingAnswered | 4 Replies | 3740 Views | Created by arsalancheema - Thursday, November 26, 2009 3:18 PM | Last reply by A.m.a.L Hashim - Thursday, November 26, 2009 3:45 PM -
0 Votes
Select records based on previous record...
User77042963 posted Since you know your data is in a fixed order based on date, I'll give it a ...Answered | 9 Replies | 7 Views | Created by Anonymous - Wednesday, March 23, 2011 5:47 AM | Last reply by Anonymous - Wednesday, March 23, 2011 3:45 PM -
3 Votes
Is there a way to programmatically insert a set of records in one table based on a set of records in another table?
. Projects contain Work Orders. There are preset databased templates of WOs that are generated based on preset templates. The ...Answered | 3 Replies | 3130 Views | Created by MarkA Howell - Tuesday, August 23, 2011 1:46 PM | Last reply by MarkA Howell - Tuesday, August 23, 2011 10:51 PM - Items 1 to 20 of 4093645 Next ›
No announcements
