SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Grouping based on chronological periods

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

  MrRobot

  10 replies

  11 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

  11 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

  11 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

  12 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

  1 year 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

  1 year 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

  1 year 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

  1 year, 1 month 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

  1 year, 1 month 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

  1 year, 2 months 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

  1 year, 2 months ago

  By: paul 69259

• TSQL Question

  hi, I have a stage table S, and a final/Target table T with all user details. I need to update a fi…

  komal145

  3 replies

  1 year, 3 months ago

  By: ScottPletcher

• Modifying the SSRS Data Source for particular reports

  i'm trying to either write a sql script or power shell script to change certain reports Data Source…

  ericwenger1

  1 replies

  1 year, 4 months ago

  By: ericwenger1

• How to read data from database db2 on sql server 2017 ?

  I work on sql server 2017 i need to know what technology will be quickly and fast for read data fro…

  ahmed_elbarbary.2010

  5 replies

  1 year, 4 months ago

  By: Phil Parkin

• Join on Column A when Column B is Null

  hi, I need to join on a table T1 AND Table T2. Something like this : Select * from Table T1 JOIN Ta…

  komal145

  3 replies

  1 year, 4 months ago

  By: komal145