Topics
Started by
Posts
Last post
I am wondering if someone can provide me with some of there awesome TSQL. i dont believe this scri…
25 replies
is there a good introductory article somewhere that covers the various options for querying data ou…
9 replies
I want to pivot/transform the records as below: Currently, I create a table with ID,OrderNo,Order…
17 replies
Hello everyone, it's my first post here, and I'm no expert on SQL, so I hope you're able to help, a…
12 replies
I need to split the column 'DiagnosisCodes' into 4 new columns 'Diagnosis1', 'Diagnosis2', 'Diagnos…
15 replies
So today's date is 2/11/2022 so my results should be from 2/11/2022 and 8/11/2021. SELECT oi.Name a…
4 replies
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
Viewing 15 topics - 541 through 555 (of 1,784 total)
You must be logged in to create new topics.