SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• 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, 10 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, 12 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, 12 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

  2 years 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

  2 years 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

  2 years 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

  2 years, 1 month 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

  2 years, 1 month 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

  2 years, 1 month 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

  2 years, 2 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

  2 years, 2 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

  2 years, 2 months ago

  By: ScottPletcher

• how to identify table(s) changing quite often

  Hi All, Is there any query using which we can tell what is the table which is changing the most or …

  vsamantha35

  3 replies

  2 years, 2 months ago

  By: Ant-Green

• transaction related error.

  Hi All, Getting below error when running a stored proc? The stored proc was working fine for a whil…

  vsamantha35

  1 replies

  2 years, 2 months ago

  By: Ant-Green

• Hexa 2 decimal 20 digits

  Hi, Need to convert a hexadecimal to decimal/numeric with 20 digits, but due to bigint limitation i…

  ricardocalado

  13 replies

  2 years, 2 months ago

  By: Jeff Moden