No announcements
-
0 VotesPOSTING TIPS - Code, Images, Hyperlinks, Details
When you're posting a question - please search the forum first! If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below. If you're asking for ...
-
0 Votes
Extract Month Name From String
Hi Developers i trust all is well quick question if i have a string named "H7_1985_Jun 2016.xlsx", and i need to extract ...Unanswered | 4 Replies | 16 Views | Created by Ronald Van Der Westhuizen - 21 minutes ago | Last reply by Jingyang Li - 2 minutes ago -
0 Votes
T-SQL query performance
Hi, I have a tSQL query. when running using ssms , it took around 21 seconds. If I run the same SQL as agent step, it takes more than 4 ...Unanswered | 3 Replies | 38 Views | Created by kiranshiva - 1 hour 18 minutes ago | Last reply by kiranshiva - 8 minutes ago -
7 Votes
How to remove all even characters from a string???
How can I make: 'Deoxyribonucleic acid' into 'Doyiouli cd' What string functions would I use? How ...Answered | 15 Replies | 430 Views | Created by soldierfc - Saturday, October 5, 2019 4:03 PM | Last reply by Soumen Barua - 31 minutes ago -
0 Votes
How to optimize SQL query with calculation
I have a query that contain calculation (as below) and it's causing blocking to other select query to tableA. Would like to get advise how to optimize this kind of query. (@ColumnA ...Unanswered | 11 Replies | 142 Views | Created by xia0lin - Monday, October 7, 2019 9:15 AM | Last reply by SQLZealots - 2 hours 55 minutes ago -
0 Votes
Fastest way to SELECT or INSERT a record and returning an ID
I'm trying to figure out what is the fastest way to select or insert a row in a table by returning the corresponding ID in a scenario where multiple threads run on the same table. In other words, each ...Unanswered | 31 Replies | 1270 Views | Created by dsmwb - Wednesday, September 18, 2019 12:46 PM | Last reply by dsmwb - 3 hours 39 minutes ago -
0 Votes
Finding duration of sellers selling in a month's duration
Hi All, Hope you are doing well!... I am trying to find the timeframes of the sellers selling items in a months duration in hours...Also if the seller is NULL then those rows ...Answered | 8 Replies | 376 Views | Created by Hellothere8028 - Thursday, October 3, 2019 10:53 AM | Last reply by Hellothere8028 - 5 hours 36 minutes ago -
0 Votes
LCK M SCH S lock waiting time
Transaction isolation level in database is "READ COMMITTED SNAPSHOT" to prevent locking. I have query like this(which is send from ...Answered | 9 Replies | 359 Views | Created by simonxy - Thursday, October 3, 2019 10:03 AM | Last reply by simonxy - 5 hours 38 minutes ago -
0 Votes
Alternatives to using OR in a join clause
= #TMP_WW_AdultCriticalCare.[CRITICAL_CARE_START_DATE_TIME] AND [CDI_APC_WARD_STAY].[START_DATE_TIME_WARD_STAY] < ...Unanswered | 2 Replies | 199 Views | Created by SimonKEvans - Thursday, September 26, 2019 7:39 AM | Last reply by Rachel_Wang - 6 hours 39 minutes ago -
0 Votes
How to update an HTML element in a string
Dear all, I need to change a HTML element from a single string database field In the whole string return I need to replace all string which is inside ...Answered | 5 Replies | 122 Views | Created by wakefun - Monday, October 7, 2019 7:56 AM | Last reply by Rachel_Wang - 7 hours 11 minutes ago -
0 Votes
sql deadlocks
Can someone let me know the DBA scope in checking sql deadlocks on a server? Application team has been receiving alerts stating there are more deadlocks happening on a ...Unanswered | 5 Replies | 125 Views | Created by SSG92 - Monday, October 7, 2019 9:11 AM | Last reply by Rachel_Wang - 7 hours 22 minutes ago -
0 Votes
Get all products where it meets a condition
Products (id, name, price, active): 1 | Bicycle | 500.00 | False 2 | Kettle | 50.00 | True 3 | Pen | 20.00 | False 4 | Board | 5.00 | ...Unanswered | 6 Replies | 108 Views | Created by Pure Deal - 22 hours 49 minutes ago | Last reply by Rachel_Wang - 7 hours 50 minutes ago -
0 Votes
Finding the duration of the sellers selling
Hi All, Hope you are doing well!...I am trying to understand the duration at which specific sellers sell an item for ...Also the seller which sells the item for the longest ...Answered | 9 Replies | 462 Views | Created by Hellothere8028 - Tuesday, October 1, 2019 8:28 AM | Last reply by Hellothere8028 - 8 hours 18 minutes ago -
0 Votes
Competing Table Updates
I have multiple copies of the same C# program running on different servers, each called a Stored Procedure with the below Update Statement in order to "get a lock" on the row. I check the ...Unanswered | 9 Replies | 119 Views | Created by Jarrod859 - 20 hours 18 minutes ago | Last reply by Viorel_ - 8 hours 58 minutes ago -
0 Votes
Error in sql server 2008
i have a script of sql server 2014 like this: ;WITH cte AS ( SELECT *,100*COUNT([MIndex]) OVER(PARTITION BY ProjectId, ParentType, ...Answered | 6 Replies | 256 Views | Created by Nguyen Duy Hoa -Mr.- - Thursday, October 3, 2019 4:18 AM | Last reply by Arulmouzhi - 10 hours 20 minutes ago -
0 Votes
Select statement with IN
00546 is same as 546 00854 is same as 854 The following SQL returns only '123 NY' How do I return all 3 ...Unanswered | 7 Replies | 103 Views | Created by MikeGanem2 - 17 hours 10 minutes ago | Last reply by Arulmouzhi - 11 hours 36 minutes ago -
2 Votes
Adding number in Code to create new sequence
Hi, I have to create new sequence of all code (01,02,03). Code could be more. I have to add max(CodeNumber)+1 to create new sequence. The new sequence should based on ascending order by ...Answered | 3 Replies | 143 Views | Created by SmithDy - 20 hours 59 minutes ago | Last reply by --CELKO-- - 11 hours 45 minutes ago -
7 Votes
Compare the 3 columns and pick up the latest date
Date1 AND Date3 > Date2)) THEN Date3 ...Answered | 13 Replies | 14504 Views | Created by aravind T - Friday, September 7, 2012 5:27 PM | Last reply by Tom Cooper - 16 hours 51 minutes ago -
5 Votes
Rollup at datetime level
Hi there, My target is after every single day the subtotal with ROLLUP Declare @t as table(trandate datetime, itemid ...Answered | 12 Replies | 179 Views | Created by Enric Vives - Monday, October 7, 2019 7:52 AM | Last reply by Jingyang Li - 18 hours 14 minutes ago -
4 Votes
Table columns stats
Hello, Is there any code which, gives me the stats for each column in a table. I am trying to do data analysis on each column of a table,. Which tells me, ...Unanswered | 9 Replies | 395 Views | Created by Neilcse - Monday, September 23, 2019 3:18 AM | Last reply by Neilcse - 18 hours 17 minutes ago -
1 Votes
Next year Feb date update
Next Year's feb ending date is 29 and was trying to update through query but result was not correct. update #TERM set Febdate=DATEADD(dd, ...Answered | 6 Replies | 105 Views | Created by Jugnu67 - 20 hours 34 minutes ago | Last reply by Jingyang Li - 18 hours 46 minutes ago - Items 1 to 20 of 93867 Next ›
No announcements
