No announcements
-
3 VotesWho will be announced as the next Transact-SQL Guru? Read more about January 2019 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. ...
-
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
Sql server 2017 Transact problems. Microsoft does not respond. Can you read?
I have found several important bugs in Sql Server 2017 Transact T-Sql in Spanish language. I think they have intentionally blocked or damaged the software to not export non-english ...Unanswered | 13 Replies | 288 Views | Created by zequion1 - Wednesday, January 16, 2019 6:01 AM | Last reply by zequion1 - 12 minutes ago -
0 Votes
OPenXML
Hello I have an XML file with the first line as below <<my:Handoff xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ...Unanswered | 4 Replies | 55 Views | Created by jonniemol - 16 hours 14 minutes ago | Last reply by Rachel_Wang - 59 minutes ago -
0 Votes
How do I filter my SQL Server Query by UTC AT TIME ZONE 'Eastern Standard Time'
= @StartDate_In AND [TableName].[ShipDateUTC] AT TIME ZONE 'UTC' AT TIME ZONE 'Eastern Standard Time'Unanswered | 2 Replies | 53 Views | Created by ITBobbyP - 8 hours 27 minutes ago | Last reply by Rachel_Wang - 4 hours 41 minutes ago -
1 Votes
drop linked server with "droplogins"
I run the query below to create a Linked Server (called 'RemoteSvr') with mapped logins. use master exec sp_addlinkedserver @server='RemoteSvr', ...Proposed | 11 Replies | 405 Views | Created by PhotoHiker - Friday, January 11, 2019 8:23 PM | Last reply by Erland Sommarskog - 8 hours 48 minutes ago -
0 Votes
Help With Inline Function Performance
We are having trouble with SQL Server inline function performance. I have a single inline function that grabs a total of 13 records. When we call the function by itself (SELECT * FROM ...Unanswered | 8 Replies | 208 Views | Created by sjblasko82 - Friday, January 18, 2019 6:44 PM | Last reply by Erland Sommarskog - 8 hours 53 minutes ago -
3 Votes
Readonly access on all databases
Hi, I'm using SQL server 2014. I currently have a user having sysadmin rights on the server and I want to update that to read-only access & view definition of ...Answered | 7 Replies | 83 Views | Created by StSingh - 20 hours 34 minutes ago | Last reply by Erland Sommarskog - 8 hours 54 minutes ago -
0 Votes
re-assign time on a date/time field from 2019-01-04 00:00:00.000 to 2019-01-04 07:15:00.000
I have events for users that I'm trying to import into a calendar but they don't have a time assigned. Each user has about 20 events each day that I want to spread out so they will display in the ...Unanswered | 2 Replies | 48 Views | Created by FLSojourner - 12 hours 34 minutes ago | Last reply by Visakh16 - 11 hours 31 minutes ago -
0 Votes
BEGIN TRANSACTION or BEGIN DISTRIBUTED TRANSACTION?
0 ROLLBACK TRANSACTION my1 IF ERROR_STATE() > 0 INSERT INTO ...Proposed | 5 Replies | 209 Views | Created by Enric Vives - Friday, January 18, 2019 1:14 PM | Last reply by Ashin_c - 21 hours 39 minutes ago -
0 Votes
TSQL using sp_send_dbmail with Friendly URL
We are trying to send a friendly URL using TSQL and sp_send_dbmail, but the URL portion is not working correctly, by sending the short description: ...Unanswered | 6 Replies | 161 Views | Created by vsdla - Thursday, January 17, 2019 12:59 AM | Last reply by Visakh16 - 22 hours 1 minutes ago -
0 Votes
Help needed for replacing duplicate numbers in a script for sql server
I have inherited a db that in some cases could have multiple duplicate numbers in a table some at least 1 duplicate and some more than 2 duplicates. For example, a table with the following ...Unanswered | 11 Replies | 331 Views | Created by mrbill65 - Wednesday, January 16, 2019 5:19 PM | Last reply by Rachel_Wang - 22 hours 6 minutes ago -
0 Votes
How to run two store procedure parallel from same pc but different session
suppose i have one store procedure which i want to execute from two different session from same PC using SSME. please guide me with sample code.Proposed | 10 Replies | 290 Views | Created by Sudip_inn - Tuesday, January 15, 2019 9:42 AM | Last reply by Will_Kong - 22 hours 24 minutes ago -
1 Votes
Filter query based on description
Table act_log have the 'description' and 'action_desc'. Where I need to get the details on the type ='ST' where only manual entry is written under the column 'description'. But ...Answered | 9 Replies | 148 Views | Created by tremo01 - Sunday, January 20, 2019 1:34 PM | Last reply by tremo01 - 22 hours 24 minutes ago -
0 Votes
Selecting one row per ID per day
Hi Team, I am trying to one row per ID per by day..When I use row_number and partition by I am losing data..Can you please help here..Following is the ...Unanswered | 6 Replies | 211 Views | Created by Hellothere8028 - Saturday, January 19, 2019 12:01 AM | Last reply by swePeso - Monday, January 21, 2019 7:02 AM -
0 Votes
Failed to initialize the OLE DB provider data source object "MSOLAP.7" for linked server "(null)".
I create query SELECT CAST(F1."[Торговые ...Unanswered | 7 Replies | 196 Views | Created by merzavazeh - Friday, January 18, 2019 11:27 AM | Last reply by Visakh16 - Monday, January 21, 2019 6:57 AM -
0 Votes
SQL sever 2012 doesn't update table after migration from EF 2.1
Hi, I create web app using ASP.Net Core 2.1 MVC. To add initial data to some tables (for ex. categories) I wrote Seed method and Add Migration and updated database successfully ...Unanswered | 2 Replies | 141 Views | Created by FaridGN - Friday, January 18, 2019 6:38 PM | Last reply by Rachel_Wang - Monday, January 21, 2019 6:56 AM -
0 Votes
after add field to query grouping is damage and show extra lines problem
= DateDiff(Day, GETDATE(), MAX(dbo.TrxInvH.TrxDate)) THEN 1 ELSE 0 END AS ActualStatictemp2, CASE WHEN DateDiff(DAY, MAX(dbo.TrxInvH.TrxDate), GETDATE()) > CASE ...Unanswered | 2 Replies | 187 Views | Created by engahmedbarbary - Monday, January 21, 2019 3:21 AM | Last reply by Will_Kong - Monday, January 21, 2019 6:12 AM -
0 Votes
How to get max trxdate for every items exist on trxinvf
Problem How to get max trxdate for every items exist on trxinvf ? I need to show last trxdate for all items have transactions on trxinf MEANING ...Unanswered | 5 Replies | 144 Views | Created by engahmedbarbary - Sunday, January 20, 2019 1:27 PM | Last reply by A2605 - Monday, January 21, 2019 3:05 AM -
0 Votes
Data Purging - Code
Looking for good Data Purging code for huge tables, including all best practices to be followed please. Searched but Not getting any good reference. Thanks and Best ...Unanswered | 2 Replies | 125 Views | Created by Raghavendra Narayana - Sunday, January 20, 2019 10:27 AM | Last reply by Rachel_Wang - Monday, January 21, 2019 3:03 AM -
0 Votes
Find the average distance between the house of one employee and other employee's houses in the column
I am working on a practice question in SQL. A sample database of employees is provided. The screenshot attached contains the details of the employees. It also includes their ...Proposed | 3 Replies | 187 Views | Created by karanhindocha8 - Saturday, January 19, 2019 11:53 AM | Last reply by Erland Sommarskog - Sunday, January 20, 2019 11:16 AM -
0 Votes
Including Sysadmins of both Windows authentication and Sql Server Authentication
Hello, I have following query. In this query, it does NOT list out the windows authentication sysadmin role members. I want to include all those users or logins who have ...Answered | 3 Replies | 197 Views | Created by vr123 - Saturday, January 19, 2019 12:04 AM | Last reply by vr123 - Saturday, January 19, 2019 9:58 PM - Items 1 to 20 of 91762 Next ›
No announcements
