SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• 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, 4 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, 4 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, 4 months ago

  By: Johan Bijnens

• tsql help

  Hi All, Need some TSQL help. Need to extract a portion of the string of [tran_log_writes] column, c…

  vsamantha35

  3 replies

  1 year, 4 months ago

  By: ScottPletcher

• Need help with a Query logic

  I have a table which tracks of activity when users from one specific app login and logout. But I ha…

  LearningDBA

  3 replies

  1 year, 6 months ago

  By: jcelko212 32090

• Alter multiple procedures within the same script wrapped in transaction

  Hi I am looking for a way to alter multiple procedures in the same script wrapped in a transaction.…

  erics44

  10 replies

  1 year, 6 months ago

  By: erics44

• TOP with Order By alternative, performance results look mixed

  Hi I have a situation where I am testing two versions of the same query for performance. Assume we …

  MMartin1

  8 replies

  1 year, 6 months ago

  By: MMartin1

• Populate fields where CSV Sting has data matching given Column name

  Given multiple ROWs comprised of varying combinations of Comma delineated values and an ID. Given a…

  AlexanderDelarge

  10 replies

  1 year, 6 months ago

  By: Phil Parkin

• Transaction locking -updlock,rowlock

  Hi, following is code of one of my proc . This proc is updating user balance and creating some rows…

  thbaig

  1 replies

  1 year, 7 months ago

  By: thbaig

• sql time zone conversions

  hi folks i need to convert a date/time field between two time zones the date/time stamp is in GMT S…

  dopydb

  7 replies

  1 year, 7 months ago

  By: DesNorton

• Tracking of Accounts data and Stored procedures

  Please find my sample db here:https://drive.google.com/file/d/1_8JWxOrAdKEz1dxKITnqW3HZr1GTBgB9/vie…

  yrstruly

  22 replies

  1 year, 8 months ago

  By: Thom A

• Getting every day data into "AccountCommissionHistory"

  Please find sample data in bacpac format. I would like my data to be loaded daily with a start and …

  yrstruly

  16 replies

  1 year, 8 months ago

  By: frederico_fonseca

• Weird problem with substring function over 'text' column

  In the query below, I get the Invalid length parameter passed to the LEFT or SUBSTRING function err…

  _simon_

  2 replies

  1 year, 8 months ago

  By: ScottPletcher

• SQL Agent Job schedule

  Hi All, Want to know what are the SQL Agent Jobs scheduled for today at what time they are going to…

  vsamantha35

  2 replies

  1 year, 8 months ago

  By: Michael L John

• Tsql query to show currently running sql agent jobs

  Hi All, Using Tsql query I want to know currently running sql agent jobs and how long they have bee…

  vsamantha35

  4 replies

  1 year, 8 months ago

  By: ScottPletcher