SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• How to iterate through relation records and check every record

  Hi, i am a beginner to SQL server and wanted to write a PROC where i can traverse through a table. …

  sameer

  15 replies

  4 years, 11 months ago

  By: sameer

• 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

  4 years, 11 months 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

  4 years, 11 months 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 years, 12 months 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

  4 years, 12 months 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

  4 years, 12 months 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 t…

  RobTurton

  7 replies

  4 years, 12 months 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

  4 years, 12 months 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

  5 years 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 s…

  DonlSimpson

  26 replies

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

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

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

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

  5 years ago

  By: Jeff Moden

• How to get RowCount and ResultSet from CTE

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

  inayatkhan

  4 replies

  5 years ago

  By: Phil Parkin