No announcements
Found 243 threads
-
1 VotesMS SQL query help
I have a column that has a bunch of random comment data in it. i need to parse out some specific things that are in this field. here as an example of one of the ...Proposed | 1 Replies | 1299 Views | Created by alabama trail runner - Sunday, December 13, 2020 2:58 AM | Last reply by Hakkim.Elrhumi - Sunday, December 13, 2020 6:41 AM
-
0 Votes
Postgresql as linked server in SQL Server using MSDASQL ole db provider
Postgresql server can be added as linked server Microsoft Sql Server . Connection status is success. Query 1: select * from openquery(XYZ,'select ...Proposed | 1 Replies | 1345 Views | Created by Rajump - Thursday, December 10, 2020 12:43 PM | Last reply by S Nadendla - Thursday, December 10, 2020 4:39 PM -
0 Votes
Updating ID's in a result set
I have a table and I want to update a value based on matching ID's Example: I have this table: ID ReplyID NewID ...Proposed | 1 Replies | 1419 Views | Created by Seidel1 - Thursday, November 26, 2020 10:05 PM | Last reply by Mike Bowen MSFT - Friday, November 27, 2020 1:03 AM -
1 Votes
SSRS Parameters loading very slow
Hi, I am creating SSRS reports and when I click the preview tab, I have to wait about 4/5 minutes before all my parameters load (Total of 6 parameters). The parameters are using from the ...Proposed | 1 Replies | 1562 Views | Created by Izzy188 - Wednesday, November 25, 2020 4:34 PM | Last reply by Mike Bowen MSFT - Wednesday, November 25, 2020 8:29 PM -
1 Votes
Importing a CSV date column of yyyy-mm-dd hh:MM:ss:xxx
I know I've posted this to the wrong forum, but the dropdown for Forum category/ Forum doesn't show SQL Server or anything that appears close to it to me. My guess is that this forum isn't ...Proposed | 3 Replies | 2411 Views | Created by RobertLadd26 - Tuesday, November 24, 2020 4:56 AM | Last reply by Mike Bowen MSFT - Tuesday, November 24, 2020 4:27 PM -
0 Votes
unable to connect to azure sql server in ADF linked service
Cannot connect to SQL Database: 'abc', Database: 'def', User: 'xyz'. Check the linked service configuration is correct, ...Proposed | 1 Replies | 1750 Views | Created by Manish Raj Bhatia - Tuesday, November 24, 2020 7:44 AM | Last reply by Mike Bowen MSFT - Tuesday, November 24, 2020 4:26 PM -
1 Votes
After re-starting SQL server, SQL Server Agent is not invoking a job at scheduled time. Kindly please help
I have SQL Server agent job that runs every night at 21:00 and it was working well for years. The job executes stored procedures step by step to create tables first by dropping existing tables and ...Proposed | 1 Replies | 1197 Views | Created by Solomon2018 - Monday, November 23, 2020 1:56 PM | Last reply by Mike Bowen MSFT - Monday, November 23, 2020 5:07 PM -
0 Votes
Linked Server to Oracle
i am trying to write one trigger on sql server table which will insert a record on oracle table . it was working fine but all of a sudden i am getting a error message as "The Operation could not ...Proposed | 1 Replies | 1699 Views | Created by Arif_dxb - Sunday, November 22, 2020 5:29 PM | Last reply by Jeff McCashland - Sunday, November 22, 2020 8:14 PM -
1 Votes
MDX measures calculated by its date value
now(),[measures].[a], [measures].[b] Thank you in advance for your tips. T.Proposed | 1 Replies | 1340 Views | Created by Trdelko - Friday, November 20, 2020 8:29 AM | Last reply by Jeff McCashland - Friday, November 20, 2020 2:18 PM -
1 Votes
SQL Server data structure
What are the best practices or recommendations before creating either a new table in an existing database or an entirely new database depending on the data structure? I am ...Proposed | 2 Replies | 1561 Views | Created by SQLServerlover21 - Thursday, November 19, 2020 8:33 PM | Last reply by Jeff McCashland - Thursday, November 19, 2020 8:48 PM -
0 Votes
IMPORTANT: Open Specification Forums Moving to Microsoft Q&A
IMPORTANT NOTICE: This forum is moving to Microsoft Q&A at the following ... -
0 Votes
How to Convert a date column to a new column with DDMMYYYY format
Hi, How can I write a query to convert a date column with a m/dd/yyyy 0:06:46 format to a new column with DDMMYYYY format ? ThanksProposed | 1 Replies | 1320 Views | Created by Dripet84 - Wednesday, November 18, 2020 9:14 AM | Last reply by Jeff McCashland - Wednesday, November 18, 2020 2:03 PM -
1 Votes
SSRS report displaying NaN output for 0 values
I used below expression for percentage calculation and for 0 output, NaN is displayed. Please ...Proposed | 1 Replies | 1376 Views | Created by vsriv - Wednesday, November 18, 2020 4:25 AM | Last reply by Jeff McCashland - Wednesday, November 18, 2020 4:57 AM -
0 Votes
How to replicate a measure used in SAP BO to DAX
Hi Sorry if this a wrong forum. I am trying to replicate one of the measures created in SAP BO to tabular model using DAX. Below is the existing measure ...Proposed | 6 Replies | 1569 Views | Created by DAXLearner11 - Monday, November 16, 2020 5:24 PM | Last reply by DAXLearner11 - Tuesday, November 17, 2020 2:45 PM -
0 Votes
BCP unable to export view where table function is used?
I hope this is in the right place. I seem unable to see the old T-SQL MSDN forum in the lists above. I seem to have hit a limitation of BCP in SQL Server 2017. A ...Proposed | 3 Replies | 2153 Views | Created by JCEH - Wednesday, November 4, 2020 12:04 PM | Last reply by Jeff McCashland - Monday, November 16, 2020 8:24 PM -
0 Votes
SSRS is so slow
Hi. Forgive me if this is the wrong forum. There doesn't seem to be a dedicated SQL forum anymore. I'm migrating reports from an SSRS implementation ...Proposed | 1 Replies | 1559 Views | Created by Reagan J - Monday, November 16, 2020 3:31 PM | Last reply by Jeff McCashland - Monday, November 16, 2020 6:33 PM -
1 Votes
Same Table different Rows, Match values with these 2 columns when not Null .
A pretty urgent request came into me and now my brain feels like putty trying to pull this off. can someone point me in the right direction so i can unpack how to do ...Proposed | 2 Replies | 1331 Views | Created by Mr. Adam - Thursday, November 12, 2020 6:06 PM | Last reply by Mr. Adam - Friday, November 13, 2020 4:09 PM -
0 Votes
Split one String into Multiple Columns
Hi Developers hope all is well i just want to understand something i have one column that has a string ...Proposed | 1 Replies | 1526 Views | Created by Ronald Van Der Westhuizen - Thursday, November 12, 2020 8:13 AM | Last reply by HungChun Yu-Microsoft Protocol Open Specifications - Thursday, November 12, 2020 3:48 PM -
0 Votes
Avoid multiple start date for given product
Hi All, I have a requirement to load data into target table, before load data to target table for any product giving new startdate with out expiring old one, those records we need ...Proposed | 1 Replies | 1520 Views | Created by praveenci - Wednesday, November 11, 2020 1:42 PM | Last reply by HungChun Yu-Microsoft Protocol Open Specifications - Wednesday, November 11, 2020 3:43 PM -
0 Votes
SSRS 2019 Change Subscription
Hi All, we will updgrading to SSRS 2019 from 2008R2 with a new security model. I ahve a task of either setting all subsvriptions to use the "files share ...Proposed | 1 Replies | 1508 Views | Created by Colin101 - Tuesday, November 10, 2020 8:53 AM | Last reply by HungChun Yu-Microsoft Protocol Open Specifications - Tuesday, November 10, 2020 3:21 PM - Items 1 to 20 of 243 Next ›
No announcements
