SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• percentage of total trips broken down by month

  Hi All, I have a massive data set which breaks down how many trips were taken on which days of whic…

  lin123

  11 replies

  3 years ago

  By: Jeff Moden

• Reconcile employees with multiple IDs into Unique IDs

  Hi, I have a scenario where my employee table has multiple IDs. The background to this scenario is …

  masterelaichi

  11 replies

  3 years ago

  By: masterelaichi

• Can someone tell me why this select statement does not pull the correct data?

  Data consists of fcinvoice, finvdate, fcstatus 0000071053, 2016-05-02 00:00:00.000, F 0000071894, 2…

  bswhipp

  1 replies

  3 years ago

  By: Phil Parkin

• Self join the table itself

    Hello I have such a situation I have a table, I called it 'table' that I most likely need to…

  JeremyU

  2 replies

  3 years ago

  By: Phil Parkin

• SSMS access and code formatting

  Hi Everyone, I am new to T-SQL and I need to write some basic code on a dev server. What is the bes…

  oneteabag

  19 replies

  3 years ago

  By: oneteabag

• How to pass a variable in a folder path using TSQL

  Hello, I need help to rename a folder name from 20220822, which is the current date to anything, "n…

  josetur12

  9 replies

  3 years ago

  By: Jeff Moden

• how to remove 18 milion bookid from table without using delete ?are there are an

  i work on sql server 2019 i have two tables table books and booksdetails i need to delete all data …

  ahmed_elbarbary.2010

  4 replies

  3 years ago

  By: ratbak

• How to get records for the first 15 days of the month

  How to get records for the first 15 days of the month. please suggest WHERE OrderDate<=DATEADD(d…

  Smash125

  7 replies

  3 years ago

  By: Jeff Moden

• Query first of month with results and query current date and compare

  Is there a way to query the first of month from a table and return that data, and also query curren…

  brian.cook

  3 replies

  3 years ago

  By: brian.cook

• Calculated column vs. Running Total column

  I'm in discussion with my development team regarding the best way to model staff members taking ann…

  edwardwill

  4 replies

  3 years ago

  By: MarkP

• How to make pivot for features dynamically based on feature name and feature val

          sssss I work on sql server 2019 i can't make pivot for feature values b…

  ahmed_elbarbary.2010

  1 replies

  3 years ago

  By: DesNorton

• Flow Control Problem with multiple statements

  I am creating a function that should retrieve a numerical value from notes. This can be represented…

  Paul Stasny

  4 replies

  3 years ago

  By: Jeff Moden

• Select statement results

  Hi, I am trying to get result when only C drive is less than 10% and other drives less than 20% but…

  Saran

  2 replies

  3 years ago

  By: Saran

• SELECT * FROM ( ... ) X

  Hi all! I'm trying to understand how does this work. I've read a thread here about the X thing but …

  FatsGordon

  9 replies

  3 years ago

  By: EdVassie

• Select * (Sql query)

  thank you This topic was modified 3 years ago by fri. This topic was modified 3 years…

  fri

  1 replies

  3 years ago

  By: fri