No announcements
-
0 VotesJune 2017 TechNet Guru Competition is open! Read more on how you can win
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. This is your chance ...
-
0 Votes
POSTING 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
Passing TVPs to SQL Server from .NET
Hi everybody, My initial implementation was based on the top of this ...Unanswered | 8 Replies | 105 Views | Created by Naomi N - 17 hours 23 minutes ago | Last reply by Erland Sommarskog - 1 hour 35 minutes ago -
0 Votes
selecting non refunded records
Hello, here this is how the table looks like ...Proposed | 4 Replies | 78 Views | Created by srikanth.kasu - 16 hours 0 minutes ago | Last reply by Jingyang Li - 14 hours 10 minutes ago -
7 Votes
Passing large amount of rows as a User defined Table value Parameter to SP in Sql Azure taking long time
We need to pass around 80K rows to a SP in sql Azure. Previously we are able to do so without any glitches. But currently once we call the SP from c#, it's some times taking 10-15 minutes to start ...Answered | 24 Replies | 371 Views | Created by Rajiv1234 - Saturday, June 03, 2017 2:35 PM | Last reply by Erland Sommarskog - 14 hours 44 minutes ago -
2 Votes
What is the best way , preferred way to pass an empty data field in creating a pipe-delimited file
So our third party vendor wants all data points whether we store them in our database or not. So is the generally accepted means to do so SELECT ...Answered | 11 Replies | 518 Views | Created by ITBobbyP - Friday, September 09, 2016 6:43 PM | Last reply by ITBobbyP - 14 hours 46 minutes ago -
1 Votes
Loading directories of PDF files into SQL Server FileStream
Hello all, I have been tasked with putting a data dump from a former vendor into SQL Server 2014. This is a one off project so I'm not that concerned with grace and ...Answered | 4 Replies | 79 Views | Created by Woolvetw - Thursday, June 22, 2017 3:24 PM | Last reply by Woolvetw - 14 hours 59 minutes ago -
0 Votes
Merging multiple row records where the end date of previous record is equal to start date of next record.
Hi guys, I'm writing a script on SQL and my aim is to merge row records which have the same location name and record group (i.e. ...Unanswered | 11 Replies | 130 Views | Created by Aboord - Thursday, June 22, 2017 11:49 AM | Last reply by Jingyang Li - 17 hours 46 minutes ago -
0 Votes
find out total count for each order
Hi, how can I calculate the total items associated with each order. The table structure is like below,Answered | 4 Replies | 67 Views | Created by sdnd2000 - 21 hours 42 minutes ago | Last reply by Jingyang Li - 18 hours 16 minutes ago -
2 Votes
Problem placing a sorted table into a cursor sorted..
@lastLSN GROUP by last_lsn) OPEN backupFiles -- Loop through all the files for the database FETCH NEXT FROM backupFiles INTO ...Unanswered | 6 Replies | 57 Views | Created by Jason Spatz - 20 hours 7 minutes ago | Last reply by Jason Spatz - 18 hours 56 minutes ago -
2 Votes
Determine qualifying date across multiple nonconsecutive date ranges
Hello: I've been cramping my brain trying to think how to do this, so I came here because you all are pretty smart :) Assume the following ...Answered | 5 Replies | 94 Views | Created by KenVilla - Thursday, June 22, 2017 11:15 PM | Last reply by KenVilla - 19 hours 10 minutes ago -
0 Votes
query total count many to many relationship
Hi, I have many to many relationships like the below table structure, it is like customer and order relationship, I want to get all the total number of orders for each customer, the result ...Answered | 5 Replies | 95 Views | Created by sdnd2000 - Thursday, June 22, 2017 11:48 PM | Last reply by Shenoy P - 21 hours 9 minutes ago -
0 Votes
Strange result of Inner Join
Hello! I'm working localy in Management Studio on my SQL 2016 SP1 Server. My steps: 1) select * from ...Answered | 5 Replies | 61 Views | Created by MF47 - 23 hours 40 minutes ago | Last reply by MF47 - 21 hours 51 minutes ago -
0 Votes
invalid length in substring impossible to find
Hi we run 2012 enterprise. I have a substring that looks as follows which is bringing down a query with an "invalid length parameter passed to LEFT or Substring" exception. But ...Answered | 11 Replies | 114 Views | Created by db042190 - Thursday, June 22, 2017 3:31 PM | Last reply by db042190 - 22 hours 0 minutes ago -
0 Votes
28 Average
3HrAverage call ...Answered | 8 Replies | 84 Views | Created by Durbslaw - Friday, June 23, 2017 4:13 AM | Last reply by Erland Sommarskog - 22 hours 20 minutes ago -
0 Votes
SQL procedure is removing SET TRANSACTION ISOLATION LEVEL READ COMMITTED statement.
Hi When I add SET TRANSACTION ISOLATION LEVEL READ COMMITTED GO to procedure in sql server 2008 R2 and execute the procedure ...Proposed | 4 Replies | 73 Views | Created by knewsql - Thursday, June 22, 2017 2:25 PM | Last reply by Will_Kong - Friday, June 23, 2017 10:32 AM -
0 Votes
Retrieve data using a specific filter in Where condition
Hi, I have a table called Order and another table called Order Detail . An Order can have One or many Order Detail The DDL of the ...Unanswered | 3 Replies | 89 Views | Created by YassirCool - Thursday, June 22, 2017 9:16 PM | Last reply by Shenoy P - Friday, June 23, 2017 10:14 AM -
3 Votes
Deleting records from sysservers
Hi, I am trying to delete a records from sysservers table. use [master] delete from sysservers where srvname = 'MBSSERV'--7 For this i ...Answered | 5 Replies | 8283 Views | Created by RubSay - Thursday, November 12, 2009 12:08 PM | Last reply by AJAY KUMAR SHARMA - Friday, June 23, 2017 9:45 AM -
0 Votes
SQL Server DatabaseMail Error
Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2017-06-21T11:42:47). Exception Message: Could not connect to mail ...Unanswered | 4 Replies | 76 Views | Created by Randy MSDN - Friday, June 23, 2017 3:02 AM | Last reply by Xi Jin - Friday, June 23, 2017 8:39 AM -
0 Votes
Simple Question about nvarchar versus varchar
Re: Simple Question about nvarchar versus varchar I thought that when you use INSERT (or the WHERE clause or any other comparison operator) that you should match the ...Unanswered | 4 Replies | 146 Views | Created by TheBrenda - Thursday, June 22, 2017 2:49 PM | Last reply by Xi Jin - Friday, June 23, 2017 2:35 AM -
1 Votes
to return a negative fraction
0 BEGIN --Calculate the greatest common factor as long as both numbers are even numbers, keep reducing ...Answered | 5 Replies | 127 Views | Created by Rta88 - Tuesday, June 20, 2017 8:05 PM | Last reply by Will_Kong - Friday, June 23, 2017 1:43 AM -
0 Votes
Trying to dynamically add to dates
I am writing a stored procedure that needs to calculate a date. I need to read the datepart from a table, then use that value in a Dateadd statement to calculate a new date. The problem is that it ...Answered | 5 Replies | 195 Views | Created by GretchenF - Thursday, June 22, 2017 5:04 PM | Last reply by Erland Sommarskog - Thursday, June 22, 2017 10:17 PM - Items 1 to 20 of 86332 Next ›
No announcements
