SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

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

  By: frederico_fonseca

• Best table structure for a tall table that needs to be pivoted

  Hi Everyone, I have a table with about 2 million distinct IDs and another table with about 7000 dis…

  Dolfandave

  23 replies

  1 year, 12 months ago

  By: Jonathan AC Roberts

• Struggle Bus - Varbinary(max) Performance Suggestions?

  I have a very large table I am dealing with that has a varbinary(max) column.  I have a Order By t…

  beantownace

  6 replies

  2 years ago

  By: EdVassie

• get a substring value from string

  Hi, I am new to SQL Server. I have table create table tmp1 ( serialnumber varchar(500) ) insert int…

  sonika2015

  43 replies

  2 years ago

  By: Jeff Moden

• What's the logic of the NOT IN clause?

  I thought I understood the "NOT IN" logic very well until I run into a case where the presence of N…

  Sam-263310

  21 replies

  2 years ago

  By: Jeff Moden

• Using SQL - Convert column to rows - not a straight forward pivot

  Hello All, I have below sample table. Code is also included. create table Trade_test (portfoliocode…

  abi

  3 replies

  2 years ago

  By: Jeff Moden

• FILESTREAM

  Trying to setup database with FILESTREAM. Using scripts that work great on previous versions of SQL…

  Ronzo

  1 replies

  2 years ago

  By: Ronzo

• I have to do a price increase on our parts. My question is history records.

  For each part there must be a history record of price from to price to. Is there a better way to do…

  bswhipp

  4 replies

  2 years ago

  By: Ronzo