SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Replacing last few characters with another value.

  I'm hoping for a bit of assistance, I know this is probably easy but just having a hard time solvin…

  Tava

  19 replies

  1 year, 9 months ago

  By: Jeff Moden

• Insert records based on value

  I have a query that returns how many weeks between 2 dates and would like to insert a record for ev…

  bob_kudulis

  1 replies

  1 year, 9 months ago

  By: Steve Collins

• Time Tally Table

  I'm attempting to create a time tally table but it is not working as expected. I just need a start …

  dougsto

  5 replies

  1 year, 10 months ago

  By: Jeff Moden

• Query column in table where column may have two values

  I currently have a table such as: id code 1 1 2 10,2 3 40 4 29,9 I have another table that con…

  DotNetCoder

  10 replies

  1 year, 10 months ago

  By: pietlinden

• Result of executing SQLCMD from command prompt differs from batch file

  I have the following to find the failed logins from yesterday from the server logs. sqlcmd -b -d ma…

  lan2022nguyen

  9 replies

  1 year, 10 months ago

  By: lan2022nguyen

• Powershell script executes locally but not after deploy to Server

  Hi, I have a package with a Execute Process Task object that executes a PowerShell script that down…

  BradWilk

  5 replies

  1 year, 10 months ago

  By: Phil Parkin

• how to reverse comma seprated values.

  hi, i have coma separated vales in a table. what i want to reverse it like 'CLP,CAD,GBP' pls tell m…

  rajemessage 14195

  5 replies

  1 year, 10 months ago

  By: Jeff Moden

• Has SQL Server Introduced a way for Converting HTML to non-HTML stored as VARCHA

  If a table stores in a column of type VARCHAR the textual equivalent of an html page, does SQL Serv…

  YSLGuru

  6 replies

  1 year, 10 months ago

  By: YSLGuru

• Find a word from string

  Hi All I would like to get rows wherever it has "restricted" . If I write condition with like '%res…

  Saran

  4 replies

  1 year, 10 months ago

  By: Saran

• Importing a MySQL database

  I've used the Import Wizard in SSMS a few times. Mostly to get data from one server to another. Occ…

  Rod at work

  12 replies

  1 year, 10 months ago

  By: Mr. Brian Gale

• Convert columns result into rows with comma and single quotes

  Hi All, Hi All, I want to convert columns result into rows with comma. Ex: Result should be - 'SQL1…

  Saran

  8 replies

  1 year, 10 months ago

  By: Jeff Moden

• Query to find latest full backup with all database except tempDB

  Hi All, I am looking for query to get latest full backup with all database except tempDB. I have go…

  Saran

  7 replies

  1 year, 10 months ago

  By: David Wiseman

• Avoiding Conversion errors

  Hello All, Couple of questions on conversion errors. First I have to convert since my reference tab…

  Chrissy321

  6 replies

  1 year, 10 months ago

  By: ScottPletcher

• Table scan shows too many records

  Looking at the query plan for a rather complicated select, which draws from views, I see the very b…

  pdanes

  6 replies

  1 year, 10 months ago

  By: frederico_fonseca

• Need help with the logic

  I have some date variables which are used in the SP but one of the main table is going away and I a…

  LearningDBA

  3 replies

  1 year, 10 months ago

  By: Jeff Moden