SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Cursor in stored procedure taking hours to run

  I have written a stored procedure that updates data in my database with the data that was received …

  don075

  12 replies

  1 year, 10 months ago

  By: Jonathan AC Roberts

• Additional records needed with Using MAX function on Most Recent Record

  Hello - I would like to show a record for a patients last visit regardless of what doctor they saw.…

  jpgdrive

  7 replies

  1 year, 10 months ago

  By: drew.allen

• How to import data from HTML file or page?

  Hi all, So I have this html page: https://ofsistorage.blob.core.windows.net/publishlive/2022format…

  Jobs90312

  3 replies

  1 year, 10 months ago

  By: durai nagarajan

• Data length greater than 4000 issue

  Hi everyone, I have a XML file from which I am trying to import data into SQL tables. Some nodes in…

  Jobs90312

  1 replies

  1 year, 10 months ago

  By: Johan Bijnens

• How to pull Year from varchar field

  Hello, I have a field where I want to pull the year from.  The field unfortunately is an "Intellig…

  rjjh78

  1 replies

  1 year, 10 months ago

  By: ScottPletcher

• Writing a line for each day of month???

  I'm looking to write a record or each day of a month(or date range) I have a query that gets a name…

  jbalbo

  5 replies

  1 year, 10 months ago

  By: Jeff Moden

• Get value after certain characters

  Hello! I have a column with this data: A~B~C How would I just get the last value "C" select left('A…

  PJ_SQL

  1 replies

  1 year, 10 months ago

  By: ScottPletcher

• Prompt user for input value

    Hey folks. I need to be able to have a little box or similar pop up so a user can enter a va…

  jpgdrive

  3 replies

  1 year, 10 months ago

  By: Phil Parkin

• Query performing slow in SQL 2016 with compat level (130)

  I have two databases in SQL server  hosted on 2016 enterprise edition. One has compat level 110  …

  SQL_Surfer

  2 replies

  1 year, 10 months ago

  By: Jeff Moden

• Fetch dynamic columns in join condition

  Hi Experts, Please help me in following situation. I am having table A and Table B. Table A : In th…

  Abhas

  4 replies

  1 year, 10 months ago

  By: ScottPletcher

• LOJ followed By LOJ - What is this and is it best practices

  I came across something today I'd never seen before and I've been working with SQL for over a decad…

  YSLGuru

  9 replies

  1 year, 10 months ago

  By: Jonathan AC Roberts

• Plan Handle exists but NO QUERY PLAN?

  Is this a fully legit situation in the result of the below query to have Plan Handle but NO QUERY P…

  VoldemarG

  1 replies

  1 year, 11 months ago

  By: VoldemarG

• find connection details for all ssis jobs

  Hi, is there are way using sql that brings a list of the ssis packages deployed along with the deta…

  Bhagat

  4 replies

  1 year, 11 months ago

  By: Phil Parkin

• This code works, but am requesting help with the code.

  Hello everyone.  I don't post here often even though I am constantly on the forums reading article…

  Doug

  6 replies

  1 year, 11 months ago

  By: Doug

• Sampling : Select the sample records

  hi, I have a data like below where i need to randomize data by review type Employee   Samplesize…

  komal145

  1 replies

  1 year, 11 months ago

  By: Steve Collins