SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Query help please

  I have a history table that tracks changes to client records, im having trouble writing a query tha…

  joshukov

  9 replies

  1 year ago

  By: MMartin1

• SSIS Package Execution issue using ODBC Oracle Source

  Hi, I'm having an issue running a package when I have an ODBC Oracle Source.  When I manually …

  skaggs.andrew

  12 replies

  1 year ago

  By: popmuzik

• Selecting MAX value in 1 column based on code in another column?

  Here is a simplified sample of my data... (there are additional columns, but not relevant right now…

  tsobiech

  30 replies

  1 year, 1 month ago

  By: tsobiech

• SSIS and Regional Settings

  We recently moved our production databases to a new server. Since then, an SSIS package has changed…

  planetmatt

  1 replies

  1 year, 1 month ago

  By: Mr. Brian Gale

• SQL agent help

  Hi Guys, I have an SQL Agent job. It is called an SSIS Package and is stored in SSIS DB. I can see …

  rocky_498

  7 replies

  1 year, 1 month ago

  By: P Jones

• Dynamically get max of a field from table

  How can I make my queries below dynamic?  I want to get the Max() of sfilename of all tables in my…

  GrassHopper

  12 replies

  1 year, 1 month ago

  By: ScottPletcher

• How Can I set the right value according to comparison conditition

  Hello, i have 2 tables , the first one is a referential of the quality services and the second is a…

  MrRobot

  3 replies

  1 year, 1 month ago

  By: drew.allen

• Strange Behavior with MSOLEDB19 driver

  We have recently changed many of our SSIS packages from using the depreciated SQL Native 11 driver …

  planetmatt

  3 replies

  1 year, 2 months ago

  By: frederico_fonseca

• How to Alert When SQL Queries Exceed a Time Limit During Execution?

  I've been exploring various methods to monitor and alert for long-running queries in SQL Server.  …

  IT researcher

  1 replies

  1 year, 2 months ago

  By: Casper101

• xp_cmdshell giving error error browsing Sharepoint Online directory files

  DECLARE @var VARCHAR(2000) SET @var = 'dir ' + '\\company.sharepoint.com@SSL\DavWWWRoot\sites\Order…

  skb 44459

  3 replies

  1 year, 2 months ago

  By: Jeff Moden

• How to Rank this...

  I'm failing to write a suitable rank function to label the following select resultset as seen here.…

  stiej1977

  1 replies

  1 year, 3 months ago

  By: Phil Parkin

• Error handling with SSIS and stored procedure execution

  Hello SSC! Happy New Year and I hope everyone had a safe and healthy holiday! I have this ETL proce…

  Lord Slaagh

  9 replies

  1 year, 4 months ago

  By: Lord Slaagh

• Grouping based on chronological periods

  Hello, I have a table Customers that contains the current value and another table Customers_History…

  MrRobot

  10 replies

  1 year, 4 months ago

  By: Mr. Brian Gale

• Null value is eliminated by an aggregate or other SET operation

  Should I see this warning when I have ISNULL check at SUM function and changing NULLs to 0?   …

  lapus014

  4 replies

  1 year, 4 months ago

  By: frederico_fonseca

• How to establish a relationship in SQL Server

  Good morning and Merry Christmas everyone! I'm not sure if anyone has posted something like this be…

  SQLWannabe

  2 replies

  1 year, 4 months ago

  By: Jeff Moden