SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date

  I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model', L.…

  gski

  2 replies

  8 months ago

  By: ScottPletcher

• Remote query is taking 99% cost of local sp execution

  So we have local sp in which remote table is udpated.this remote query part is 99% of cost of all s…

  anoop.mig29

  2 replies

  8 months ago

  By: Steve Jones - SSC Editor

• Join 2 tables

  Table A ServerName ColB ServerA C ServerA I ServerA L ServerA M Ser…

  mtz676

  3 replies

  8 months ago

  By: mtz676

• Impact of Not Including Foreign Keys in an SQL Archive Database

  Hello everyone, I am about to start a data archiving project that will affect almost all tables in …

  abdalah.mehdoini

  1 replies

  8 months ago

  By: Grant Fritchey

• how to fix this error?

  hi I am creating a stored procedure to reduce log size when needed.  I want to explicitly state whi…

  water490

  2 replies

  8 months ago

  By: water490

• dont see a file system task approach to copying excel

  Hi , rather than the approach at https://stackoverflow.com/questions/68314594/copy-an-excel-sheet-a…

  stan

  2 replies

  8 months ago

  By: stan

• need community help on 1 final cdata odbc driver product eval question

  Hi, for whatever reason,  CDATA is conflicted about answering 1 remaining disclosure type question …

  stan

  2 replies

  8 months, 1 week ago

  By: stan

• dont want pkg to abort if someone is in excel source document

  Hi, is there a way when using excel as a flat file source in ssis to forgive the fact that someone …

  stan

  3 replies

  8 months, 1 week ago

  By: stan

• need help with assigning a value to a variable

  Hi I am trying to assign the value of the  variable using the output of a query but I am getting an…

  water490

  6 replies

  8 months, 1 week ago

  By: Jeffrey Williams

• does netsuite really hide columns from customers?

  Hi we built a gateway from sql server to netsuite using an oracle competitor's odbc driver. once it…

  stan

  5 replies

  8 months, 1 week ago

  By: stan

• how to calculate an average only if a minimum number of records exist?

  Hi I am working on a rolling average calculation that is not working quite right.  Here is the code…

  water490

  3 replies

  8 months, 1 week ago

  By: water490

• adding dtc to my pkg

  Hi below i show the control flow of my pkg.   I'd like to enlist any component that updates into dt…

  stan

  1 replies

  8 months, 2 weeks ago

  By: stan

• String Variable and sp_executesql

  I am not understanding why this command completes "successfully" and it seems correct to me. Howeve…

  stevec883

  4 replies

  8 months, 2 weeks ago

  By: stevec883

• New SSIS Package fails in Sql Agent when it includes a script component

  I'm creating a new SSIS package using VS2022 to target Sql Server 2019 server. I have ended up with…

  Grant McAllister

  9 replies

  8 months, 2 weeks ago

  By: Grant McAllister

• How to speed up this query?

  Hi everyone I have a query that is taking a real long time.  It takes close to 30 minutes to proces…

  water490

  6 replies

  8 months, 2 weeks ago

  By: Ken McKelvey