No announcements
-
2 VotesDo you be announced as the next Transact-SQL Guru? Read about TechNet November 2018 competition!!
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 ...Sticky | 1 Replies | 252 Views | Created by George Chrysovaladis Grammatikos - Saturday, November 3, 2018 3:37 PM | Last reply by pituach - Saturday, November 3, 2018 3:53 PM
-
0 Votes
Registration to Microsoft TechNet Wiki competition for October 2018 is Opened! You can be the next Transact-SQL Guru
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
Tables with 500+ Columns - specifying column name helps to reduce IO?
I have Tables with 500+ columns (Row count is ~1 Million), when running Select with join on these tables, what are things to keep in mind? Also, Query 2 below helps to reduce IO / ...Unanswered | 8 Replies | 69 Views | Created by Raghavendra Narayana - 7 hours 43 minutes ago | Last reply by Guoxiong - 12 minutes ago -
0 Votes
Temporal table or system versionning table
I am trying to turn system_version off on a table that is referenced by view. Since I don't want to drop and recreate view or the object that referencing the table. is there a way around ...Unanswered | 5 Replies | 49 Views | Created by Malcolm Z - 17 hours 47 minutes ago | Last reply by Guoxiong - 19 minutes ago -
0 Votes
SQL: Why do we have null in unique?
Dear All, What is the reason behind having NULL in unique key constraint? Thank You JulieUnanswered | 4 Replies | 23 Views | Created by Julie Elizebeth Sam - 58 minutes ago | Last reply by scott_morris-ga - 23 minutes ago -
1 Votes
Multiple columns in one row
I would like to query this table by value and Type and get the contact id. The filters that I need are Type: Company, Name, Title. The query needs to filter like 'WHERE (Type = ...Answered | 1 Replies | 23 Views | Created by Lio1972 - 1 hour 3 minutes ago | Last reply by Stefan Hoffmann - 30 minutes ago -
0 Votes
Case selection
Hi Experts, I have a table in which the data retrieval is conditional. Condition per Order 1. Retrieve all records with Order_Type in ...Unanswered | 8 Replies | 82 Views | Created by Priya Bange - 5 hours 36 minutes ago | Last reply by Stefan Hoffmann - 1 hour 23 minutes ago -
0 Votes
Update waits till another transaction completion
When the stored procedure "PRC1" is being called from our Java App, it begins one Transaction.Inside the stored procedure Insert/Update happens on T1, T2, T3, ...Unanswered | 5 Replies | 53 Views | Created by Pradipta K - 6 hours 41 minutes ago | Last reply by Erland Sommarskog - 1 hour 42 minutes ago -
0 Votes
Help required in pivoting
Hi Experts, I have getting a output from a query as given below and dumped into a temp ...Answered | 3 Replies | 32 Views | Created by Naveen JV - 3 hours 35 minutes ago | Last reply by Naveen JV - 3 hours 16 minutes ago -
0 Votes
Partitioning
USE [DB_PRD] GO CREATE PARTITION SCHEME [ps_byYearMonth] AS PARTITION [pf_byYearMounth2] TO ...Proposed | 3 Replies | 69 Views | Created by lumiga - Tuesday, November 13, 2018 1:57 PM | Last reply by lumiga - 3 hours 31 minutes ago -
2 Votes
manipulation with if else statement in sql
p1=2 p2=3 How can i set the condition that case when difference between p1 and p2 more than twice, then return ...Unanswered | 4 Replies | 54 Views | Created by merzavazeh - 4 hours 18 minutes ago | Last reply by Sarat (SS) - 3 hours 37 minutes ago -
1 Votes
modification not working
HI experts, I have got a view that I need to modify as it has a duplicated and unnecessary join, I am a little hesitant to post it here becasue of the ...Unanswered | 21 Replies | 202 Views | Created by joining two set of sql - Monday, November 12, 2018 2:16 PM | Last reply by Will_Kong - 5 hours 39 minutes ago -
0 Votes
Order by EffectiveDate column value changing while Insert into statement in SQL
Hi, I have 2 records in the table and effectiveDate column having values like '1900-01-01' and 1900-01-01' and another column having value as 'Yes' and 'No' While ...Proposed | 3 Replies | 147 Views | Created by Sweet_19 - Sunday, November 4, 2018 9:09 PM | Last reply by Rachel_Wang - 6 hours 52 minutes ago -
0 Votes
SQL Server User Domain Change
Hi, There is domain change for all user. For example domain1/user_abc will change to domain2/user_abc. I am planning to migrate by create fresh new account with ...Unanswered | 4 Replies | 73 Views | Created by DeepakTyagi28 - 12 hours 55 minutes ago | Last reply by Will_Kong - 7 hours 6 minutes ago -
0 Votes
Find the minimum amount that is greater than the average
Any help is appreciated on the query below; What I want to find is the minimum amount that is greater than the average. ...Unanswered | 4 Replies | 73 Views | Created by SQLStudent2 - 16 hours 18 minutes ago | Last reply by Visakh16 - 7 hours 27 minutes ago -
0 Votes
SQL Agent job history
I have an SQL job which has two steps. The second step on failure will trigger the first step. So if second step fails,the job will be executing continously. Is there a way to monitor the such ...Unanswered | 6 Replies | 342 Views | Created by ACDBA - Friday, November 9, 2018 5:10 AM | Last reply by Will_Kong - 7 hours 32 minutes ago -
0 Votes
can the t-sql merge statement accomplish this algorithm?
Hi we run 2016 enterprise. I'm trying to understand the merge statement in t-sql but don't yet see if this can be achieved in one merge statement without saving intermediate results and then doing ...Answered | 18 Replies | 384 Views | Created by db042190 - Monday, November 5, 2018 7:08 PM | Last reply by Ashin_c - 7 hours 59 minutes ago -
0 Votes
Export query to CSV/TXT without external tools?
Is it possible to export a query result to file but without external tools like bcp? Something like select into outfile in MySQL.Proposed | 4 Replies | 68 Views | Created by adammo666 - Tuesday, November 13, 2018 12:58 PM | Last reply by Rachel_Wang - 11 hours 7 minutes ago -
0 Votes
How to Pick Column names from table
I have tables which have columns and tables Name EmpId Empname DeptID DeptName Employee Department I have ...Unanswered | 7 Replies | 88 Views | Created by mohan1111 - 22 hours 0 minutes ago | Last reply by Rachel_Wang - 12 hours 3 minutes ago -
1 Votes
Query to list the row where a colum is "YES"
Hello, I have a query: Declare @Collection nvarchar(8) Set @Collection = 'UCP004FB' SELECT DISTINCT r.ResourceID, ...Answered | 2 Replies | 62 Views | Created by Felyjos - 15 hours 15 minutes ago | Last reply by Felyjos - 12 hours 29 minutes ago -
0 Votes
Fetch Data from multiple database
I am trying to get database from multiple databases using Union ALL. Requirement is need to fetch the list of user whose password is ABC Select * from ...Proposed | 3 Replies | 95 Views | Created by pkjse - 18 hours 47 minutes ago | Last reply by SwePeso - 17 hours 28 minutes ago -
4 Votes
Data smear from oldest date to current date (SQL Server 2008)
I'm trying to fill in data gaps from the oldest date to current date. CREATE TABLE #TABLE ( DATECOL DATETIME, WEIGHTS ...Answered | 9 Replies | 138 Views | Created by FinnBluff - Monday, November 12, 2018 8:31 PM | Last reply by FinnBluff - 18 hours 17 minutes ago - Items 1 to 20 of 91255 Next ›
No announcements
