SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• What to expect on first day of PL SQL at new firm?

  Hi All, Looking for answer on what do I expect to happen on very first day for PL SQL job role, giv…

  ns550

  5 replies

  6 hours, 6 minutes ago

  By: homebrew01

• Entry point in sysdatabases

  Newbie to this .. will learn .. am motivated. When I do a script for creating a new database I get …

  Peekay

  8 replies

  2 days, 3 hours ago

  By: ScottPletcher

• How to troubleshoot PK Constraint violation

  I'm hoping someone has seen this before because I've been doing this for years and never had this p…

  yoyodynedata

  2 replies

  3 days, 1 hour ago

  By: Mr. Brian Gale

• Page/Row DEcompression, when does it occur?

  I can't seem to find the answer to this seemingly valid question which rather hints that the answer…

  timoq

  1 replies

  3 days, 7 hours ago

  By: ScottPletcher

• Using REVERSE

  I am trying to use the REVERSE function to "split" the field TreeMap into columns.  The function w…

  sqldummy79

  19 replies

  3 days, 16 hours ago

  By: chris.johnson.0120

• Need help on my SQL

  Hi there, I need help to use SQL to pull data from SQL Server and feed it to Tableau as data source…

  albert_leung

  1 replies

  4 days, 6 hours ago

  By: Mr. Brian Gale

• SSIS Oracle Source - DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

  Hi All, I'm using Visual Studio 2019 to get data from a Oracle Database and transfer it to a SQL 20…

  BIDeveloper

  1 replies

  4 days, 7 hours ago

  By: BIDeveloper

• Including certain columns creates long query time

  Hi, I have a query that takes a long time to run if I add  certain column(s) to it. I realize this…

  jmetape

  8 replies

  4 days, 13 hours ago

  By: Thom A

• Convert teradata REGEXP_INSTR into SQL SERVER

  Hi, I need some guidelines to convert Teradata REGEXP_INSTR logic into SQL server code. Please find…

  latitiacasta

  4 replies

  6 days, 6 hours ago

  By: Alan Burstein

• BCP error "Copy direction must be either 'in' or 'out'"

  Hello, I am facing the below issue. I run a bcp queryout command (select field names union all sele…

  kakovatos7

  21 replies

  6 days, 9 hours ago

  By: ZZartin

• If Statement in Computed Column

  Greetings, Thank You for taking the time to read and hopefully answer my question.  You will soon …

  psalms46.10

  3 replies

  1 week, 1 day ago

  By: Jeff Moden

• Loan Amortization Schedule for SQL Server

  So, long story short... A conversation about loops, cursors and in-line functions ended up with me …

  Jason A. Long

  16 replies

  1 week, 6 days ago

  By: Jason A. Long

• How can i do cumulative subtraction for the table based on multiple col's

  Hi I have a leave table where there are RL (rem leaves),AL (allocated leaves) as follows DECLARE @E…

  aggy_02_20

  1 replies

  1 week, 6 days ago

  By: Steve Collins

• How to ALTER COLUMN without SELECT and UPDATE permissions

  I try to ALTER a column by changing the datatype from integer to NUMERIC(35,10).  IMPORTANT : The …

  Pete Softown

  7 replies

  1 week, 6 days ago

  By: Jeff Moden

• filter by WHERE has no effect

  SQL WHERE clause not working trying to filter by date "WHERE [dtmDocDate] >= '2020-09-01'" has n…

  onechipshot

  8 replies

  2 weeks ago

  By: onechipshot