SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Storing File in SQL database - Best option

  What do I tell a .net developer is the best approach for storing various file type in a SQL db? PDF…

  drbob

  2 replies

  17 hours, 13 minutes ago

  By: Grant Fritchey

• sql server 2016 performance tuning

  I have opportunity to tune below monster query. Is there anything right off the bat you guys think …

  rohitkocharda

  6 replies

  1 day, 9 hours ago

  By: Jeffrey Williams

• SQL Query - FULL JOIN multiple tables but return NULL results

  Good day! Need help with my sql query code; first FULL JOIN "ILEtransfer" no NULL result but im get…

  glennyboy

  1 replies

  4 days, 13 hours ago

  By: ScottPletcher

• SSRS pipe delimited subscription

  In SSRS 2016, is there a way to have a pipe delimited option in a report subscription? There is an …

  SQLHeap

  1 replies

  6 days, 11 hours ago

  By: SQLHeap

• How to change week8, week31, week32, etc to week1, week2, week3, etc.

  I'm trying to use row_number to "reassign" the week number of my data. So, the lowest week number s…

  NineIron

  2 replies

  6 days, 14 hours ago

  By: Phil Parkin

• How to Pivot values stored as rows not columns

  Hi all,  I must say at the start that I can do basic SQL so I really don't know where to start on …

  RobTurton

  7 replies

  6 days, 18 hours ago

  By: RobTurton

• SSIS File System Task Access Denied

  I have an SSIS package that writes to a csv output, saves the file locally on the server, then copi…

  jdh.eon.blue

  10 replies

  6 days, 23 hours ago

  By: lamtu007

• Joining a table based on date range - Case Statement?

  Okay - Two tables one transnational table with a standard document date Second table is financial f…

  Bron Tamulis

  6 replies

  1 week, 2 days ago

  By: Phil Parkin

• Complex Join

  I have to tables T1 and T2 that are related by two columns C1 and C2.  Both columns are null-able …

  DonlSimpson

  26 replies

  1 week, 2 days ago

  By: ScottPletcher

• SQL Server grab data for multiple rows from two tables

  So here's the two tables I'm working with StockItem: ItemID SKU …

  josh_marchant

  9 replies

  1 week, 2 days ago

  By: Jacob Wilkins

• UNIONs + PK-violations

  Hello,Some background first: I have some XML Export tracking order changes.For this we use change t…

  siggemannen

  11 replies

  1 week, 3 days ago

  By: frederico_fonseca

• SUM and JOIN 2 columns with different tables but did not SUM Qty

  Good day! Need help re SUM and JOIN 2 columns with different tables but did not SUM qty and duplica…

  glennyboy

  2 replies

  1 week, 5 days ago

  By: Cebisa

• Formatting dates returned in query

  I have a statement below in a query that is returning the invoiced date as 2020-08-24 22:00:10.493 …

  nbeason

  3 replies

  2 weeks ago

  By: Jeff Moden

• How to get RowCount and ResultSet from CTE

    Hi, I have this query CREATE TABLE #Summary(SourceQueryRowCount INT, TargetQueryRowCount IN…

  inayatkhan

  4 replies

  2 weeks, 1 day ago

  By: Phil Parkin

• SUM and JOIN 2 columns with different tables but it duplicates results

  Good day! Need help re SUM and JOIN 2 columns with different tables but it duplicates results here'…

  glennyboy

  4 replies

  2 weeks, 2 days ago

  By: glennyboy