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
Stored Procedure Takes Time at first Run daily - SQL2008
During the first run every day stored procedure takes 17 seconds to run and subsequently run it finishes in 4 seconds. Issue here is SP is run only once per day and the next day again it takes 17 ...Unanswered | 5 Replies | 64 Views | Created by Allen877 - 12 hours 41 minutes ago | Last reply by Dan Guzman - 34 minutes ago -
1 Votes
Joining multiple tables in a View
have got a query that needs to join multiple tables in a view. Currently have over 100 tables in the join - and this number could get larger. joined tables are ...Unanswered | 12 Replies | 127 Views | Created by markse - Thursday, December 07, 2017 3:36 AM | Last reply by Dan Guzman - 37 minutes ago -
0 Votes
Using values from previous rows to calculate an attempt number
1, OR(B1="Activated", B1="Error")), E1+1, E1)) Note that I am using SQL Server 2008, so I can't use the LAG or LEAD to access values from the previous ...Unanswered | 1 Replies | 44 Views | Created by danielmachen - 1 hour 51 minutes ago | Last reply by Uri Dimant - 39 minutes ago -
0 Votes
Delete Text From Field 2 If Exists In Field 1
I have a unique case where data was incorrectly input in a spreadsheet that is now in my sql server database. For example the text could be Title ...Unanswered | 1 Replies | 59 Views | Created by IndigoMontoya - 10 hours 35 minutes ago | Last reply by saravanatn1 - 3 hours 29 minutes ago -
0 Votes
cannot drop table
Hello all, I am having an issue with dropping a table. When I am trying to drop a table, it's giving me an error: " You cannot drop the table ...Unanswered | 5 Replies | 86 Views | Created by sunny.sam - 10 hours 38 minutes ago | Last reply by Uri Dimant - 5 hours 5 minutes ago -
0 Votes
Automating Records Insert To A Table
Hello, I have a PowerShell script that would look for any .sql files in a folder and runs it against a specific SQL server instance. This is working fine. Here is the ...Unanswered | 1 Replies | 43 Views | Created by vr123 - 12 hours 50 minutes ago | Last reply by Dan Guzman - 12 hours 17 minutes ago -
2 Votes
Cannot match date with getdate
select convert(date, Logdate) as 'Datum', name as 'Naam', PersonalNr as 'Personeel Nummer', cardnr as 'Pas Nummer' from dbo.lACLog where logdate = convert (date, getdate ()) ...Proposed | 30 Replies | 209 Views | Created by Phyxius7 - Friday, December 08, 2017 7:30 PM | Last reply by Russ Loski - 13 hours 52 minutes ago -
0 Votes
SQL Server 2016 performance Issue
Hi Experts, We have a 2 TB OLTP SQL Server 2016 enterprise DB in production with a very good hardware. Now some of the team members are advocating to migrate to ...Unanswered | 4 Replies | 130 Views | Created by Priya Bange - Saturday, December 09, 2017 5:49 AM | Last reply by Dan Guzman - 15 hours 23 minutes ago -
2 Votes
Is there a way to insert the output of 'RESTORE HEADERONLY' or 'RESTORE FILELISTONLY' to a table?
Dear colleagues, I automatically want to restore a database on a deployment server to a database called TestDB from a backup file. However, the database name and logical file names ...Answered | 6 Replies | 84 Views | Created by Chris Sijtsma - Thursday, December 07, 2017 12:56 PM | Last reply by Chris Sijtsma - 21 hours 52 minutes ago -
2 Votes
Identity column Auto increment not work properly
I have noted since then that many tables that have auto increment primary key bigint field increases by 1 like it should, then for some reason it jumps up by 1000 or even 10000? i have ...Proposed | 10 Replies | 115 Views | Created by DattatrayK - Friday, December 08, 2017 12:54 PM | Last reply by DattatrayK - Saturday, December 09, 2017 5:30 AM -
0 Votes
Convert nvarchar(8) to Date
Hi Everyone, I am struggling to find solution where i need to convert one column data from Nvarchar(8) to Date format. Data in the table is stored as ...Proposed | 20 Replies | 274 Views | Created by -Ankit - Thursday, November 30, 2017 6:04 PM | Last reply by SQLNeophyte - Saturday, December 09, 2017 5:02 AM -
0 Votes
Find Text Between 2 known strings
Dear All, I want to find the text between 2 known strings . So If my sentence is All applications that communicate with an instance of SQL Server do so by sending ...Unanswered | 2 Replies | 82 Views | Created by Sammy Williams - Friday, December 08, 2017 10:11 PM | Last reply by SQLNeophyte - Saturday, December 09, 2017 4:17 AM -
0 Votes
Data Archiving/Purging process
I am in process of creating data purging/archiving process. Basically I will have one table with list of table names in order to accommodate referral integrity. Table will also have some ...Unanswered | 1 Replies | 95 Views | Created by DC_010 - Friday, December 08, 2017 9:51 PM | Last reply by philfactor - Saturday, December 09, 2017 2:14 AM -
0 Votes
Can a stored procedure output a CSV file instead of a table?
The reason I need this is so I have control over the formatting of individual columns based on their content. The ultimate destination of this data is Excel, so for instance if a ...Unanswered | 1 Replies | 86 Views | Created by AllTheGoodNamesWereTaken - Friday, December 08, 2017 11:46 PM | Last reply by philfactor - Saturday, December 09, 2017 2:05 AM -
2 Votes
Create a Stored Procedure to pass in NewDateOfBirth and MemberID As Parameters which Update the age, DateofBirth columns.....
Hello Team, This is what I have: Create Procedure #USP_MyUpdate(@MemberID int, @NewDateOfBirth Date, @Age Int Output, @DateofBrith Date Output, @DateofBirthAsText ...Unanswered | 8 Replies | 266 Views | Created by cloudsInSky - Friday, December 08, 2017 4:40 AM | Last reply by Guoxiong - Friday, December 08, 2017 10:08 PM -
4 Votes
ICD-10 Code Ranges for Diagnoses
Using Microsoft SQL, I need to code the Diagnostic Categories by the Applicable ICD-10 Codes (DXCode). Notes (See the Code example and Image ...Answered | 7 Replies | 170 Views | Created by markschild - Tuesday, November 21, 2017 10:38 PM | Last reply by markschild - Friday, December 08, 2017 8:59 PM -
3 Votes
Scalar user defined function to extract first name only
Hello all, I have names such as these FullName chico, Mrs. Ashley M Readio, Mrs. Jessica Hall Johnson, ...Proposed | 19 Replies | 160 Views | Created by cloudsInSky - Thursday, December 07, 2017 5:48 AM | Last reply by cloudsInSky - Friday, December 08, 2017 8:33 PM -
0 Votes
Backward looking periods
@EndDate ) Select * from cte ORDER BY StartDate,EndDate output of above is below.. but this is not what I need.. :( StartDate ...Unanswered | 6 Replies | 122 Views | Created by SachySSRSlearner - Friday, December 08, 2017 10:49 AM | Last reply by --CELKO-- - Friday, December 08, 2017 5:44 PM -
0 Votes
How to replace a set of characters anywhere in a varchar(max) string
Hi! I have a varchar(max) string that can contain many thousands of characters. I am looking for the following text and I want to remove ...Unanswered | 3 Replies | 76 Views | Created by Zoe.Ohara - Friday, December 08, 2017 3:32 PM | Last reply by SQLNeophyte - Friday, December 08, 2017 5:24 PM -
5 Votes
query performance expectations setting to a customer
Hi All, Its a general query performance expectations setting question for a non-tech or adamant TL's/mgr's/customer. If someone comes to your desk and comes and ...Discussion | 5 Replies | 121 Views | Created by Samantha v - Thursday, December 07, 2017 6:21 PM | Last reply by Tom Phillips - Friday, December 08, 2017 2:03 PM - Items 1 to 20 of 87971 Next ›
No announcements
