SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• sum of sales 2 dates

  if object_id( 'tempdb..#anchorj') is not null begin drop table #anchorj end create table #anchorj (…

  jham55

  1 replies

  5 years, 5 months ago

  By: Steve Collins

• Sync data between Two databases

  Hi All, This is sampath i am new to sqlservercentral community,i am begginer in sql related queries…

  sampathmeka

  5 replies

  5 years, 5 months ago

  By: Mr. Brian Gale

• Divide by zero error encountered and division

  Having trouble with the below statement.  Please help if you can.  I am not that great with SQL but…

  nymets86

  8 replies

  5 years, 5 months ago

  By: nymets86

• Create delete update tables in one database to another database.

  Hi All, This is sampath i am new to sqlservercentral community,i am not good programmer in sql rela…

  sampathmeka

  19 replies

  5 years, 5 months ago

  By: sampathmeka

• PIVOTing only selected rows

  Hi, I have the following table: AA | BB ======= 1       a 2      b 1      c 2     d 1     e 2     f…

  itlk

  2 replies

  5 years, 5 months ago

  By: dale_berta

• Using DateTime2 in Access and SQLserver

  Hi, I last used Access/SQlserver about five years ago and have forgotten more than I learnt <gri…

  chris-939265

  2 replies

  5 years, 5 months ago

  By: pietlinden

• Saving integers as varchar so that I can choose '' (empty) as content

  I am considering saving integers as varchar. The reasons for that is: The case of employee numbers.…

  christoph.kauflin

  26 replies

  5 years, 5 months ago

  By: Jeff Moden

• Best strategy to automating 'complex' calculation tasks from Excel

  I have a workbook which has 4 spreadsheets. The first spreadsheet uses parameters and data from the…

  eduardoalmeidabr

  0 replies

  5 years, 6 months ago

  By: eduardoalmeidabr

• Query time after specified date

  I need help with a query. If I have a list of people each with a service date and I want to sum the…

  jham55

  3 replies

  5 years, 6 months ago

  By: jham55

• Getting the biggest spending customers for last 7 days

  Hi all, Can anyone help with the below SQL. I'm trying to get the top 5 customers for the last 7 da…

  paul 69259

  5 replies

  5 years, 6 months ago

  By: paul 69259

• Arithmetic overflow error converting expression to data type nvarchar.

  Is there a way to find the field this error is being generated by? I am trying to bring data from a…

  cbrammer1219

  9 replies

  5 years, 6 months ago

  By: Jeff Moden

• fetcth aggregate data

  Hi All,   I am having table where below list of columns OrderNo ActualHours PlanedHours calMon…

  Abhas

  3 replies

  5 years, 6 months ago

  By: Steve Jones - SSC Editor

• Execute permission on a function

  Hi All, I am relatively new to SQL and I have been given read only access to a database. I know tha…

  evaz

  5 replies

  5 years, 6 months ago

  By: Jeff Moden

• mass null replace in a query.

  I have some data that i have no control over (third party supplying the data). I am extracting it t…

  Lee Hopkins

  8 replies

  5 years, 6 months ago

  By: caitlin.mary.partridge

• expand field and fill with zeros

  I am using this statement: Select @data = @data + RIGHT('00000000000' + CAST( (SUBSTRING(STR(@qtr…

  mbatchelor

  25 replies

  5 years, 6 months ago

  By: Jeff Moden