SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Slicing status based on conditions

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

  MrRobot

  7 replies

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

  1 year, 7 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, 8 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, 9 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, 9 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, 9 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, 9 months ago

  By: komal145

• How to make ssis package to read data from db2 and insert to sql serve

  I have two servers one server have sql server database and another server have db2 database I need …

  ahmed_elbarbary.2010

  2 replies

  1 year, 9 months ago

  By: komal145

• Bulk Insert giving no error but 0 rows affected

  Hey there, new to SQL Server and the forum. I am trying to bulk import a CSV file with this line BU…

  railman

  27 replies

  1 year, 9 months ago

  By: gab.laf@hotmail.com

• PowerShell script executing from database table

  Hi, The following PowerShell script working and reading records from table, total 600 records of se…

  SQL Galaxy

  4 replies

  1 year, 10 months ago

  By: Johan Bijnens