SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Very slow sp_cursorprepexec

  Hi All I'm trying to debug/understand some very slow performance in some SQL executed sent via an a…

  andrew 67979

  9 replies

  7 years, 1 month ago

  By: Jeff Moden

• Eval function TSql

  is there a TSQL function that allows to validate an operation? Example: Select (1 = 0) should retur…

  marco.bugada

  7 replies

  7 years, 1 month ago

  By: Eirikur Eiriksson

• dtsx job to import and export

  Hi, I like to create import (Excel to table) and export (Table to Excel) job using sql import and e…

  rchandra1

  4 replies

  7 years, 1 month ago

  By: Jeff Moden

• SQL help with date comaprisons

  Hi, I have a scenario where i need to calculate the number of days of hold on a loan .Example …

  komal145

  17 replies

  7 years, 1 month ago

  By: komal145

• parsing log data

  hi everyone, i have case to parsing the log data like this on sql server { "Name": "David", "Gende…

  David7777

  11 replies

  7 years, 1 month ago

  By: sgmunson

• Trying to find the minimum date for 1st fuel and non fuel transaction

  Hi all, I have been struggling with this query for a while now. I am trying to bring back A.Account…

  sindykp

  7 replies

  7 years, 1 month ago

  By: drew.allen

• SQL Database Documentation

  We have a situation where the Lead SQL Developer is leaving the company and he says there's no docu…

  Charles_P

  8 replies

  7 years, 1 month ago

  By: aaron.reese

• Design the tables to consolidate the kafka messages

  Hi All, I have below scenario: 2 DBs: DB1 and DB2 which will later replace DB1.…

  ankit.satyam

  2 replies

  7 years, 1 month ago

  By: sgmunson

• Joining dates to calculate payment month dates

  Hi I need some help and new to SQL and this forum.Please advise.I have a scenario if an employee jo…

  traj0130

  3 replies

  7 years, 1 month ago

  By: Jeff Moden

• Simple Query?

  I found this in anther forum and thought it would be a simple query, but I'm drawing a complete bla…

  Mike01

  4 replies

  7 years, 1 month ago

  By: Mike01

• Finding levels in a hierarchy

  i have some data which has a variable amount of hiearchy levels to it, DAX has a function called Pa…

  vee van gelder

  20 replies

  7 years, 1 month ago

  By: Jeff Moden

• Assistance with DATETIME calculation when comparing to VARCHAR column (Test code included)

  Hello, so I'm trying to get the difference in MINUTES between two columns.One column is a DATETIME …

  cor_dog2

  12 replies

  7 years, 1 month ago

  By: MMartin1

• OLEDB and Attunity both are slow with CLOB IN SSIS

  Hi Guys I need you help again I am using Auutinit drivers to extract the data from Oracle Table. On…

  learningsqlkid

  3 replies

  7 years, 1 month ago

  By: frederico_fonseca

• Writing a Complex View

  I'm working on combining the latest record from a number of tables to create one view with the most…

  yoyodynedata

  5 replies

  7 years, 1 month ago

  By: yoyodynedata

• Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

  Can this stored procedure be modified to work properly?  When trying to save, SQL Server retur…

  cchapel

  3 replies

  7 years, 1 month ago

  By: sgmunson