Topics
Started by
Posts
Last post
So here's a thing that I've been told several times over the past few weeks and I'd like to know if…
8 replies
Hi, I have a table that stores event transactions, the sample data see the script below. The requir…
38 replies
Hi Team, I have a requirement to track any insert/update/Delete operations happened against Databas…
10 replies
Hi, I have four views on one database to which one sql authenticated user has been granted select b…
4 replies
Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_D…
5 replies
I am trying to create a natively compiled stored procedure where I need to check if a string contai…
11 replies
Definition of stored procedure create procedure [dbo].[smGetMinDate] @O_dMinDate datetime = …
5 replies
Hello Good Morning, I have three Tables, Assume Table1, Table2, Table3 these three tables get loads…
5 replies
Hi there I have a problem with a dynamicSQL Statement. In this code, I have some data come in JSON …
3 replies
we use two SQL instances on one server - both SQL Server 2017 and SQL Server 2019. I can turn-off S…
1 replies
I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX) column. However, it i…
5 replies
By: Jeff Moden
Hi there I have a script which processes and aggregates data. Now this is procesing data from a sou…
2 replies
Hello smart people, I am trying to use the POWER function to return data to pass downstream in an E…
17 replies
Hello everyone I hope everyone's ok. I have this query and I'm trying to build a case statement li…
17 replies
I have seen the articles on this website that talk about connecting Exchange to SQL server for the …
1 replies
Viewing 15 topics - 1 through 15 (of 1,258 total)
You must be logged in to create new topics.