SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

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

  By: Jeff Moden

• Basic SQL Question

  I am new to SQL and I am having a hard time finding resources on a basic question. I have two simpl…

  porterdl

  11 replies

  5 years, 7 months ago

  By: Steve Collins

• How to upgrade SSIS packages developed in 2015 SSDT to 2019?

  Hi,  I have developed SSIS packages in 2015 SSDT and now I wanted to deploy these SSIS packages int…

  raza17

  1 replies

  5 years, 7 months ago

  By: raza17

• before update trigger on sql server

  Hi everyone, I have two tables called users and formerpasswords. In users I have two fields: name w…

  albertht1987

  5 replies

  5 years, 7 months ago

  By: Jeff Moden

• Masking part of a filename with a certain pattern

  Hi there I have the following input string which represents the name of a file I have created SVPP_…

  Weegee2017

  4 replies

  5 years, 7 months ago

  By: schleep

• SQL Case expression

  Hi people I am still a beginner on SQL and I need help get a logic whereby whenever in the attached…

  Papilio

  1 replies

  5 years, 7 months ago

  By: BTylerWhite

• Converting nvarchar to date

  I am not getting why this isn't working? Any suggestion plz. Conversion failed when converting date…

  cbrammer1219

  25 replies

  5 years, 7 months ago

  By: Jeff Moden