SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  6 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

  7 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

  7 months, 3 weeks 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

  8 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

  8 months, 1 week 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

  8 months, 2 weeks 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

  8 months, 4 weeks ago

  By: Jeff Moden

• Slicing status based on conditions

  Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points (for c…

  MrRobot

  7 replies

  9 months ago

  By: jschmidt 17654

• Query

  ServerName DatabaseName DatabaseSize(MB) Date Server DBName Size Date A DB 110 6/1/2023 A DB 113 7/…

  mtz676

  10 replies

  9 months, 1 week ago

  By: mtz676

• How to convert PDF data to database table in SQL server

  Hi,Can any one suggest on conveting PDF file data to SQL table in SQL server.Thanks.

  keddula

  17 replies

  9 months, 2 weeks ago

  By: pietlinden

• T-SQL : Slicing status by related time periods and other status

  Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points (for c…

  MrRobot

  8 replies

  9 months, 3 weeks ago

  By: Phil Parkin

• How can an alias name be assigned to a database?

  Are there any methods  to create an alias for a database similarly to SQL Server aliasing. For  S…

  IT researcher

  1 replies

  10 months, 1 week ago

  By: frederico_fonseca

• Can’t return role based on employee no from three columns?

  I need to write a SQL Server query return only one role from table dbo.F6000059 based on employee…

  ahmed_elbarbary.2010

  5 replies

  11 months ago

  By: Steve Collins

• SQL to get FK GUID from parent table using 2 different databases

  Hi all, This is what I need to do. I need to get a field called chargeguid from the charge table of…

  paul 69259

  1 replies

  11 months, 1 week ago

  By: paul 69259

• Copying an old database to a new database

  Hi All, I've got a write a program to copy the data from one database over to another. The destinat…

  paul 69259

  2 replies

  12 months ago

  By: paul 69259