Topics
Started by
Posts
Last post
Hi SQL Team, May I know how to get the 'ABC123_Clm R' string from the following string in SQL Serve…
2 replies
In the following table, I want to replace the zero in the column idPointsrv by the next row…
6 replies
I administer a database for a local chapter of a national group. The National group does not prov…
3 replies
I have a cte that in short states SELECT mm.id1 mm.date ,mm.Datecompleted ,mn.number FROM table1…
1 replies
I have a T-SQL script which encrypts the SSN using the ENCRYPTBYPASSPHRASE function with a pass phr…
2 replies
Hello everyone, I have a question. I have a code where I use IF exists to compare items that exist …
10 replies
I have a memory optimized table with identity column. The primary key is a combination of a project…
12 replies
Hi, i've an ERP program that i can't change anything in query that comes to the SQL Server. i've SQ…
5 replies
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
Viewing 15 topics - 541 through 555 (of 1,791 total)
You must be logged in to create new topics.