Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Development |
Remove certain unknown amounts of character from a string - All, I have a field, SourceID, that looks like the folloing V0008048 V0011675 V0000145 In each instance I need to remove the V and all of the zeros, so I should return the following: 8048 11675 145 Ive tried a replace, trims and nothing will work. Is this possible? Thank you! |
Split string - I have a table where values into field is like this way There are multiple rows now we need to find distinct value from all this row and create a lookup table Here are 3 rows from this tables 1 ["Acct Vert - Chemical","Acct Vert - Energy","Acct Vert - Seaport","Prod Vert - Access […] |
SQL Server 2016 - Administration |
Non Clustered Index - Quick question If I create Non Clustered index on a table will that help if there is no Clustered Index on a table? If yes how, I was in the impression to work Non clustered Index table should have clustered index or it will show Heap on the table |
SQL Server 2016 - Development and T-SQL |
How to get ID from XML file? - Hi all, So I have some XML files which contains person's name and addresses in their respective nodes. Sample of XML file code is below: P965 John KyleTokyoJapan</Individuals/> Now what I am trying to do is I am fetching all the data from Individual […] |
SQL Server 2019 - Administration |
SQL Change null values for integer column - Hi All, In MSSQL How can I handle null values for integer column. Do I need to update null to zero maybe? I am doing BCP out from MSSQL to MYSQL. The text file is having null-empty values and MYSQL load is errors out with Incorrect integer value. |
SQL Server 2019 - Development |
SSMS csv export file is missing leading zeroes for Numeric data types - Hi, I am working to move data from SQL Server to BigQuery. I tried exporting the .csv data out via SSMS (Tasks + Export Data), but noticed that all the columns that have numeric data types have leading zeroes missing (.0000053653 instead of 0.0000053653). This is causing issues when I try to import into BigQuery. […] |
How can i get the more accurate and optimzed grouped data ? - Hi , I need to get the correction and a way to group it in a better and efficient way. What I want is that I need to group the data on the bases of RenterUserId or MainDriverUserId in following cases /scenarios 1). Take the count of ba.Id (BookingAgreements) When RentalAgreementId is not equal to null or […] |
SQL Syntax for BETWEEN any dates and specific time - hi all i want to ask how to select from any dates and spesific time id date 1 2022-01-01 00:00:00 2 2022-01-02 05:00:00 3 2022-01-03 09:00:00 i want to select from 00:00:00 - 06:00:00 how to […] |
Refinement of my query in a best way with optimum results (for large data) - How can I refine my query in a best way with optimum results (for large database tables) ? I tried to optimize the query with same results. please see my query. I used two inner join by using the same derived tables which is fine. Our client is now experiencing the slow performance issues by […] |
T-SQL (SS2K8) |
Analyzing a huge ( more than 10600 lines )stoc proc using cte - Hello commuty, Need your help, your support and proposition! I'm analysis a huge stoc proc in sql server including a list of cte , but it's very complicated to understand the differents dependencies, Are there any tools or code that help to display a list of tables used in each cte ! Or to show […] |
SQL Azure - Development |
Azure AD Integrated Security on a Mac Connecting to Azure SQL database - Hopefully the great minds here can help, to give some back ground to the situation we have Azure SQL databases created which we are trying to ensure that all access to the DB is via Azure Active Directory authenticated users, we don't want SQL Auth users as you probably know people will share the user […] |
New to Azure - which IDE tools? - I've been working as a developer within SQL Server for over 15 years now (DWH and transactional) and think it's time I added SQL Azure to my toolbelt. I've created an account, server and database etc in Azure. Which tools are commonly used in organisations for doing the actual development? I've got Azure Data Studio […] |
Azure Data Factory |
How to copy ADF pipeline from one subscription to another and change the config - Hello, I have a pipeline which is a chain of several sprocs, activities etc... My ADF uses user assigned managed identity of the relevant subscription, let's call it ArchiveUser that accesses several Azure sql servers and azure blob storages. Pipeline in Dev Dev subscription ArchiveUser set up in dev subscription Azure sql servers in dev […] |
Powershell |
SOAP request - I'm trying to test a SOAP request from powershell, but getting an error. I goggled error but solutions don't seem to be working... any suggestions to fix? Error: Reading and converting file to XmlDocument: c:\miscjunk\soap-W.txt Sending SOAP Request To Server: http://www.webservicex.net/globalweather.asmx?WSDL Initiating Send. Send Complete, Waiting For Response. Exception calling "GetResponse" with "0" argument(s): "The […] |
Strategies and Ideas |
Questions about Fact Table structure - Hi Everyone, I created a data warehouse allowing to analyze data from the commodity trading business. I have multiple fact tables which are refreshed every night and for some customers up to 3 times per day. In all the fact tables, I have some measures and dimension keys and always a specific column called "ValuationDatecode" […] |