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
Why is my windows taskbar always flashing
Why is my windows taskbar always flashing, since the latest update 1809 has been installed India is the best country in the world ...Unanswered | 3 Replies | 61 Views | Created by Ind_Asan - 12 hours 42 minutes ago | Last reply by Will_Kong - 3 minutes ago -
0 Votes
checking new data under using SQL scheduler
i set SQL scheduler, which performs next operation SELECT [Dt] ...Unanswered | 3 Replies | 70 Views | Created by merzavazeh - 13 hours 28 minutes ago | Last reply by Rachel_Wang - 7 minutes ago -
0 Votes
localhost sql server installation
Hello, on my laptop I have ssms. I can connect to different sql servers and see the list of them in ssms. I do not seem to have localhost installed. For example, ...Answered | 4 Replies | 115 Views | Created by arkiboys - Thursday, October 18, 2018 5:24 AM | Last reply by Abdulhakim Mohamed elrhumi - 6 hours 26 minutes ago -
0 Votes
Setting Source Connection - Error - Opening a rowset for VIEW failed. Check that the object exists in the db.
Hello, 1. I'm trying to export some data from a view in Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (x64) using SQL Server Import and Export Wizard but I get the ...Proposed | 1 Replies | 57 Views | Created by pr0t - 15 hours 47 minutes ago | Last reply by Erland Sommarskog - 14 hours 11 minutes ago -
2 Votes
incorrect medain calculation by groups
this topic concerned with ...Answered | 5 Replies | 132 Views | Created by merzavazeh - Saturday, October 20, 2018 10:02 AM | Last reply by merzavazeh - 14 hours 53 minutes ago -
0 Votes
unpivot dynamic pivot table
Hi Can you help me convert the following query to unpivot Thank you DECLARE @name ...Unanswered | 1 Replies | 57 Views | Created by MohammadBayat - 18 hours 23 minutes ago | Last reply by Visakh16 - 18 hours 13 minutes ago -
5 Votes
UnionAll
I want to remove union all and combine this select in to one stm can you help me select do.OrgCode ,do.Tn ...Unanswered | 8 Replies | 180 Views | Created by Neilcse - Friday, October 19, 2018 3:33 PM | Last reply by Neilcse - 18 hours 26 minutes ago -
0 Votes
Decrypting Always Encrypted Column
sqlpackage /p:AllowUnsafeRowLevelSecurityDataMovement=true *** Missing required argument '<Action>'. How can fix this? Basically, I need to decrypt the ...Unanswered | 2 Replies | 170 Views | Created by vr123 - Tuesday, October 9, 2018 11:06 PM | Last reply by vr123 - Saturday, October 20, 2018 9:19 PM -
3 Votes
calculate median by group with replace in sql
Say here the query SELECT [item] ,[code] ,[data] ...Answered | 15 Replies | 362 Views | Created by merzavazeh - Wednesday, October 10, 2018 2:49 PM | Last reply by --CELKO-- - Saturday, October 20, 2018 9:18 PM -
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 | 6 Replies | 197 Views | Created by YassirCool - Thursday, October 18, 2018 7:12 PM | Last reply by YassirCool - Saturday, October 20, 2018 2:26 PM -
2 Votes
Query to find First sunday of march and Second Sunday of November in SQL 2008
Hi, I want query to find Second sunday of march and First Sunday of November in SQL 2008. This query can be used for Daylight ...Answered | 5 Replies | 6354 Views | Created by LuckyAbd - Monday, February 3, 2014 2:22 PM | Last reply by SwePeso - Saturday, October 20, 2018 9:27 AM -
2 Votes
arithmetic operations by groups in sql
I try decribe very detail I have two ...Answered | 3 Replies | 130 Views | Created by merzavazeh - Friday, October 19, 2018 8:15 AM | Last reply by --CELKO-- - Saturday, October 20, 2018 1:43 AM -
0 Votes
SS 2014 Link Server: login failed for user nt authority anonymous logon linked server
Hello There, Please help me in below scenario. I have created a linked Server in QA (i gave name as Link_Dev). I have ...Unanswered | 8 Replies | 99 Views | Created by ParixitsinhChauhan - Friday, October 19, 2018 2:32 PM | Last reply by Erland Sommarskog - Friday, October 19, 2018 10:02 PM -
0 Votes
How to fill a column with values from a different column?
= 2 fjobono | fbompart | fbomdesc ...Unanswered | 4 Replies | 98 Views | Created by David9501 - Friday, October 19, 2018 2:45 PM | Last reply by Jingyang Li - Friday, October 19, 2018 7:44 PM -
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 | 26 Replies | 481 Views | Created by Bangaaram - Friday, October 12, 2018 2:33 PM | Last reply by Naomi N - Friday, October 19, 2018 7:22 PM -
0 Votes
JSON Query
SQL SERVER 2017 I am attempting to query a JSON file and get data from it. The sample file is: {"Name":"Report ...Answered | 1 Replies | 71 Views | Created by Scott_Hanebutt - Friday, October 19, 2018 4:08 PM | Last reply by Visakh16 - Friday, October 19, 2018 5:08 PM -
0 Votes
T-SQL Help
Hello all, I have 2 tables create table daily_tbl (prop_num int , report_dt ...Answered | 3 Replies | 137 Views | Created by Srik Kotte - Thursday, October 18, 2018 8:11 PM | Last reply by Srik Kotte - Friday, October 19, 2018 4:33 PM -
0 Votes
SQl Server joins
Table tblWB_JPCMS_Failuredetails had data as below When I ran below query SELECT jour_scode AS ...Unanswered | 3 Replies | 79 Views | Created by Raghunadhan - Friday, October 19, 2018 12:23 PM | Last reply by scott_morris-ga - Friday, October 19, 2018 3:15 PM -
2 Votes
BCP- Increase Number of Rows to Copy
Hi Experts , I need to understand ,how can we increase the Number of Rows that Copies while Using BCP to create CSV( to Copy data from SQL Table to CSV) . I ...Unanswered | 3 Replies | 58 Views | Created by Rihan8585 - Friday, October 19, 2018 11:10 AM | Last reply by Tom Phillips - Friday, October 19, 2018 2:22 PM -
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 | 4 Replies | 180 Views | Created by rdavis - Tuesday, October 16, 2018 6:04 PM | Last reply by Mbala_up - Friday, October 19, 2018 7:37 AM - Items 1 to 20 of 91059 Next ›
No announcements
