SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Formatting issue with percent

  I have an issue that may be an easy fix for someone, but is not for me. I need to calculate Instock…

  JeremyU

  4 replies

  3 years, 12 months ago

  By: JeremyU

• Query with a column containing JSON text

  Hi I have a table MyFiles with columns Id, FileName, FolderName, KeyPairs. The last one (nvarchar(M…

  Roust_m

  1 replies

  3 years, 12 months ago

  By: Mark Cowne

• Stored procedure Error converting data type varchar to bigint

  I have been using below stored procedure which works very well for SQL Server 2012 but in SQL Serve…

  SQlLogic

  18 replies

  3 years, 12 months ago

  By: frederico_fonseca

• Copy files from folder using SQL Server.

  Good day everyone. I hope someone can help me on that one. I have a database that include file fold…

  Charles Bilodeau-369032

  3 replies

  3 years, 12 months ago

  By: ikooruhq

• Assign multiple fields to one variable

  Hi I need to write a query / procedure that will create the following string - Column1Name=Column1V…

  Jeepisfun

  2 replies

  4 years ago

  By: Jeff Moden

• Inserting records in bulk, but check total quantity of all products first

  Lets say I am creating orders and each order can have same product. I am inserting orders in bulk, …

  MountainEve

  7 replies

  4 years ago

  By: ScottPletcher

• runas netonly not quite working

  Hello, I have a non domain laptop at home that is able to connect to my works network. I can see sh…

  William Bendall

  2 replies

  4 years ago

  By: Jeffrey Williams

• sp_send_dbmail: Failed to initialize sqlcmd library with error number -214746725

  This one is bugging the daylights out of me. We've got a stored proc that does some error checking …

  Brandie Tarvin

  1 replies

  4 years ago

  By: Brandie Tarvin

• show data for today only

  Hi, I have a table call data setup like the below: ID (PK) Initial (nchar10) RFID (nchar10) Time (d…

  jamesstirling01

  10 replies

  4 years ago

  By: Ant-Green

• Need Some HELP with a Query to help me validate other program.

  Hello, New to SQL Server Central.  I am a JD Edwards Developer by trade, but am in need of assistan…

  FrankCLT

  4 replies

  4 years ago

  By: Jeff Moden

• Clustered vs Nonclustered Columnstore Update Performance

  Hi Everyone, I'm experiencing horrendous update performance with Clustered Columnstore Indexes (CCI…

  MadOwl

  14 replies

  4 years ago

  By: MadOwl

• WHILE LOOP THAT LOOPS BASED ON AN ID

  Hello Friends of SQLServerCentral! I am trying to create an amortization table in a view (this is n…

  Guru1997

  2 replies

  4 years ago

  By: Steve Collins

• Query to show who is still checked in.

  Hi, I am trying to write a query to see who is still checked-in. In our warehouse I have one table …

  jamesstirling01

  2 replies

  4 years ago

  By: jamesstirling01

• How to split Xml columns or Json into records

  I have to import every days from 1000 to 100000 records. Bulk insert create one record with the com…

  frederic.leurs

  4 replies

  4 years ago

  By: Mr. Brian Gale

• grouping rows into sets

  wish to group rows into "sets" based on t_id and t_type. -- set up, notes, and expected results bel…

  J Livingston SQL

  11 replies

  4 years ago

  By: Jeff Moden