SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• DATEDIFF with GETWEEK worth of data

  I have such an issue. I have units, on sale date and also how many weeks the unit is on sale. Howev…

  JeremyU

  3 replies

  4 years ago

  By: Jeff Moden

• OK, I still think like a programmer -- is there a better way to do this?

  My SQL tools tell me this invokes an inefficient step with an index scan.  I am treating this as a …

  Stephen Rybacki

  8 replies

  4 years ago

  By: Jeff Moden

• Recursive Query to get get diff between two rows for same client

  Hi I have a client table the stores Client services with multiple rows for each client. StartDate, …

  Tallboy

  13 replies

  4 years ago

  By: Jeff Moden

• How to solve this

  Create 2 new database. And add one table in both database with below columns. Id, First name Last n…

  sunilkmr284

  6 replies

  4 years ago

  By: Jeff Moden

• Performance question View vs SQL query within view

  Hi: I have a view as create view vwOpsasselect * from tableAwhere type = 'S' When I run the view as…

  sqldba20

  3 replies

  4 years ago

  By: ScottPletcher

• TSQL: Create dynamic partition DataRange

  Hello All I am facing difficulties to write a query to create partition. In input I have a table wi…

  Lidou123

  15 replies

  4 years ago

  By: Jeff Moden

• Query data not tying out

  Hello all I have written to short and basic queries that should tie, but for some reason they do no…

  wheddingsjr

  5 replies

  4 years ago

  By: Johan Bijnens

• From the sys.sql_modules (linked.db.schema.vw_xxx) seperate column

  Hi All, Im working an a issue and have some thinks I would like to fix it. At moment I need the def…

  GG_BI_GG

  3 replies

  4 years ago

  By: Johan Bijnens

• Calculate number of times a number can be split evenly into pre-defined groups

  Hi there I have to write a procedure that can calculate the number of times that 1 number can be di…

  Weegee71

  4 replies

  4 years ago

  By: Phil Parkin

• Use Rows From Table as "Script to Run"

  I have a table that contains many rows, but only one column, called "Script".  It is an NVarchar da…

  RMason - eLIMBS, LLC

  5 replies

  4 years ago

  By: RMason - eLIMBS, LLC

• How do I join two temporary tables using MySQL?

  Hi all, I'm still pretty new to SQL and could use some help getting this query to work. The ultimat…

  miquiztli

  2 replies

  4 years ago

  By: Mr. Brian Gale

• Barcode Scan Into SQL Server

  We  have an Access front end with a SQL Server backend.  We have inventory that we need to scan and…

  JP789

  6 replies

  4 years ago

  By: Zidar

• Rank values based on dates (grouping)

  Hello friends, I need some help. I need to rank all titles for each week. Later on, I need to pull …

  JeremyU

  1 replies

  4 years ago

  By: pietlinden

• Replace apostrophe in user input field

  I have an Access front end with SQL backend.  The user input field is text. He inputs: don't mess u…

  JP789

  3 replies

  4 years ago

  By: JP789

• Update field based on next 5 rows

  Hi, I have table below: ID   Postcode   PostcodeNext 1       LL11 2       LL12 3       LL13 4      …

  pahulyi

  13 replies

  4 years ago

  By: homebrew01