SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Bringing all the columns not just the newly created

  Hi. I have the below query but only brings the 'Max_VacationHours'  column. As yo may guess I am q…

  jutunon

  26 replies

  1 year, 10 months ago

  By: Ed B

• Stats histogram comparison with data in table (Windows function)

  Hi, I'm comparing the stats histogram with the actual data distribution from a table (for this exam…

  SQLServerCodeTweak

  0 replies

  1 year, 11 months ago

  By: SQLServerCodeTweak

• Querying XML : Type conversion in expression (CONVERT_IMPLICIT

  Hi folk, I've mocked a small piece of code that reproduces my problem. I want to get rid of the Typ…

  r5d4

  2 replies

  1 year, 11 months ago

  By: r5d4

• How to send data from table to text file by date

  please recommend me how to send data ny created date within 2 years to text file. Thank you   …

  juliava

  3 replies

  1 year, 11 months ago

  By: Jeff Moden

• UNION from many linked servers

  Hello! Here is an example of a script that selects into one table the same data spread across  2 l…

  nkat

  8 replies

  1 year, 11 months ago

  By: Michael L John

• Help parsing a fields value to create 3 new columns

  I need some help with parsing out the field [JObject]. In the application, there is a setting by us…

  Jeffs1977

  8 replies

  1 year, 11 months ago

  By: Thom A

• SELECT INTO WHERE (but do not show the result)

  deleted This topic was modified 1 year, 11 months ago by  nkat. This topic was m…

  nkat

  2 replies

  1 year, 11 months ago

  By: nkat

• Replace function

  Hi, Which is the best\elegant way to update a string in nvarchar(MAX) column? The record contains a…

  Johnson330

  1 replies

  1 year, 11 months ago

  By: Michael L John

• Reclaim space after setting varbinary(max) column to NULL

  I have a sql server 2019 database with a table that contains  a varbinary(max) column . I have use…

  kdaniapam

  4 replies

  1 year, 11 months ago

  By: kdaniapam

• To Proc or Not to Proc – Building SSRS Reports

  I'd like to hear some others' opinions on this. If you are building an SSRS report which requires a…

  Phil Parkin

  18 replies

  1 year, 11 months ago

  By: chris.johnson.0120

• Inner Join with multiple filter

  Table 1 Bank ID Transaction ID Date Amount 1 1 30-06-2020 50 1 2 30-06-2020 80 1 1 31-12-2020 72 1 …

  hirenvihaan

  3 replies

  1 year, 11 months ago

  By: chris.johnson.0120

• Issue with SSIS to connect to Oracle DB using microsoft connector

  I have installed the Professional version of Visual Studio 2019 and I am unable to connect to Oracl…

  sql.imagine

  2 replies

  1 year, 11 months ago

  By: GeorgeCopeland

• Previous Week data to current week data

  Hi All, how to get current week data to next week data. #DataTab input table and #DataTabNew desire…

  LearnSQL

  17 replies

  1 year, 11 months ago

  By: Steve Collins

• Tables with constant data

  Hello: I am creating a new database and suddenly I have a doubt. In most applications, there is alw…

  fgrodriguez

  11 replies

  1 year, 11 months ago

  By: GeorgeCopeland

• Parallel Execution of SQL in ADO.Net on C# - SQL Parameter is already contained

  Hi there Im not sure if this should be asked on a C# forum, but im taking a shot here. We have a C#…

  Weegee71

  3 replies

  1 year, 11 months ago

  By: Chris Wooding