SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• how to use a variable in a CASE statement?

  hi everyone I am getting an error when I add a variable to a CASE statement.  How can I fix it? Cod…

  water490

  4 replies

  1 months, 3 weeks ago

  By: water490

• Replication from IBMi DB2 to MS SQL

  We have a tool called DB Moto that reads journals (like t-logs) and replicates to SQL, but it's bei…

  homebrew01

  2 replies

  1 months, 3 weeks ago

  By: Ken McKelvey

• Is there a way to have dynamic table headers?

  Hi everyone I have a SP which compares two tables and outputs mismatching entries: SELECT T1.QUOTE_…

  water490

  3 replies

  1 months, 4 weeks ago

  By: water490

• is there a way to "detect" schema like changes on a server?

  Hi, we have a few people who like to experiment on our prod sql server with new tables, schema chan…

  stan

  4 replies

  2 months, 1 weeks ago

  By: Ant-Green

• Next dates

  CREATE TABLE ADMITS ( ID_NUM INT varchar(15) null ,provider_id varchar(15) null ,provider_name varc…

  smattiko83

  4 replies

  2 months, 3 weeks ago

  By: Ed B

• need to find rows in a table based upon a type field BUT stop when a select type

  i have a table account number, date, type, amount 0000001, 20250815, P, 200.00 0000001, 20250810, C…

  roy.tollison

  6 replies

  2 months, 4 weeks ago

  By: roy.tollison

• Replace with like join

  I am trying to create and Update query based on a like join.  Is that possible?  This is what I hav…

  James Bosco

  4 replies

  3 months ago

  By: Mr. Brian Gale

• Snowflake ODBC to SQL Ole Destination ERROR

  Hi there, everyone. We've create and SSIS package that gets data from a Snowflake database via an O…

  darkangelBDF

  4 replies

  3 months ago

  By: cmulwa

• built in deadlock information capture

  Hi, i cannot recall the object or even if it comes off the shelf but i once saw a tool in sql serve…

  stan

  3 replies

  3 months, 1 weeks ago

  By: stan

• why do my advanced i/o column lengths on city keep changing

  hi , every time i go back to an ssis pkg that is under construction, at least one column in a tsv n…

  stan

  1 replies

  3 months, 2 weeks ago

  By: Site Owners

• Comparing one record within a SELECT SUM()

  If I had data of the form: rn value processed 1 10.0 N 2 12.2 N 3 8.4 Y 4 5.9 …

  Pete Bishop

  8 replies

  3 months, 4 weeks ago

  By: Mr. Brian Gale

• Upgraded VS2019 to version 16.11.49 but I cannot access my original SSIS package

  Hi I upgraded to new version of VS2019 to 16.11.49.  My original SSIS package is not accessible any…

  water490

  8 replies

  4 months ago

  By: water490

• how to move all SP from one db to another db?

  Hi everyone I have two db - one is test and other is archive.  In the test db I have SP that begin …

  water490

  10 replies

  4 months, 1 weeks ago

  By: Brooks-Hayward

• do i lose "what this object depends on" etc when moving sprocs to etl server

  Hi i was surprised to see the approach my coworkers used to sunset talend , a combo etl and job sch…

  stan

  2 replies

  4 months, 1 weeks ago

  By: frederico_fonseca

• Report Table/view or SP in SQL to handle various reports

  I have an Access database with a SQL backend with tables, views, SP's. I have reports to run based …

  JP789

  2 replies

  4 months, 2 weeks ago

  By: pietlinden