SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• How a batch can get how much CPU it used in SQL Server 2019

  Is there something I can put at the end of a batch to find out how many milliseconds of CPU it used…

  uncager

  13 replies

  4 years, 4 months ago

  By: Michael L John

• OPENJSON unable to parse Portuguese characters

  I'm trying to convert my JSON data into a table format in SQL Server Express 2019. Following are my…

  HugoP

  4 replies

  4 years, 4 months ago

  By: Phil Parkin

• Configurations in visual studio around different environments

  Hi All, Been working with visual studio to produce SSRS reports for a few years and i have some que…

  rogue1009

  1 replies

  4 years, 4 months ago

  By: rogue1009

• Parsing / importing Costco Receipt data

  OMG. I think CostCo doesn't want anyone to do anything with their own purchase data. If you've ever…

  pietlinden

  6 replies

  4 years, 4 months ago

  By: pietlinden

• SQL Query Help

  Hi, Below is my sample data. What I am looking, if "product_descr" has more than one value separate…

  rocky_498

  2 replies

  4 years, 4 months ago

  By: rocky_498

• Common Import format to import data and database schema from various SQL dbs

  Out customers use different SQL databases, like PostgreSQL, SQL Server, MySQL. We need to import da…

  itlk

  3 replies

  4 years, 4 months ago

  By: Jeff Moden

• Calculate the Orientation for given distance and Source Coordinates

  Hi , I do have source coordinates and distance to destination in meters .I need to calculate the De…

  Steve Dell

  2 replies

  4 years, 4 months ago

  By: Grant Fritchey

• transposing date column to rows

  Hello people, I am trying to transpose date column to rows. I am not sure if this can be done for m…

  sidlfc08

  7 replies

  4 years, 4 months ago

  By: Thom A

• Having a case or if statement in where clause on Max Date

  The issue is that I need to select the MAX date when: If the Max Date from my_column is equal to to…

  a_car11

  9 replies

  4 years, 4 months ago

  By: kaj

• SS2019 Running Extremely Slow

  Hi everyone I got a new computer and copied over the DB from my old machine.  I backed up the DB fr…

  water490

  37 replies

  4 years, 4 months ago

  By: water490

• Create constraint using index

  Is there a way in T-SQL to use an existing index as source for a constraint? Goal: Have a constrain…

  Jo Pattyn

  4 replies

  4 years, 4 months ago

  By: ScottPletcher

• Trimming inconsistent values in a column (SQL)

  I have such an issue. On column namely t.DC has sometimes other values after the number for example…

  JeremyU

  2 replies

  4 years, 4 months ago

  By: Madhu g

• Performance related issue after using left join to bring new fields to the query

    i have stored procedure which was running fantastic. When ran with parameters it gives resul…

  Smash125

  4 replies

  4 years, 4 months ago

  By: Jeff Moden

• Trying to re-id a database table and getting error on the first select keyword

  I have a small table ( < 1000 lines). I deleted the first entry ID 1 as it was invalid. I know i…

  brian.cook

  9 replies

  4 years, 4 months ago

  By: kaj

• Converting varchar to Int for date difference

  Hi Experts, Constraints: I do not have create permissions and I am learning This is my code Basical…

  protocoder

  4 replies

  4 years, 4 months ago

  By: protocoder