SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Conventions when writing queries/stored procedures

  At my last place of work the DBA used a code "beautifier" to format his SQL and he insisted that th…

  edwardwill

  20 replies

  1 year, 9 months ago

  By: jcelko212 32090

• Local firewall issue when connecting to SQL Server

  A client has moved to SQL Server 2019 on Windows Server 2022. Earlier they had SQL Server 2012 on W…

  plmehta

  11 replies

  1 year, 9 months ago

  By: Jo Pattyn

• How to get number of unique months from table

  Hi guys, I want some help with a code to count the number of unique months that appears in list (us…

  pelusch

  4 replies

  1 year, 9 months ago

  By: kaj

• what are the best books to become a SQL developer?

  what are the best books to become a SQL developer?

  vpmaciel

  2 replies

  1 year, 9 months ago

  By: andreas.kreuzberg

• Read data based on date-range in huge table is slow

  I've got a table here with more than 60 million rows and I want to extract data based on date (WHER…

  oRBIT

  22 replies

  1 year, 9 months ago

  By: Jeff Moden

• Distance between multiple locations

  What would be the best approach when establishing the distance between points. By that I mean I hav…

  brian.cook

  6 replies

  1 year, 10 months ago

  By: brian.cook

• SQL Converting Columns to Rows based on specific column value

  Hallo, I have a problem to fill a new column from a previous column where the values are calculate.…

  Hassin

  4 replies

  1 year, 10 months ago

  By: Davecat1990

• Customers - Multiple Appointments - At specific subset of Appoint Types (T-SQL)

  Hi, I am dealing with a Fact Table which has multiple row entries for each customer in respect of t…

  Reh23

  5 replies

  1 year, 10 months ago

  By: pietlinden

• Incorrect syntax near the keyword 'on'.

  I keep hitting road blocks on this, I'm pretty new so I feel like this could be a really obvious on…

  amber0517

  5 replies

  1 year, 10 months ago

  By: Michael L John

• Can I set timeout for a query?

  Is there a way to "timeout" a query? Assume I'm coding a long sql-query. A part of the query, I don…

  oRBIT

  3 replies

  1 year, 10 months ago

  By: Jeff Moden

• Reporting periods

  trying to find the best way to automate a report only the current reporting period. Each are 8  mo…

  boehnc

  1 replies

  1 year, 10 months ago

  By: pietlinden

• Joining two columns of foreign key with one column of another table

  Hi,   I have two columns in table1 i.e. hotel1 and hotel1 . Both of them have foreign key of s…

  codeexplorer1

  6 replies

  1 year, 10 months ago

  By: Grant Fritchey

• Number rows from a value in one column

  Hi! I want to number rows from a value in one column (apar_id). Table Apar_id    Amount 10    …

  LillaMy987

  2 replies

  1 year, 10 months ago

  By: LillaMy987

• Is there another way to solve this "group in 5 day spans" problem?

  I ran into an interesting problem over on StackOverflow at the following link... https://stackoverf…

  Jeff Moden

  35 replies

  1 year, 10 months ago

  By: frederico_fonseca

• Trigger for automatically date

  Hello everyone, I created a trigger that inserts the automatic time in the Date column as soon as a…

  deny47

  1 replies

  1 year, 11 months ago

  By: frederico_fonseca