SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• 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, 12 months 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

  4 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

  4 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

  4 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

  4 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

  4 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

  4 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

  4 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

  4 years ago

  By: EdVassie

• Select * (Sql query)

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

  fri

  1 replies

  4 years ago

  By: fri

• Query Table without index

  I am needing to pull data from a database that I did not create or own admin of. The table is not I…

  brian.cook

  14 replies

  4 years ago

  By: brian.cook

• Cannot set a value when initializing a variable

  The strangest thing happened. I want to make a change in a stored procedure that I have used for ag…

  Ellen Heijmans

  5 replies

  4 years ago

  By: Ellen Heijmans

• correct placement of comment block

  Many examples on the web, eg. sqlauthority show comment block before the CREATE AS https://www.mssq…

  polkadot

  6 replies

  4 years ago

  By: ScottPletcher

• Combine or join 3 tables, 1 for each databases

  Hello guys, I hope you're all great and healthy I would love to learn (and understand) how can I jo…

  pedroccamara

  4 replies

  4 years ago

  By: pedroccamara

• Customers and Orders table analysis by dates. please

  Good Morning, I have the two tables customers (joined) and their orders (dateoforder- record perday…

  asita

  1 replies

  4 years ago

  By: asita