SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Copy an existing table to a new table...

  None of this works:   USE DriveWorks_Data CREATE TABLE 2415_10_Ga_Trunking_Design_Configurator…

  stephen.aa

  6 replies

  4 years ago

  By: Jeff Moden

• Need T-SQL revised to show 3rd column

  Each year we decommission "X" number of SQL Servers and track these in a table. I need underlying S…

  Express12

  2 replies

  4 years ago

  By: Express12

• DBMail

  I'm using a stored procedure executed through a SQL Agent job to send out multiple emails.   I've b…

  DBAless

  8 replies

  4 years ago

  By: DBAless

• Cannot execute query "Remote Query" - CREATE TABLE permission denied in tempdb

  I have a SQL Server 2019 instance with Polybase set up (Server A).  I am using Polybase to select d…

  Wolfmeister

  1 replies

  4 years ago

  By: Wolfmeister

• import WooCommerce csv file into MSSQL using TSQL

  Hi I have a woocommerce web site, I need to use the order data to generate report in MSSQL. I every…

  wailoon.ho

  3 replies

  4 years ago

  By: wailoon.ho

• How to split string and separate the data with numbers and text

  I am having a set of medication where I am trying to split the data and get the required output, I …

  sqldevlearn

  12 replies

  4 years ago

  By: Jeff Moden

• Empty Result Set with show "Actual Execution Plan" = on but with off I get rows

  Hello everybody, I have a CLR table vlaued function, which recursively determines the "linked" data…

  Gerhard P.

  3 replies

  4 years ago

  By: Gerhard P.

• Constrain a transaction table using data from a master table

    I have a "Master" product table that looks like this: table name tWholesaleProduct Then we …

  Caruncles

  1 replies

  4 years ago

  By: ratbak

• SQL JSON Ouptput

  I have table with code type , code & Value. I want out in json like this way. In this example C…

  sks_989

  2 replies

  4 years ago

  By: sks_989

• Sum field with where clause based on a RecordId

  I'm going to blush when I hear the answer to this.  Think I'm over tired.  I made this simple examp…

  texpic

  4 replies

  4 years ago

  By: Steve Collins

• SP causing blocking

  I have a simple proc that I suspect is causing intermittent blocking.  It takes a customer ID (int)…

  John Deupree

  7 replies

  4 years ago

  By: John Deupree

• T-SQL Unique Index - classification of unique - advice needed

  I have inherited a data warehouse with Type II SCD tables. Each row has an entity_identifier (not n…

  aaron.reese

  3 replies

  4 years ago

  By: Thom A

• Help with code

  Hi, I have the following code which will give me a list of every fortnight between two dates howeve…

  g12consult

  5 replies

  4 years ago

  By: g12consult

• sp_OAMethod to make rest api call

  Greetings, I have a need to call a rest api against a resource. It a POST and would like to send th…

  yosiasz

  3 replies

  4 years, 1 month ago

  By: Sandeep Kataria

• Placing a Case Statement with a varialble into a Where Clause

  I have the following statement in my stored procedure SELECT mpe.MeasuringPointEntryID FROM [locati…

  Weegee71

  3 replies

  4 years, 1 month ago

  By: Michael L John