Viewing 15 topics - 16,021 through 16,035 (of 283,963 total)
Topics
Started by
Posts
Last post
Hi all. I've got a query that pulls data from a Progressor database. I need to get the customer and…
7 replies
Hi, I haven't used the Export to XML function and wondering if anyone has used it, and can s…
8 replies
#roastme? lol...kidding... tl;dr: I wrote a proc that basically does the same thing as Redgate SQL …
1 replies
I need to flatten out JSON file and load into SQL table. Under JSON settings, I don't see option to…
2 replies
We have a primary server and seconday server both running SQL Server 2012 EE with log shipping conf…
4 replies
I am trying to understand how committed data works in a transaction. I have 4 screenshots attached…
2 replies
Hi, I am working on update trigger. Whenever the json value is changed for the latest date t…
1 replies
Hi I have the following code: in the end, the date should look like 1/4/2020, in a date format. And…
14 replies
Hi All, I tried to backup SSAS databases(2008 R2) by using query in SSMS, but it is overwriting pre…
2 replies
Comments posted to this topic are about the item Let's Fix a Password Problem "The credit belongs t…
6 replies
Disclaimer: I inherited this setup, I didn't design it Background So I have 4 SQL Server 2017 insta…
3 replies
Hello, I have only question about some interesting issues I tested yesterday some query, where was …
7 replies
Hi, declare @table varchar(500) ='person' Select 'select count(*), count(distinct('+ STRING_AGG( na…
2 replies
Hello, I need some help with SELECT statement, please. We query 3rd party table (I cannot amend its…
4 replies
Hello community! In a project I have to use the XML column datatype. It's the first time I am using…
8 replies
Viewing 15 topics - 16,021 through 16,035 (of 283,963 total)