No announcements
-
0 VotesRegistration 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
Getting the AD Group name from a current Login
Windows Integrated Security CurrentUser (or, I am BillGates): ms.com\BillGates ..... belongs to several groups. Somehow I can login to the server which has some ...Proposed | 8 Replies | 89 Views | Created by Cornelia Gibbs - Wednesday, October 17, 2018 8:11 PM | Last reply by Cornelia Gibbs - 1 hour 52 minutes ago -
0 Votes
IF NOT EXISTS and CREATE SCHEMA
I have noticed the problem with CREATE SCHEMA inside IF for example: IF NOT EXISTS (SELECT 1 FROM sys.schemas WHERE name='app') create SCHEMA ...Unanswered | 5 Replies | 51 Views | Created by Zbigniew Szmigiero - 11 hours 30 minutes ago | Last reply by Erland Sommarskog - 3 hours 5 minutes ago -
0 Votes
Linked Server error
Msg 117, Level 15, State 1, Line 2 The object name 'LinkedServer.database1.dbo.tmpabc' contains more than the maximum number of prefixes. The maximum is 2. This ...Answered | 4 Replies | 40 Views | Created by VijayKSQL - 7 hours 3 minutes ago | Last reply by Erland Sommarskog - 3 hours 10 minutes ago -
0 Votes
Restore all Databases in a Directory using Tibor Karaszi Scripts got error need help
I'm trying to automate Database Restores that will refresh Development servers from Production using Karazi Script blow however I;m getting the following ...Unanswered | 1 Replies | 36 Views | Created by Test.State - 5 hours 23 minutes ago | Last reply by Erland Sommarskog - 3 hours 11 minutes ago -
0 Votes
T-SQL Help
Hello all, I have 2 tables create table daily_tbl (prop_num int , report_dt ...Unanswered | 1 Replies | 42 Views | Created by Srik Kotte - 5 hours 14 minutes ago | Last reply by Tom Cooper - 3 hours 15 minutes ago -
1 Votes
The PERCENTILE_CONT function is not allowed in the current compatibility mode.
PERCENTILE_CONT has always worked for me in the past. Our SERVER was just upgraded to 2014. I made sure that the database I am using is set to 110. I am looking for an explanation as to why I am ...Answered | 4 Replies | 2854 Views | Created by WFarber - Tuesday, June 9, 2015 1:34 PM | Last reply by killer1923 - 3 hours 16 minutes ago -
0 Votes
Why isn't SQL Server using my index?
Hello, I have a table that contains called T1 that contains 62965 rows this table have an non clustered in a column called email and another table called T2 that ...Unanswered | 2 Replies | 47 Views | Created by YassirCool - 6 hours 13 minutes ago | Last reply by YassirCool - 5 hours 16 minutes ago -
0 Votes
MS Sql server management studio 17
Hello everyone, I am trying to load a table from excel using the SQL server import and export wizard....I am getting the following error..Can someone please help ...Unanswered | 2 Replies | 32 Views | Created by Hellothere8028 - 7 hours 9 minutes ago | Last reply by Velmurugan.Sundaramoorthy - 5 hours 42 minutes ago -
1 Votes
Count by Title on specific columns
Date ID intent 9/1/2018 1 ...Answered | 9 Replies | 187 Views | Created by Hellothere8028 - Monday, October 15, 2018 9:42 PM | Last reply by Hellothere8028 - 7 hours 12 minutes ago -
1 Votes
Looping through MERGE statement in for SCD Type-2
Hello Experts, I would like to generate a dynamic SQL script for a MERGE statement in SQL Server 2016. Below are some DDL/DML for your reference as an example. If you see, the ...Answered | 15 Replies | 143 Views | Created by Bangaaram - Wednesday, October 17, 2018 2:37 AM | Last reply by Visakh16 - 7 hours 13 minutes ago -
0 Votes
T-SQL optimisation
Hi everyone, I have this query that was code by the previous guy here. IF( EXISTS(SELECT * FROM ...Answered | 4 Replies | 50 Views | Created by LETL - 10 hours 54 minutes ago | Last reply by Guoxiong - 10 hours 12 minutes ago -
0 Votes
Looping through Information Schema Objects
Hello Experts, I am trying to do some table mapping/data analysis and as part of it I am trying to identify the source to target. As an example, my source would be a view ...Proposed | 23 Replies | 414 Views | Created by Bangaaram - Friday, October 12, 2018 2:33 PM | Last reply by Bangaaram - 10 hours 48 minutes ago -
0 Votes
Memory optimized tables, floating point exeption
Our application is experiencing off and on errors(3628) that have this message The Database Engine received a floating point exception from the operating system ...Unanswered | 3 Replies | 106 Views | Created by rdavis - Tuesday, October 16, 2018 6:04 PM | Last reply by rdavis - 10 hours 59 minutes ago -
0 Votes
Matching performance offered by INSERT INTO ... SELECT vs SELECT ... INTO - SQL Server 2014-2016
Hi, I'd like to understand better the performance offered by INSERT INTO … SELECT vs SELECT … INTO when a large data set must be written into regular tables (no ...Unanswered | 7 Replies | 62 Views | Created by pscorca - 17 hours 1 minutes ago | Last reply by Uri Dimant - 12 hours 29 minutes ago -
1 Votes
exactly picking a string using Substring or any other function
I have been struck while writing a query to pick a string . What I'm posting the query is sample dat Declare @tbl table (tblname varchar(20),Query ...Unanswered | 5 Replies | 110 Views | Created by mohan1111 - Wednesday, October 17, 2018 2:02 PM | Last reply by mohan1111 - 13 hours 52 minutes ago -
2 Votes
Data Hiding
I know we have options of data masking and en cryption in sql server CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Sonest1'; CREATE CERTIFICATE ...Unanswered | 4 Replies | 88 Views | Created by Neilcse - Wednesday, October 17, 2018 1:10 AM | Last reply by Will_Kong - 16 hours 43 minutes ago -
4 Votes
select data in range by group in sql
SELECT TOP 1000 WITH TIES code item data sales action from tab1 how ...Answered | 8 Replies | 101 Views | Created by merzavazeh - Wednesday, October 17, 2018 11:00 AM | Last reply by Halo Chug - 17 hours 46 minutes ago -
0 Votes
xml select query with repeating one element in all child elements
Hi, my temp table at any time can have only one type of data (either withdrawal or transfer) For ...Unanswered | 2 Replies | 45 Views | Created by Spunny - 19 hours 53 minutes ago | Last reply by Will_Kong - 18 hours 23 minutes ago -
0 Votes
Query rewrite
Am trying to optimize this code , but it doesn't work. This is a big table and the code goes for index scan on it, no matter what index I add... can please help to ...Unanswered | 5 Replies | 66 Views | Created by MU DBA - 22 hours 24 minutes ago | Last reply by SwePeso - 18 hours 50 minutes ago -
0 Votes
Need help with distinct values of a column in one row
Can someone help me with the following? I need functionality like below: with CurrentView as (select 'Jack Ryan' as Producername,'Retail' as Specialty,'1' as ...Proposed | 8 Replies | 98 Views | Created by Farhan1 - Wednesday, October 17, 2018 4:09 PM | Last reply by Visakh16 - 19 hours 29 minutes ago - Items 1 to 20 of 91046 Next ›
No announcements
