SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Multiple Database Deployment using DACPAC

  Dear All, I am able to deploy single database using DACPAC and VS Solution ,Post deployment scripts…

  Alone

  5 replies

  3 years ago

  By: zaidmughal

• Tools needed for designing SSIS package

  Hi All, I am using SQL 2019 developer edition. I want to develop and test SSIS package, which tool …

  Saran

  1 replies

  3 years ago

  By: Phil Parkin

• Checking answers combination is correct

  Hi, I am trying to process results to this question: "What optional subjects do you study?" Results…

  Johnson330

  1 replies

  3 years ago

  By: Phil Parkin

• How to add Percentage of similar compare two string ?

  I work on sql server 2019 i have issue i can't get percentage of two string from table so i will co…

  ahmed_elbarbary.2010

  3 replies

  3 years ago

  By: Eirikur Eiriksson

• Changing datatype of column of partitioned table

  Hi, I use SQL Server 2019. Can I change the datatype of column in a partitioned table? https://lear…

  minijebu

  2 replies

  3 years ago

  By: minijebu

• Create start of week column based on dates

  I have a table of students, with an enrollment start date and end date. Some have no end dates. I'd…

  boehnc

  4 replies

  3 years ago

  By: MMartin1

• Adding of single quote in a string

  I need to add a single quote in each of the alternate characters. The input string could be a varia…

  skmoh2

  7 replies

  3 years ago

  By: Jonathan AC Roberts

• Replace value from

  Hi guys I hope everything's ok with all of you I have this example to do it in SQL. I want all char…

  pedroccamara

  11 replies

  3 years ago

  By: pedroccamara

• Trying to go remote through a Cox Technicolor Modem/Router

  I'm really not sure how to ask or what to ask for.  This is NOT an Openvpn question. This is about …

  Jocar26

  1 replies

  3 years ago

  By: Jocar26

• Calling stored procedure to bulk import from SSIS causes access denied

  Hi, I'm working on building a data validation engine, which is supposed to check a number of items,…

  markdummen

  9 replies

  3 years ago

  By: Justin Terry

• Cube Deployment issue

  Hi All, I am kind of lost . SSAS Cube deployment with the message 'You cannot deploy the model beca…

  Smash125

  4 replies

  3 years ago

  By: Smash125

• Case Statement give me an error

  CASE WHEN PM_PROJECT.PROJ_MGR_ID IS NULL THEN CASE WHEN PM_PROJECT.SCHED_MGR_ID IS NULL THEN ' ' EL…

  RDOT

  3 replies

  3 years ago

  By: jcelko212 32090

• Query table results for Yesterday not giving results for just yesterday

  I have tried a couple of where clause statements for date yesterday. No matter what I put in there …

  brian.cook

  3 replies

  3 years ago

  By: brian.cook

• Dates 1 week and 1-2 years ago in SQL

  Hello, I am trying to understand how it is possible to select 3 dates in SQL. 1) Last Saturday 1 we…

  JeremyU

  4 replies

  3 years ago

  By: JeremyU

• How do I JOIN to a Linked Server in a VIEW without using a CTE

  I need to create a VIEW that joins a table in the current database (SSMS2019 environment), to a tab…

  Rob

  3 replies

  3 years ago

  By: Jeffrey Williams